how many non clustered index in sql server 2008,2010,2012
Answer Posted / vikram
there are 1 clustered index and...
in 2005 sql server total 249 non clustered index
in 2008 sql server total 999 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 ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is shared lock?
Why truncate is ddl command?
Explain about integration services of Microsoft SQL server?
What are the types of joins in sql?
What is the guest user account in sql server? What login is it mapped to it? : sql server security
can a table be moved to different filegroup? : Sql server administration
What is the recursive stored procedure in sql server?
What are the various editions of sql server 2017 that are available in the market?
What are the differences between union, intersect, and minus operators?
How do I determine how many instances of sql server are installed on a computer?
What is sql profiler. What are the default templates with it? : sql server database administration
What is Sqlpaging in SqlServer 2005 ?
What is a trigger and its types?
what method you can use to reduce the overhead of Reporting Services data sources?
Explain what is “asynchronous” communication in sql server service broker?