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
- 7558 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 can you check the level of fragmentation on a table? : Sql server administration
what are the reporting service components in SSRS?
How to create “dependant” parameter “make, model, year”
What is the optimization being performed in oracle and SQL Server?
What is inner join? Explain with an example?
Is sql server a database?
Tell me what is the significance of null value and why should we avoid permitting null values?
Explain view in sql server?
How can I track the changes or identify the latest insert-update-delete from a table?
What are some examples of schemas?
Which sql server table is used to hold the stored procedure script?
How to throw custom exception in Stored Procedure?
Find columns used in stored procedure?
Can a table be moved to different filegroup?
What is the function of sql server agent windows service?
