how many non clustered index in sql server 2008,2010,2012
Answers were Sorted based on User's Feedback
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 |
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 |
What is analysis service repository?
What are key, name and value columns of an attribute? : sql server analysis services, ssas
Does dbcc checkdb requires db to be in single_user mode? : sql server database administration
Why is sql server log file full?
What is key set driven?
List the different types of joins?
What is the disadvantage of using subquery exact after a select statement?ex. select (select * from sometable)
How many types of cursor type are there?
What are various ways to enhance the ssrs report?
How can you see what type of locks used?
tell me the disaster recovery plan
What is the use of SCOPE_IDENTITY() function?