Hey what’s up? It’s been a while. If you define a clustered index that’s not unique, SQL Server will add a hidden 4-byte column called UNIQUIFIER. You can’t see it directly but it’s there. When you add a row whose key is a duplicate of an existing row, the new row gets a new unique […] The post Large Uniquifier Values first appeared on Michael J. Swart.