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.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi