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 / jerry joseph
Number of hits might have increased..
you can try increasing the timeout
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What does it mean if @@cursor_row returns a negative number?
How to make a column nullable?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?
there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration
What is the osql utility?
Why do we need normalization?
Can you explain different types of locks in sql server?
What are policy management terms?
Tell me the difference between clustered and non-clustered index?
What is the difference between cartesian product and cross join?
Explain the third normal form(3nf)?
What is an index. What are the types?
Differentiate between a local and a global temporary table?
What is use of except clause? How it differs from not in clause?
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?