Home Forums Article Discussions Article Discussions by Author Discuss content posted by Gail Shaw Introduction to Indexes: Part 2 – The clustered index RE: Introduction to Indexes: Part 2 – The clustered index

  • November 11, 2009 at 8:17 am

    #1077824

    TheSQLGuru (11/11/2009)

    I am often-times disappointed that I cannot have more than one clustered index. Do you think they will ever put this most useful feature in SQL Server Gail?? :hehe:

    😀 Were you in my session on index DMVs?

    CREATE INDEX ON SomeTable (KeyColumn) INCLUDE (<All other columns in table)

    Voilà, a second '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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass