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

Does the EdbMails support attachment recovery? (3h)

SQL Setup (12h)

DW Design help (1d)

Composite indexes and best practice for Interval-valid values (1d)

Need help writing SQL query to find value from a table based on two specific values (2d)

Backup history not showing - Sql server 2012 (2d)

Get the latest person initial last entered by date....REVISED (2d)

SQL Query singular column date as at today (2d)

- Advertisement -