Wildcat (2/17/2011)
(if the clustered index is not unique, it must have the RID attached for the uniqueness).
Nope. The only time the RID is used in a nonclustered index is when the base table is a heap (no clustered index)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability