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
- 3237 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
How do I find the default sql server instance?
What are subqueries in sql server?
How to run sql server 2005 books online on your local system?
How many database files are there in sql server 2000?what are they?
How to get a list of columns using the "sp_help" stored procedure in ms sql server?
What is dimension table? : sql server analysis services, ssas
What is the cartesian product of table?
How to get all stored procedures in sql server?
Why we need sql server?
Explain contrast amongst grouped and non-bunched records?
How to execute stored procedure in select statement sql server?
How you can change a cross join into an inner join?
Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?
Describe in brief databases and sql server databases architecture.
What is sql server query analyzer?
