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
- 3241 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
explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
How to override dml statements with triggers?
Explain about builtinadministrator?
How do triggers work?
If a table does not have a unique index, can a cursor be opened on it?
Is sql server difficult to learn?
Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)
How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?
Can you name some of the dml commands in sql?
What is tablesample?
what are database files and filegroups? : Sql server database administration
Explain four layers of abstraction microsoft architectured?
How do I uninstall sql server 2014?
How to see the event list of an existing trigger using sys.trigger_events?
What the different types of Replication and why are they used?
