Hugo Kornelis (8/6/2012)
m mcdonald (8/6/2012)
Nice. I found this link very helpful...http://msdn.microsoft.com/en-us/library/ms175049.aspx%5B/quote%5D
I deliberately didn't include that link, as I think the information is presented there in a very confusing way. This has already resulted in two highly controversial QotD's. (One of them in fact was my inspiration for this question).
Well, I believe that I'm the author of one of those "highly controversial QotD's", and I just have to say... great question. It really makes one think. Especially with the newer index types (columnstore, and spatial (okay, 2008, but I've never used it or the XML ones yet)).
Since the title is "Index types 1"... are there more coming?
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes