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:

http://sqlblog.com/blogs/denis_gobo/archive/2009/02/05/11743.aspx