SQL 2005 Index Size

Q:  In MS SQL 2000, there is a limitation of maximum length of index key to be 900 bytes. Would this limitation be revised to have it larger than 900 bytes in coming MS SQL 2005 release?

A:  From the SQL 2005 CTP Books Online:  "SQL Server 2005 retains the 900-byte limit for the maximum total size of all index key columns. This excludes nonkey columns that are included in the definition of nonclustered indexes."

Skip to main content