how many non clustered index in sql server 2008,2010,2012

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


Please Help Members By Posting Answers For Below Questions

Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio

517


What is partition, how will you implement it? : sql server analysis services, ssas

594


What is difference between unique and primary key?

473


Do you know what is a linked server in sql server?

543


What command do we use to rename a db, a table and a column?

497






What is system stored procedures?

577


What is master database? : SQL Server Architecture

522


What are commonly used mssql functions in php?

552


Difference between aggregate functions of sql?

647


Is oracle faster than sql server?

549


What happens if the update subquery returns multiple rows in ms sql server?

584


Describe in brief sql server monitoring ways.

583


What is an active database?

589


What is the difference between ddl and dml?

562


How to apply cascading referential integrity in place of triggers?

564