Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7312 Views
- Satyam, I also Faced
- E-Mail Answers
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
tell me the disaster recovery plan
Which rendering formats are affected by the pagesize properties?
What is index in an assignment?
What is the purpose of the tempdb database?
Do you know what are the restrictions applicable while creating views? : SQL Server Architecture
Explain filtered indexes?
what is isolation level at dead lock?
What the different topologies in which replication can be configured?
explain declarative management framework (dmf) in sql server 2008?
How to use column default values in insert statements in ms sql server?
Do you know concepts and capabilities of sql server?
How does clustered and non clustered index work?
Explain the Ways to improve the performance of a sql azure database?
What is the difference between a clustered index and a non-clustered index?
Can you get second highest salary from the table?
