What is the Maximum Number of Index per Table?

Posted by Kundan64 on 1/24/2013 | Category: Sql Server Interview questions | Views: 3666 | Points: 40

Post |

Interview FAQs |

Exclusive Questions |

Interview Home

Answer:

In SQL Server 2005:
1 Clustered Index and 249 Nonclustered Index, Total 250 Index per table.

For SQL Server 2008:
1 Clustered Index and 999 Nonclustered Index, Total 1000 Index per table.

Asked In: Many Interviews | Alert Moderator

Bookmark It

< Previous : How many different ways you can stop web worker ?

Next > : What will be out put of following code: static vo ...

Comments or Responses

More Interview Questions by Kundan64

What will be out put of following code: static void doIncrement(ref i ...
Which is/are the possible value/s of ConcurrencyMode enumeration in WC ...
Which are the available types of transport schemas in WCF?
Which type of securities are available in WCF?
By which method we can get the version of installed .Net Framework?
Can we Inherit the class defined with private constructor?
What output will be come from the code: private void ShowMessage() ...
Can we use SELECT statement in CHECK constraint statement in Create Ta ...

Latest Interview Questions

What is NLog ?
You are developing a windows forms application. The front end applicat ...
You are developing an Windows Forms Application. You want to make a co ...
You create an application that provides accessibility features. Your s ...
You are creating a Windows Forms application. The Form Border Style pr ...
You are designing a Windows Forms application. You have added a textbo ...
Which command is used to convert WSDL to a proxy
What is Spring ?
More ...