Taking It Further: GUIDs vs INTs as Primary Keys
I’ve been working on improving the performance a SQL Server 2012 database that is at the back end of an enterprise-wide 3rd party application. Coming from a full-stack web development background, and knowing that the database performance is critical to the performance of a web app, I wanted to learn more about optimization. Two of the rules-of-thumb I had lived by when designing databases were: Every table should have a clustered primary key (PK). Don’t use GUIDs for clustered indexes. Ideally,…