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

Answers were Sorted based on User's Feedback



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

Answer / 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

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

Answer / 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

More SQL Server Interview Questions

What is analysis service repository?

0 Answers  


What are key, name and value columns of an attribute? : sql server analysis services, ssas

0 Answers  


Does dbcc checkdb requires db to be in single_user mode? : sql server database administration

0 Answers  


Why is sql server log file full?

0 Answers  


What is key set driven?

0 Answers  






List the different types of joins?

0 Answers  


What is the disadvantage of using subquery exact after a select statement?ex. select (select * from sometable)

1 Answers  


How many types of cursor type are there?

0 Answers  


What are various ways to enhance the ssrs report?

0 Answers  


How can you see what type of locks used?

1 Answers  


tell me the disaster recovery plan

0 Answers   Microsoft,


What is the use of SCOPE_IDENTITY() function?

2 Answers  


Categories