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
- 7563 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 is the use of custom fields in report?
Detail about query optimizer?
Can group functions be used in the order by clause in ms sql server?
How we can compare two database data?
You want to implement the many-to-many relationship while designing tables. How would you do it?
What happens if null values are involved in string operations?
What is coalesce and check constraint in sql server?
List the advantages of using stored procedures?
Can the “if update (colname)” statement be used in a delete trigger?
What happens if you delete a table that is used by a view?
How to create a stored procedure with a statement block in ms sql server?
What stored by the master?
What is cursors?
What is candidate key with example?
What is normalization? Explain its different types?
