Interested to Buy Any Domain ? << Click Here >> for more details...
What is one of the first things you would do to increase
performance of a query? For example, a boss tells you that
?a query that ran yesterday took 30 seconds, but today it
takes 6 minutes?
- 2 Answers
- 16018 Views
- Accenture, Merrill Lynch, Wipro, I also Faced
- E-Mail Answers
Answer Posted / george
I think the first thing we need to check for the index
defragmentation, truncating transaction log and shrinking
the tempdb as well, this is because first time the query
get executed in the short time only 30 Sec, however second
day time execution increased
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
How are the exceptions handled in sql server programming?
What are the common performance issues in sql server?
What are commonly used odbc functions in php?
What do you understand by triggers?
Can we write trigger for view?
what stored procedure would you use to view lock information? : Sql server administration
What are the rules to use the rowguidcol property to define a globally unique identifier column?
Explain about SQL server 2005?
Is sql different from sql server?
What is difference between commit and rollback when used in transactions?
Delete duplicate rows without using rowid.
How to query multiple tables jointly?
How to identify current user in ssrs report?
When would you use the stored procedures or functions?
Does order by actually change the order of the data in the tables or does it just change the output?
