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
You want to implement the one-to-many relationship while designing tables. How would you do it?
How to change the password of a login name in ms sql server?
List the types of recovery model available in sql server?
Explain difference between control flow and data flow?
What is pessimistic concurrency?
How to list all columns in a table using odbc_columns()?
How to create database with physical files specified in ms sql server?
Explain various On-Delete options in a DB table. Which is the default option?
Explain the difference between primary keys and foreign keys?
What are two difference between sql azure and azure tables?
Explain the microsoft sql server delete command?
What are the different normalization forms?
Explain “row_number()” in sql server with an example?
What are the restrictions that views have to follow?
What happens if strings are casted into wrong code pages in ms sql server?