Observed that some SP’s / Jobs are processing late, how to
troubleshoot to improve performance?
Answer / 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 |
Can you tell me some of the common replication dmv's and their use? : sql server replication
What is key set driven?
What are the different subsets of sql?
what is the difference between delete,drop and truncate
What happens to a statement batch if there is a compilation error?
OPTIMIZATION OF SP,CURSOR,TRIGGERS
How to create a view using data from another view?
What's the information that can be stored inside a bit column?
What is best institute to Learn DotNET And SQL in chennai?
Where does the copy job runs in the log shipping primary or secondary? : sql server database administration
What is the most common trace flags used with sql server?
What is use of attribute hierarchy optimized state? : sql server analysis services, ssas