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
Define outer join in sql server joins?
Distinguish between commit and rollback?
What is merge statement?
How to connect sql server management studio express to sql server 2005 express?
What are the aggregate and scalar functions?
What is "scheduled jobs" or "scheduled tasks"?
What is the exact numeric data type in sql?
Why does sql studio use a single registered database repository? : sql server management studio
What is report snapshot?
Define outer join?
What is cursors? And what are the different types of cursor?
What is subreport?
How can you set the threshold at which sql server will generate keysets asynchronously?
What is autocommit mode in sql server?
what is blocking? : Sql server database administration