Home Forums SQL Server 2008 T-SQL (SS2K8) unique clustered index on 2 columns RE: unique clustered index on 2 columns

  • December 12, 2010 at 5:45 am

    #1261408

    ahmed7.bi (12/12/2010)

    if the above case is right then how many columns can we include in a clustered index.???

    You can have up to 16 key columns in a clustered index, but the column sizes have to add up to less than 900 bytes.

    Tom