Sql server DBA Inter view questions

What are the steps to take to improve performance of a poor performing query?
Maximum use of indexes, stored procures should be done.
Avoid excessive use of complicated joins and cursors.
Avoid using conditional operators using columns of different tables.
Make use of computed columns and rewriting the query.

Download more questions