sp_help <tablename> sp_helpindex <tablename>

How do you know which index a table is using?

Question Posted / visala

Answer Posted / visala

sp_help <tablename>
sp_helpindex <tablename>

Is This Answer Correct ?

9 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What part does database design plays a role in performance of an sql server-based application?

982

How do I find the transaction log size in sql server?

962

How will you make an attribute not process? : sql server analysis services, ssas

1089

How to locate and take substrings with charindex() and substring() functions?

1016

Can you index views?

894

What is the difference between a function and a trigger?

1081

Explain different backup plans?

942

why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration

1063

What are the transaction properties?

1015

While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?

1042

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

1017

Can you explain powershell included in sql server 2008?

938

What do you mean by acid?

995

What is sharding?

116

Why Master database is required?

1141