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
in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it
What are Spatial data types in SQL Server 2008
I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
How would we use distinct statement? What is its use?
What is the primary use of the model database?
What is a user-defined function in the sql server and what is its advantage?
What is the main purpose of having conversation group?
what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration
How sql server executes a statement with nested subqueries?
What is data source in connection string?
What is row-level compre?
What number sorts of privileges are accessible in sql?
Explain what are the basic functions for master, msdb, model, tempdb databases?
What is a transact-sql statement?