SQL server’s non cluster index has two limitations:
- Only 16 columns can be included
- The maxium size of the index key can be only 900 bytes
With SQL 2005, you can overcome these limitations by using INCLUDE:
CREATE INDEX IDX_FOO ON FOO (COL1, COL2) INCLUDE (COL3)