Daily Learning – Ugh! Guids As Primary Keys
I am working on fixing a database that uses GUIDs (i.e. uniqueidentifier) as primary keys. Our customer does a high number of inserts and generates their keys from their application or from NEWID(). In addition, their primary keys are clustered. There are many articles on the Internet that talk about the problem of using non-sequential […]