How many non clustered index to create in table in sql server [Resolved]

Posted by Jitendrasoft09 under Sql Server on 6/26/2013 | Points: 10 | Views : 1276 | Status : [Member] [MVP] | Replies : 3
Hi All,
I want to understand How many non clustered index to create in table in sql server, let me know if anybody knows.

Jitendra Kumar
If my post helps you, plz mark as an answer.



Responses

Posted by: Neeraaj.Sharma on: 6/27/2013 [Member] Starter | Points: 50

Up
0
Down

Resolved
SQL SERVER 2005 and below 249 Nonclustered Index

SQL SERVER 2008 and above 999 Nonclustered Index


Visit my blog

www.tutorialsqlserver.com


Jitendrasoft09, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Satyapriyanayak on: 6/26/2013 [Member] [MVP] Silver | Points: 25

Up
0
Down
249 Nonclustered Index

If this post helps you mark it as answer
Thanks

Jitendrasoft09, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Jitendrasoft09 on: 6/27/2013 [Member] [MVP] Starter | Points: 25

Up
0
Down
Good effort Satya, nice explanation, Thanks Neeraj....

Jitendra Kumar
If my post helps you, plz mark as an answer.

Jitendrasoft09, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response