Answer / neetu

U have to optimize SP for that
1. Use as much as possible WHERE clause filters. Where
Clause is the most important part for optimization
2. Select only those fields which really require.
3. Joins are expensive in terms of time. Make sure that use
all the keys that relate the two tables together and don't
join to unused tables, always try to join on indexed fields.
The join type is important as well (INNER, OUTER).

Difference between Triggers and Stored Procedure

23 Answers   Claimat, HCL, Protech, Silgate,

---

Can Having clause be used without Group by clause?

6 Answers   CarrizalSoft Technologies, CSC, CTS,

---

How do we return a record set from a Stored Procedure in SQl server 2000?

3 Answers  

---

What are sql server procedures?

0 Answers  

---

How many types of Joins in SQL Server 2005?

9 Answers   CarrizalSoft Technologies, HCL,

---

How to create indexed view?

0 Answers  

---

Normalization and denormalization

3 Answers   Wipro,

---

Your table has a large character field there are queries that use this field in their search clause what should you do?

0 Answers  

---

select the 3rd maximum salary from sql server database if 4 (just an example In practically I may not know the exact situation) of the highest salaries are equal.

8 Answers   TCS,

---

can i write function in stored procedure and stored procedure in function and nested procedure.Give one example for each question?

1 Answers   Cap Gemini, TCS,

---

How can you insert values in multiple rows using one Insert statement?

0 Answers   Flextronics, Thomson Reuters, Virtusa,

---

What is awe?

0 Answers  

---