T-SQL Anti-Patterns: Clustered GUIDs

My final T-SQL anti-pattern that I'm going to discuss is using GUIDs as a clustered index.  This is a particularly pernicious problem because it's so easy for developers to fall into it. A GUID, or globally unique identifier, is a 16-byte field which is (supposed to be) truly unique.  You can run into duplicates when…

Advertisement