SQL Server: Maximum number of indexes per table
One of the favorite questions in a technical interviews seems to be: What is the maximum number of indexes for a table in the SQL Server database? Following is a breakdown of the maximum number of indexes by different versions of SQL Server. I am yet to come across a scenario when a table needed to have huge number of indexes like mentioned in the listing below.
|Object||SQL Server 7.0||SQL Server 2000||SQL Server 2005||SQL Server 2008|