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 |
Do you know query execution plan?
How do I setup a sql server database?
What is difference between rownum and rowid?
Why people hate cursor?
What are all new concepts in SQL Server 2008? That is Exactly Difference between 2005 to 2008
i have account table which consists of account name,card no and card no consists 16 digits now i want to retrieve the data if card no starts from 4 then it should print visa and if it starts from 5 then it should print master so plse help me to write simple query with out store procs .
do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
What is cursors?
What protocol does sql server use?
Why I have to use stored procedures?
What is a mutating table error and how can you get around it?
What is sql server profiler?