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
- 7388 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
What are the differences between sql server and mysql.
Why are views required in the sql server or in any other database?
Can you name some of the dml commands in sql?
What is temporary table in sql server? Why we use temp table?
What is the difference between a clustered index and a non-clustered index?
What specific conditions database should meet, before you can bulk copy data into it using bcp?
How raid can influence database performance?
What is tabulation?
What is an indexing technique?
What are the methods used to protect against sql injection attack?
When you use @@error and try-catch?
How do triggers work?
What is the sql server agent?
What is BCNF? How is it better than 2NF & 3NF?
Can we add a cpu to sql server?
