Interested to Buy Any Domain ? << Click Here >> for more details...
Observed that some SP’s / Jobs are processing late, how to
troubleshoot to improve performance?
- 1 Answers
- 3211 Views
- I also Faced
- E-Mail Answers
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
Is natural join and equi join same?
What is difference between rownum and row_number?
What is an indexed view?
What is partition in sql server?
What are data resources?
Why would you call update statistics?
Can we write ddl in trigger?
What is the advantage of sql server?
how many type of indexing in database?
Define master database?
What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration
Define magic tables in sql server?
What is t-sql script to take database offline – take database online.
What are character string data types in ms sql server?
What are binary string data types in ms sql server?
