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

Filter query base on date field (3d)

Pull results from a stored procedure (3d)

Help With Query To Count Number of Pets & Vaccinations (4d)

Connect sql off network (4d)

Moving Registered Servers to a New Instance (8d)

CU 31 for 2017 Will Not Install (8d)

I get different results when I scan from a barcode reader with a different language (10d)

Spatial query in SQL server (12d)

- Advertisement -