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,

---

What is SQL Server?

0 Answers   Atos Origin,

---

What is update_statistics command?

0 Answers  

---

How do you find the number of rows in a table?

7 Answers  

---

List the different types of collation sensitivities in sql server?

0 Answers  

---

What is the difference between views and stored procedures? Can we have input parameters for views?

6 Answers  

---

What is side by side migration in sql server?

0 Answers  

---

What is the importance of three tier architecture?

0 Answers   QuestPond,

---

optimization techinques

0 Answers   Wipro,

---

Explain following error properties?

0 Answers  

---

What is blocking in SQL Server? If this situation occurs how to troubleshoot this issue

2 Answers   IBM,

---

hi, how to match retrieve the unmatched records from 2 tables in which we dont have any primary key. example : table1 has 1,2,3,4,5 and table2 has 1,2,3,4,5,6,7,8,9,10 and i want the numbers from 6 to 10 to be displayed and should not come as null. i need the numbers. please reply as soon as possible.

4 Answers  

---