Quassnoi (2/7/2010)
The reference you mentioned explicitly states that when a secondary index is not declared UNIQUE, it contains the values of the clustered key in the key-level pages:
:laugh: Typical. Oh well, my mistake there then - sorry about that. I should have checked which way round it was.
It's an interesting blog entry though isn't it? Makes you think.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi