Unique and non-unique non-clustered indexes on a unique clustered index
In the last weblog post I have talked about the difference of unique and non-unique clustered indexes. As you have seen SQL Server uses an internal overhead of 4 bytes (the so-called uniquifier) to make non-unique clustered index rows unique. Today I want to work out the difference between unique and non-unique non-clustered indexes defined …
Unique and non-unique non-clustered indexes on a unique clustered index + read more
