Posted by --CELKO-- on 09/27/07 13:41

>> Other than size, is this significantly different from any other type of artificial record key, e.g. INT IDENTITY? <<

GUIDs are globally unique (we hope!) and IDENTITY is local to one
table in one schema on one machine. But neither of them is an
attribute of an entity in a data model, neither has validation and
verification, etc.

And I am glad that you called a **record key** since so many newbies
don't understand physical records versus logical rows. If you grew up
with a sequential file system, it is hard to lose that mindset.

[Back to original message]