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
- 7382 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / arun sql gamer
Might be a performance tuning problem.Previously it may
have less data ,since it wont give u that much trouble in
processing the query.Subsequently the size of the data may
get increased which leads to more processing time of query
hence forth arrive with the problem of tuning and to check
for proper indexing in table and also in query.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
How do you test your database? : sql server database administration
What is SubQuery in SQL Server 2008
How to run sql server 2005 books online on your local system?
What are the requirements on sql server network connections?
What is parameterized reports in ssrs ?
How to delete duplicate rows from table except one?
What is data mart? : sql server analysis services, ssas
How dts is used to extract, transform and consolidate data?
What is a table called, if it has neither cluster nor non-cluster index? What is it used for?
What are alternate keys?
Explain the first normal form(1nf)?
What is trigger explain with program?
Explain magic tables in sql server?
What are the differences between union, intersect, and minus operators?
What are the ways available in sql server to execute sql statements?
