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
Does a specific recovery model need to be used for a replicated database? : sql server replication
How to update a field in SQL after ALTERING a row?
What is a cube? : sql server analysis services, ssas
Can you explain what is sql server english query?
What do you understand by triggers and mention the different types of it?
What is 1nf 2nf?
Explain the benefits of user-defined functions?
Which autogrowth database setting is good?
What is xdr?
Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?
What is normalization? Describe its different types.
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
What is clustered vs nonclustered index?
What is shrink log file?
What’s the use of custom fields in report?