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   Satyam,

---

Give me any three differences between Truncate and Delete.

0 Answers   Genpact,

---

What is use of attribute hierarchy optimized state? : sql server analysis services, ssas

0 Answers  

---

What is subquery in sql?

0 Answers  

---

What is the architecture of ms sql reporting service?

0 Answers  

---

---

I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?

0 Answers   IBM,

---

Explain intellisense for query editing

0 Answers  

---

What is a data source file?

0 Answers  

---

What do you understand by a view?

0 Answers  

---

1. What is CUBE Operator? 2. what are the new data types are available in sql server 2008? 3. Inisde a nested queries, how many subqueries u can have?

3 Answers  

---

Their are two tables 'A' and'B'.Table 'A' contains 3 columns named 'eid','ename','dept'. Table 'B'contains 3 columns named'sid','designation','salary'. We have to retrieve the names of employees working in the same department,same designation and same salary. Its urgent can anyone help me out in this problem.

6 Answers   Tech Mahindra,

---

How will you collect the date from current date to last older 6 days date in sql server 2005

4 Answers  

---