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
- 3155 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
What are the steps you must follow to hide sql server instances?
Explain the stored procedure?
What is efficiency data?
What are basics of policy management?
Explain what is lock escalation and what is its purpose?
Using the customer, and order table in northwind database, please write a query to produce xml?
Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?
Can we insert data if clustered index is disabled?
What is the chart in report?
What are “lock” hints?
What is failover clustering overview?
What do you know about normalization and de- normalization?
Explain system views?
what is datawarehouse?
When you should use a low fill factor?
