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?
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
What is bcp? When does it use?
What is resource governor in sql server?
Is null vs coalesce?
Explain full-text indexing?
How are the exceptions handled in sql server programming?
Can you explain various data region available in ssrs with their use?
How you trouble shoot when any job fails
What can be used instead of trigger?
How can you tell if a database object is invalid?
What the different types of Replication and why are they used?
What is function of CUBE ?
How to update values in a table with update statements in ms sql server?
Does partitioning improve performance sql server?
What are unicode character string data types in ms sql server?
What is the difference between writing data to mirrored drives versus raid5 drives