Observed that some SP’s / Jobs are processing late, how to
troubleshoot to improve performance?
- 1 Answers
- 2872 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 is sql server database?
What is query cost in sql server?
Which joins are sql server default?
What is the difference between local and global temporary tables?
How important do you consider cursors or while loops for a transactional database?
How you can change a cross join into an inner join?
What does truncate do?
Do you know how to store and query spatial data?
Can we use max in where clause?
How to access the inserted record of an event?
What are pages and extents? : SQL Server Architecture
what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration
What is replication and database mirroring?
explain different types of backups avaialabe in sql server? : Sql server database administration
How to convert numeric values to integers in ms sql server?
