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
|