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
- 7256 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
what is a default tcp/ip socket assigned for sql server? : Sql server database administration
What is difference between materialized view and view?
What is a trigger? Why we need it?
What is the sql profiler?
How retrieve field names from the table in SQL through JAVA code?
What is the need for group functions in sql?
What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?
Is mysql better than sql server?
How to download and install the scaled-down database adventureworkslt?
What is user-defined scalar function?
Difference between LEN() and DATALENGTH() in sql server ?
What is de-normalization in sql database administration? Give examples?
What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration
What are the underflow and overflow behaviors on float literals?
How to enter date and time literals in ms sql server?
