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
- 15056 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
what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration
What is bit data type? What's the information that can be stored inside a bit column?
What is the function of inner join?
What is ms sql server service broker?
You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?
What do you mean by sql server agent?
Describe how to use the linked server?
What is a field name?
difference between Clustered index and non clustered index ?
Is it possible to call a stored procedure within a stored procedure?
What are triggers? How do you invoke a trigger on demand?
What is SQL Azure Data sync?
What are the differences between union, intersect, and minus operators?
Can group functions be mixed with non-group selection fields in ms sql server?
What is report rendering ?
