Techorama 2017 has ended
Back To Schedule
Tuesday, May 23 • 13:45 - 14:45
UNIQUEIDENTIFIERs as Primary Keys in SQL Server

Log in to save this to your schedule, view media, leave feedback and see who's attending!

Feedback form is now closed.
UNIQUEIDENTIFIERs as Primary Keys in SQL Server - a good or bad best practice? They have a lot of pros for DEVs, but DBAs just cry when they see them enforced by default as unique Clustered Indexes. In this session we will cover the basics about UNIQUEIDENTIFIERs, why they bad and sometimes even good, and how you can find out if they affect the performance of your performance critical database. If they are affecting your database negatively, you will also learn some best practices how you can resolve those performance limitations without changing your underlying application.

avatar for Klaus Aschenbrenner

Klaus Aschenbrenner

Klaus Aschenbrenner provides with his company SQLpassion SQL Server consulting & training services across Europe. Klaus works with SQL Server for more than 16 years. Klaus has also written the book Pro SQL Server 2008. Further information about Klaus you can find on his homepage at... Read More →

Tuesday May 23, 2017 13:45 - 14:45 CEST
Room 2