• Good description there Steve. One minor point - the 'uniquefier' for non-unique clustered indexes is 4 bytes, not 2.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service