ChrisM@Work (3/5/2014)
I think most folks do now know that the cluster keys behave similarly to include columns in nc indexes
Key columns, unless the nonclustered index is defined UNIQUE. Not similar to, identical to (except for the not appearing in script, but that's because they weren't specified explicitly)
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