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
Does a specific recovery model need to be used for a replicated database? : sql server replication
What is the difference between push and pull subscription? : sql server replication
What's new in sql management studio for sql server? : sql server management studio
Explain iaas, paas and saas?
Explain about Joins?
What is use of attributehierarchyenabled? : sql server analysis services, ssas
how many no of arguments can be passed in procedures and functions
how to define testing of network layers? : Sql server database administration
Do you know concepts and capabilities of sql server?
What is a transactions?
What are subqueries in sql server? Explain its properties.
How and why use sql server?
What is entity data services?
Which is the latest version of sql server and when it is released?
what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration