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
What are logical database components? : SQL Server Architecture
What is Sqlpaging in SqlServer 2005 ?
 Explain what is sql override for a source taLle in a mapping?
Can you explain important index characteristics?
How to create an identity column?
How to define the name and server for a new dsn?
How do you troubleshoot errors in a SQL Server Agent Job?
Is the order of columns in the set clause important in ms sql server?
How to create a ddl trigger using "create trigger" statements?
What is the purpose of forms?
Is natural join and equi join same?
Why use stored procedures in sql server?
What are different types of views?
What is use of attribute hierarchy ordered ? : sql server analysis services, ssas
Which are new data types introduced in sql server 2008?