title: Which is the most common ID type in SQL Server databases, and which is better?
body: <p>Is it better to use a Guid (UniqueIdentifier) as your Primary/Surrogate Key column, or a serialized "identity" integer column; and <strong><em>why</em></strong> is it better? Under which circumstances would you choose one over the other?</p>