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.
- 4 Answers
- 6729 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / monal
Update table statistics.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What are the diifferences between the ms sql server vs mysql?
Where is my database stored on the hard disk in ms sql server?
What is collation sensitivity?
Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.
How to transfer a table from one schema to another?
What is data modification?
How to generate create table script on an existing table in ms sql server?
Is it ok to shrink transaction log?
Using the customer, and order table in northwind database, please write a query to produce xml?
How can you append an identity column to a temporary table?
How to get the definition of a user defined function back?
What is table valued function and scalar valued functions?
What options are there to delete rows on the publisher and not on the subscriber? : sql server replication
Explain transaction isolation levels in sql server?
What is TDS(Tabular Data Stream) Gateway?
