upstart (10/27/2010)
Would you ever want to have a Non-Clustered and Clustered Index that are the same? For some reason, I inherited several tables that have NC and C indexes that only reference one column.
There's an application for this and an analysis of the performance implications here:
http://www.sqlservercentral.com/articles/paging/69892/