Viewing 2 posts - 1 through 2 (of 2 total)
GilaMonster (7/27/2011)
Non-unique clustered indexes get a uniquifier, which is 4 bytes (an int) added to rows that have duplicate values for the clustering key.
Nonclustered indexes get either the clustering...
July 27, 2011 at 3:13 am
#1359020
Little remark... All non-unique non-clustered indexes are created with a sysem internal unique id, 8 bytes in size, so that sql could differentiate each row. These id "columns" aren't visible...
July 27, 2011 at 12:32 am
#1358966