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
How to delete multiple rows with one delete statement in ms sql server?
How do you identify a foreign key?
What is named query? : sql server analysis services, ssas
How to drop an existing table?
What are approximate numeric data types in ms sql server?
How can sql server instances be hidden? : sql server security
How many clustered indexes there can be on table ?
what are different types of raid configurations? : Sql server database administration
Why transaction is important?
How to join two tables in a single query in ms sql server?
What are the aggregate and scalar functions?
How to create a user to access a database in ms sql server using "create user" statements?
can an order by clause be used in a creation of a view?
What is pivot and unpivot?
List layers of abstraction microsoft architectured to provide relational db through cloud platform ?