Observed that some SP’s / Jobs are processing late, how to
troubleshoot to improve performance?
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 languages bi uses to achieve the goal?
How do I install sql server?
what is the system function to get the current user's user id? : Sql server database administration
1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do
How to rebuild indexes with alter index ... Rebuild?
What is dbcc?
What are “lost updates”?
optimization techinques
What are the disadvantages of merge replication?
What is unpivot?
What are the security related catalog views? : sql server security
Explain about remote stored procedure?
Can sql servers link to other servers?
What is difference between delete & truncate commands?
Determine how to use the inserted and deleted pseudo tables?