Browsed by
Tag: GUID

Taking It Further: GUIDs vs INTs as Primary Keys

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,…

Read More Read More