That also helps in replication performance.
Details below:
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.
SQL Server 2005 SP3 released
Posting late though!
Link below.
Microsoft has also pushed the sp3 in it's regular Windows Updates!
Subscribe to:
Posts (Atom)