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
- 7197 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
Are resultset updatable?
what's sql server? : Sql server database administration
How to create a new table in a given schema?
Explain having clause?
Explain the usage of floor function in sql server.
What is the difference between primary key and unique constraints?
Can you tell me about the concept of ER diagrams?
explain what is raid and what are different types of raid configurations? : Sql server database administration
What is merge?
What is the difference between clustered index and primary key?
What is the use of attributehierarchyvisible ? : sql server analysis services, ssas
What happens if you are trying to access a schema not owned by you?
What is normalization of database?
What are the main sources of data?
how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A
