How do you know which index a table is using?

Answer Posted / chandra rekha

sp_helpindex command gives the information of the indexes
on the table

Is This Answer Correct ?    10 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What kind of problems occurs if we do not implement proper locking strategy?

958


Explain various data region available in ssrs with their use?

483


What are sql server functions?

503


What is the difference between dbcc indexdefrag and dbcc reindex?

513


How can you stop stored procedures from recompiling?

480






Scalability, Availability, Integration with internet, etc.)?

2424


What is "scheduled jobs" or "scheduled tasks"?

548


How many instances per computer are there in sql server 2000?

574


What is the New in SQL server 2008?

571


what is denormalization and when would you go for it? : Sql server database administration

697


How can we call UDF(User Define Function) using C# code in ASP.net ?

5921


Do you know the policy based administration feature of sql server 2008?

567


How to create new tables with "select ... Into" statements in ms sql server?

504


What happens if date-only values are provided as date and time literals?

530


In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

1505