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."