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
- 14722 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 to modify existing triggers using "alter trigger"?
You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?
Tell me about normalization in DBMS.
What are different types of schemas?
How to execute a sql statement using odbc_exec()?
What is the maximum size of sql server database?
What is the difference between substr and charindex in the sql server?
Explain how to maintain a fill factor in existing indexes?
How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.
How to insert data with null values?
What are the types of indexes?
what types of replication are supported in sql server? : Sql server database administration
How to delete database objects with "drop" statements in ms sql server?
Difference between group by clause and having clause in SQL?
Is sql server 2016 free?
