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
- 7373 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / monal
Update table statistics.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?
How can delete duplicate records in cte in sql server?
What function does a database engine serve in the sql server?
What is serializable?
Is it safe to delete log files?
What is the difference between a unique key and primary key?
Explain relational data?
what are the different stages of Report Processing?
Where is my database stored on the hard disk in ms sql server?
Tell me what is normalization? Explain different forms of normalization?
What is transaction server auto commit?
This question asked during interview, 2) At the end of each month, a new table is created for each bank that contains monthly metrics consolidated at the account level. The table naming convention is bankX_YYYYMM where X represents the numeric designation of the bank and YYYYMM indicates the 4 digit year and 2 digit month. The tables contain the following fields: name data type description account text account number registered boolean indicates whether the account is registered num_trans integer number of transactions made during the time period spend numeric(9,2) total spend during the time period a) Write a SQL query that will display the total number of transactions and total spend for "Bank1" during the 4th quarter of 2009. b) Write a SQL query that will display the total number of transactions and total spend at "Bank1" and "Bank2", broken out by registered vs. non-registered accounts, during January 2010 not sure what is correct answer and how to solve?
Explain user defined functions?
How to select true false based on column value in sql server?
How can we delete a table in sql server?
