Browsed by
Author: John Penn

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

We Have Lift-Off

We Have Lift-Off

Welcome to my SQL Server blog!  As I continue to learn more about this product and how to best use it, I plan to share those lessons here so that they may be of help to others. Although I’ve been using SQL Server since v6.5 as a full-stack developer, my recent work assignments have provided me with opportunities to gain more in-depth knowledge about it, especially in the areas of performance optimization and configuration. I’ve decided to shift the focus of…

Read More Read More