What You Know About Maximum Number Of Non Clustered Index In Sql Server

What You Know About Maximum Number Of Non Clustered Index In Sql Server ? You may not be creating so many non clustered indexes but the interviewer may want to know how in depth you know about sql server indexes. If you answer this questions with the
old and new version details then it will be cool for this question. So, you can find this details as below for different version of Sql server.
In 2005 , 1 clustered index and 249 non clustered index.
In 2012,2014 , 1 clustered index and 999 non clustered index.
In 2016, 1 clustered index and 999 non clustered index.

 1,632 total views,  2 views today