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
- 15871 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
Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?
What are the authentication modes in sql server? How can it be changed?
Can a cursor be updated? If yes, how you can protect which columns are updated?
what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?
When columns are added to existing tables, what do they initially contain?
How to provide column names in insert statements in ms sql server?
Define magic tables in sql server?
Define master database?
What is the data tier application?
What is log shipping? Can we do logshipping with SQL Server 7.0 ?
What is change tracking in sql server?
What are the hotfixes and patches in sql server?
What are the types of lock supported by ?
What are different backups available in sql server?
How to insert a new row into a table with "insert into" statements in ms sql server?
