Paul White NZ (5/27/2010)
jts_2003 (5/27/2010)
A quick search on Microsft's website:http://msdn.microsoft.com/en-us/library/ms175049.aspx
This clearly gives 8, which wasbn't even an option!
Not my favourite question, although it did make me think a bit more about indexes I suppose...
If only the question had been about index types!
As it was, it was about types of index structures.
Several people made the same error.
Okay, I'm curious. What could I have done better to make it clearer that this question was about the different types of index structures, and not the different types of indexes? Should I have specifically said (NOT index TYPES, but types of index STRUCTURES)?
I did not want this to be a confusing question, and I didn't think it was, yet many people missed this and have complained about it.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes