FREE Subscription to Dr. Dobb’s Digest: Same Great Content, New Digital Edition
Site Archive (Complete)
Windows .NET Blog: Sequential IDs -- Security and Performance
Windows/.NET
DOCUMENT OUTLINE

Notes on DotNet

by John Dorsey
Practicing .NET

Improving developer productivity and software quality

by Mark M. Baker
June 29, 2006

Sequential IDs -- Security and Performance

In a recent SQL Junkies article Rob Garrison took a look SQL Server 2005 method for creating sequential IDs with the uniqueness benefits of GUIDs: Exploring NewSequentialID() in SQL Server 2005 (RTM). Rob has some interesting advice on the security implications of NEWSEQUENTIALID() as well as the performance characteristics as copared to bigint IDENTITY.

Posted by John Dorsey at 03:03 AM  Permalink




 
INFO-LINK