How do you know which index a table is using?

Answer Posted / hari

sp_helpindex tabelname

Is This Answer Correct ?    14 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?

616


What is the default server name for sql server?

630


What is the data tier application?

145


How do I get Report Builder to generate a parameter that can be set by users viewing the report?

100


What are the new security features added in sql server 2012? : sql server security

525






Can multiple columns be used in sql group by clause in ms sql server?

536


What are the new features in SQL Server 2005 when compared to SQL Server 2000?

616


Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

1522


How to encrypt data between dialogs?

562


What do you understand by replication in sql server?

567


Define full outer join?

514


What are 3 ways to get a count of the number of records in a table?

602


How much memory that we are using in Logshipping Concept?

1361


What are ddl triggers and types of ddl trigger?

600


How many columns can we include on clustered index ?

503