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

How to write SQL query to export custom data (15h)

Merge two fields from one table with one field from another table (22h)

Regarding SQL server agent not working (3d)

How to join 2 tables with many-to-one relationship (3d)

Table normalization, I can’t remove duplicates (4d)

Pivot table not displaying date values (5d)

Taking the Average of a speficic range and writing into a column (5d)

Openrowset command & removing unwanted characters (5d)

- Advertisement -