how many non clustered index in sql server 2008,2010,2012
- 2 Answers
- 6511 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / dilipkumar
there are 1 clustered index and...
in 2008 sql server total 249 non clustered index
in 2010 sql server total 999 non clustered index
in 2012 sql server total 999 non clustered index.
| Is This Answer Correct ? | 15 Yes | 1 No |
Post New Answer View All Answers
What is the purpose of the master database?
List the different index configurations possible for a table?
How do I save a stored procedure in sql server?
Explain trigger and its types?
Can we linked SharePoint to a SQL database?
What are the different types of join?
Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .
What is normalization of database? What are its benefits?
What are the characteristics of modern DBMS?
How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?
What happens if null values are involved in comparison operations?
You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?
What is resource governor in sql server?
How can we determine what objects a user-defined function depends upon?
What are the recovery models for a database?
