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 |
What is policy based management (pbm)? : sql server database administration
What is raid, and how it can influence database performance?
Why main is user defined function?
What is the system function to get the current user's user id?
What is policy management?
How to display a past time in days, hours and minutes?
What is perspective, have you ever created perspective? : sql server analysis services, ssas
IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do
How extra digits are handled with numeric data type literals?
Write a sql query to delete duplicate records from a table called table1
How to provide column names in insert statements in ms sql server?
Difference between LEN() and DATALENGTH() in sql server ?