Observed that some SP’s / Jobs are processing late, how to
troubleshoot to improve performance?
Answer Posted / neetu
U have to optimize SP for that
1. Use as much as possible WHERE clause filters. Where
Clause is the most important part for optimization
2. Select only those fields which really require.
3. Joins are expensive in terms of time. Make sure that use
all the keys that relate the two tables together and don't
join to unused tables, always try to join on indexed fields.
The join type is important as well (INNER, OUTER).
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is instead of trigger sql server?
What is the command used to check locks in microsoft sql server?
What is fill factor and pad index?
which backup strategy you are following at ur company
You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?
How to disable triggers using "disable trigger"?
What are different types of join?
Explain contrast amongst grouped and non-bunched records?
Explain indexed views and partitioned view with their syntax.
what are the important architecture components of SSRS?
Explain the third normal form(3nf)?
Can you leave a union at any time?
What is table valued function and scalar valued functions?
It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio
Benefits of Stored Procedures?