Uniqueifier details in SQL Server

This is a follow up post for https://blogs.msdn.microsoft.com/psssql/2018/02/16/uniqueifier-cons…ns-and-error-666/, for the ones that want to delve into the subject. First a quick background on uniqueifiers… A uniqueifier (or uniquifier as reported by SQL Server internal tools) is a 4-byte value used to make each key unique in a clustered index that allow duplicate key values. This…

0