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 implicit mode in sql server?
Which sql server table is used to hold the stored procedure scripts?
What is difference between unique and primary key?
How can I create a new template for import ? : sql server management studio
Explain how dts is used to extract, transform and consolidate data?
What does sql server mean?
What is an indexing technique?
What are the different types of triggers in SQL SERVER?
Determine when to use stored procedure to complete sql server tasks?
What are cascading parameters in ssrs reports?
What the different types of Replication and why are they used?
Who is the owner of a schema in ms sql server?
You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?
Explain go command in sql server?
What does top operator do?