SQL Server Database Administrator Question: Download Questions 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.
Download SQL Server DB Administrator Interview Questions And Answers
PDF
Previous Question | Next Question |
What is a correlated sub-query? | What authentication modes does SQL Server support? |