• I have heard from more than one person that all columns in the clustered index also show up in each non-clustered index on that same table, which is why you should keep your clustered index columns to the bare minimum you can get away with.

    Is this true?

    -------------------------------------------------------------------------------------------------
    My SQL Server Blog