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).

How do I trace a query in sql server?

0 Answers  

---

When columns are added to existing tables, what do they initially contain?

0 Answers  

---

What is a View ? Can we insert, Update and delete a view?

0 Answers   Arigo Infotech,

---

Differentiate between sql temp table vs table variable?

0 Answers  

---

How To delete duplicate record from a particular table?

12 Answers   eXensys, Foxfire,

---

How to how to convert numeric expression data types using the convert() function??

0 Answers  

---

What is referential integrity and how is it achieved?

1 Answers   Adea Solutions,

---

Which table keeps the locking information?

0 Answers  

---

hi,i want t0 knom d syntax for a super key with an example

1 Answers  

---

What is the filtered index?

0 Answers  

---

Explain the concept of view and Types of views in SQL server?

0 Answers   HCL,

---

What command is used to rename the database?

0 Answers  

---