GilaMonster (12/7/2010)
SanDroid (12/7/2010)
Although what you say is correct, your wording also seems misleading.Why?
GilaMonster (12/7/2010)
Another phrasing problem with the question - the maximum size of an index is not 900 bytes. The maximum size of the key columns is 900 bytes. The index row can technically be up to 8000 bytes.Index key columns, excluding nonkeys, must follow the existing index size restrictions of 16 key columns maximum, and a total index key size of 900 bytes.
😎
What's different about what you said and what I said?
I think he is trying to say the difference between "total index key size of 900 bytes" and "maximum size of the key columns is 900 bytes". I don't know but can the "total key size" ever be larger than the "size of the key columns"? (Like in the case of a uniquefier automatically added to a clustered index?)