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
- 3320 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
What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration
What are views in ms sql server?
Explain “@@rowcount” and “@@error” in sql server?
Sql server reporting services vs. Crystal reports.
Which data type columns are the best candidates for full-text indexing?
How can you fetch alternate records from a table?
I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?
what is a sub-report?
What is system stored procedures?
What is dirty read?
What is a trigger in sql server?
Tell me what is the difference between locking and multi-versioning?
Is the primary key column of a table an index in ms sql server?
What is an expensive query?
What is the xml datatype?
