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 / monal
Update table statistics.
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Can we add our custom code in ssis?
Explain differentiate between a having clause and a where clause?
What are horizontal and vertical scaling?
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
Can foreign key be duplicate?
How do you make a trace?
What do you mean by the term 'normalization'?
What is the use of floor function in sql server?
Explain relational data?
What are “lock” hints?
What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?
Explain an automatic checkpoint
Can we delete data from a view?
How to use "begin ... End" statement structures in ms sql server?
What are the types of indexes?