RalphWilson (3/1/2010)
IMHO, if you must use a GUID for your Identity column (and I will concede that there are times when that is the proper choice 😉 ) then you should make it a Unique Key/Index instead of a PK.
There's nothing wrong with a GUID primary key, as long as it is PRIMARY KEY NONCLUSTERED
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability