The Cost of GUIDs as Primary Keys

By Bill Graziano on 8 January 2005 | Tags: Data Types , Indexes


Kristen submitted "In this article, Jimmy Nilsson presents the pros and cons of using globally unique identifiers (GUIDs) as the datatype for primary keys in SQL Server 2000. In doing so, he shows you test results that hint of performance characteristics and introduces you to a special type of GUID that he invented, called COMBs, that solves what otherwise might give you a big throughput problem.

He also point out that GUIDs are not guaranteed to be 'Globally Unique'"

Link: The Cost of GUIDs as Primary Keys


Related Articles

Using the TIME data type in SQL Server 2008 (6 March 2008)

Using Included Columns in SQL Server 2005 (14 January 2008)

Using the DATE data type in SQL Server 2008 (6 December 2007)

SQL Server Indexes: The Basics (26 November 2007)

Working with Time Spans and Durations in SQL Server (15 October 2007)

DATEDIFF Function Demystified (20 March 2007)

Using Indexed Computed Columns to Improve Performance (16 January 2007)

Microsoft SQL Server 2000 Index Defragmentation Best Practices (2 May 2004)

Other Recent Forum Posts

Indexing for Compute Column concatenate columns (14h)

How to export data from table exceed 5 milion rows to excel? (1d)

Duration column totaling issues (1d)

Unable to use the SQL function in my SSRS SELECT Statement as text in Dataset Properties (1d)

CREATE SQL Format custom (1d)

How to change the value in xml tag reading from select query result (2d)

How to find largest value in a varchar column (3d)

Agent job with xp_cmdshell to move files (3d)

- Advertisement -