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 / prasad
Im giving few suggestions known to me.
- Update table statistics regularly.
- ur log might be full. clear the log using dump tran with
no_log
- if u r connecting ur server in a network, check the
network connections.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
Explain about thread and memory management process of SQL?
what are user defined datatypes? : Sql server database administration
What is the parse query button used for?
Does the order of columns in update statements matter?
Explain the working of sql privileges?
What type of Index will get created after executing the above statement?
What is a join in sql? What are the types of joins?
What is merge replication?
How do you set a trace flag in sql server?
How to delete duplicate rows from table except one?
How to delete database objects with "drop" statements in ms sql server?
What Is Rdbms?
How to list all objects in a given schema?
What is the difference between Clustered and Non-Clustered Index?
What is 3nf normalization form?