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
- 7270 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
How to see the event list of an existing trigger using sys.trigger_events?
How can you hide the sql server instances?
What is an entity-relationship diagram (erd)?
What are the differences between DDL, DML and DCL in SQL?
If a stored procedure is taking a table data type, how it looks?
What is serializable?
How to count rows with the count(*) function in ms sql server?
A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?
What is constraints and its types?
you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration
What are key constraints?
What do you mean by acid?
Does a sql server 2005 select statement require a from?
What area unit the various kinds of info compression introduced in sql server 2008?
How to write a query with a full outer join in ms sql server?
