• I chose an incorrect answer so I could get the llink to this discussion. And then, I was even rewarded with a point.

    To add to the others, the correct answer for SQL Server 2005 (which is mentioned explicitly in the question) is not included. And to correct them, the correct answer for SQL Server 2008 is not listed either.

    For SQL Server 2005:

    Up to 1 clustered index, up to 249 nonclustered indexes, and up to 249 XML indexes (http://msdn.microsoft.com/en-us/library/ms143432%28SQL.90%29.aspx), plus a number of full-text indexes for which I was unable to find a maximum

    For SQL Server 2008:

    Up to 1 clustered index, up to 999 nonclustered indexes, and up to 249 XML indexes (http://msdn.microsoft.com/en-us/library/ms143432.aspx), plus a number of full-text indexes and a number of spatial indexes for which I was unable to find the maximums.

    That makes the correct answers: 499 + max FT indexes for SQL Server 2005, and 1249 + max FT indexes + max spatial indexes for SQL Server 2008.

    (edit - corrected a silly mistake, as pointed out by vk-kirov)


    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/