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
- 16141 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
Describe and explain about SQL native client?
What command would you use to create an index?
What are the differences between stored procedure and view in sql server?
Explain how to use linked server?
What is provisioning, billing and metering, and connection routing concepts in the service layer?
What is equi join with example?
Tell me extended events in sql server 2008?
How do I find the transaction log size in sql server?
What is normalization? What number of normalization shapes are there?
How can you ensure that the database and sql server based application perform well?
How do we Backup SQL Azure Data?
Can you please explain the difference between function and stored procedure?
What are “unrepeatable reads”?
What is the difference between stored procedure and functions?
what is a join and explain different types of joins? : Sql server database administration
