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

What is the stuff and how does it differ from the replace function?

730


Explain a differential backup?

751


Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?

702


what is the difference between count(*) and count(1) ?

808


Explain the functionalities that views support?

853






What is bit data type?

795


How to create indexed view?

732


What is data source view or dsv? : sql server analysis services, ssas

753


If you want to send some data from access database to sql server database. What are different component of ssis will you use?

681


How do I clean up sql server transaction log?

742


how to do partition in sqlserver

2146


What are system databases into sql server (2005/2008) : sql server database administration

760


How to sort the query output with order by clauses in ms sql server?

814


Can we take the full database backup in log shipping?

717


What are translations and its use? : sql server analysis services, ssas

794