SQL Server Database Administrator Question: Download SQL Server DB Administrator PDF
What are the steps to take to improve performance of a poor performing query?
Answer:
► 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.
► 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.
| Previous Question | Next Question |
| What is a correlated sub-query? | What authentication modes does SQL Server support? |