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

Transfer to new windows 11 computer (4d)

Pivot data but keep equal number per metric (8d)

Change Font Size In T-SQL Message Window? (9d)

Who has joined and who has left (11d)

Linked Server Selection Query Fails with "MS DTC has stopped this transaction" (15d)

Query almost perfect but brings wrong record (15d)

Installing integration Services with Web edition (17d)

Can I add dynamic WHERE clause to this query? (17d)

- Advertisement -