Answer – Objective Question (Number of non clustered indexes possible on a Table in SQL Server 2008R2)

Question :- 

How many non clustered indexes are possible in a table in SQL Server 2008R2

1)  1
2) 249
3) 999  (Correct answer)
4) None of these
 21 people gives answer to this Question and most of them is correct.
Correct answer is 999 (Option 4).
In SQL Server 2008 onwards, we can create 999 non clustered indexes and 1 clustered Index.
In SQL Server 2005 We can create 249 non clustered Indexes and 1 clustered Index.

Related Article

About vivekjohari

Database Consultant with more than 11.5 years of experience in database designing & programming and DBA related activities.  Had good experience on different databases like SQL Server, MySQL & Oracle, Azure SQL &  Big Data.
This entry was posted in Interview Questions and tagged . Bookmark the permalink.

Leave a Reply