Monday, February 09, 2009

OLD newid VS newsequentialid

SqlServer 2005 has introduced newsequentialid to avoid page-splits by producing bigger value than the last generated value against its predecessor newid which generates random values causing I/O issues.
That also helps in replication performance.

Details below:

SQL Server 2005 SP3 released

Posting late though!
Link below.