How to view existing indexes on an given table using sys.indexes?

Question Posted / sanjeev saxena

No Answer is Posted For this Question
Be the First to Post Answer

More SQL Server Interview Questions

What are the difference between “where” and “having” clause in sql server?

What is Schema? and why we use schemas?

What are the type of joins? When do we use Outer and Self joins?

Explain filtered indexes benefits?

Does sql server 2000 clustering support load balancing?

Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

How we can compare two database data?

Which data type columns are the best candidates for full-text indexing?

Explain about service Broker functions?

Can you move the resources after pausing the node? : sql server database administration

What are the basic functions for master, msdb, model, tempdb and resource databases?

what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration

For more SQL Server Interview Questions Click Here