Suppose i have one sql query that contains 2 minute to execute.After one weekly i am executing same query that is taking 5 minute.Why our same query is taking more time.what would be my approach to reduce execution time.Please help.

1 Answers   Cognizant, HCL, Value Labs,

---

How can I create a new template for import ? : sql server management studio

0 Answers  

---

let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration

0 Answers  

---

What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?

0 Answers  

---

what are the Prerequisites for Replication?

1 Answers   IBM,

---

What function does a database engine serve in the sql server?

0 Answers  

---

What are different types of join?

0 Answers  

---

Can Having clause be used without Group by clause?

6 Answers   CarrizalSoft Technologies, CSC, CTS,

---

Explain what is the use of custom fields in report?

0 Answers  

---

what's the difference between SQL & MY-SQl...? And what we learn from these ....?

2 Answers   Broadridge,

---

How to write stored procedure to update the data in 10 tables

4 Answers  

---

What are the difference between clustered and a non-clustered index?

0 Answers  

---