Interested to Buy Any Domain ? << Click Here >> for more details...
how many non clustered index in sql server 2008,2010,2012
- 2 Answers
- 7074 Views
- Accenture, I also Faced
- E-Mail Answers
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 delete query?
Explain a checkpoint?
List the types of recovery model available in sql server?
What are transactions in sql?
you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration
What is primary key and example?
What is join and name different type of joins?
Where in ms sql server is ’100’ equal to ‘0’?
Explain throw statement in sql server 2008?
How to rebuild master databse?
code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that
What is sql injection and why is it a problem? : sql server security
how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration
What is compression - row-level and page-level compression?
How check triggers in sql server?
