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
How to start and end transact-sql statements?
How to use wildcard characters in like operations in ms sql server?
What is merge join?
What is the difference between having clause and where clause in sql server?
What is an execution plan? How would you view the execution plan?
How can I track the changes or identify the latest insert-update-delete from a table?
How will you hide an attribute? : sql server analysis services, ssas
What do you understand by the denormalisation?
What is snapshot parameter in ssrs?
What are indexes in sql?
Explain about SQL server 2005?
Can We Use Data-grids For Our Report In Ssrs?
Explain difference between control flow and data flow?
How to create a view on an existing table in ms sql server?
What are the different types of columns types constraints in the sql server?