I have a huge amount of data which is displayed in a
report. The data is viewed every day. Every day the data is
displayed in 30 secs but suddenly today it is giving an
timeout message today. Data has not been changed. The
situation is same as yesterday. What might be the reason???
Please Answer.
Answer Posted / monal
Update table statistics.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is the query and subquery?
Why should you use or avoid select * statements?
What do you mean by authentication modes in sql server?
What is an execution plan?
What is the difference between inner join and equi join?
What is a fill factor?
Difference between Logical Page and Physical Page in SSRS.
can you instantiate a com object by using t-sql? : Sql server database administration
What are click through reports?
how would you troubleshoot blocking? : Sql server database administration
What are the commands used in DCL?
Which trace flags are enabled in sql server?
How to insert stored procedure result into temporary table?
How to add code to the existing article (using improve article)?
Explain the difference between functions and stored procedures in sql server?