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

What is user-defined multi-statement table-valued function?

0 Answers  

---

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

2 Answers   Broadridge,

---

what is create database syntax? : Sql server database administration

0 Answers  

---

What is the purpose of optimization?

0 Answers  

---

List all types of constraints in sql server?

0 Answers  

---

do views contain data ?

0 Answers   MCN Solutions,

---

I have cleared sbi clerk examination. I am Bachelor in computer application (BCA) graduate. so which type of question related bca in sbi clerk interviews. pls answers me at sejalvaghela@yahoo.co.in.. and also tell me which type of question asked in sbi clerk interview.

1 Answers  

---

What is bit data type?

0 Answers  

---

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

1 Answers   HCL,

---

What are the different ways you can create databases in sql server?

0 Answers  

---

Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?

0 Answers  

---

Can we do dml on views?

0 Answers  

---