Friday, March 9, 2012

newsequentialid

HI

Does anyone know if the sentence below from BOL means newsequentialid does not generate unique id on computer with network card? we have a sql database that uses newid for several tables, I want to switch to newsequentialid to reduce page splits

The GUIDs generated by NEWSEQUENTIALID() are unique within a particular computer only if the computer does not have a network card

thanks

Pauli

Hi,

see this article for more information:

http://sqljunkies.com/Article/4067A1B1-C31C-4EAF-86C3-80513451FC03.scuk


HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

No comments:

Post a Comment