What are the factors you will check for the performane optimization for a database query?

7 Answers   CarrizalSoft Technologies, DELL, SoftSol,

---

How do use Having,Group by,Group function in SQL?

0 Answers  

---

How to store and query spatial data?

0 Answers  

---

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

0 Answers  

---

What is the difference between in and exists. Ex: select * from emp where empno in(....) and select * from emp where empno exists(....) What is the difference between a Join and Union and Union and UnionAll.

5 Answers   ABC, Accenture,

---

---

How to determine the service pack currently installed on SQL Server?

4 Answers   HCL,

---

Can we insert data into view sql server?

0 Answers  

---

why would you use sql agent? : Sql server database administration

0 Answers  

---

How to install sql server 2005 express edition?

0 Answers  

---

How to attach adventureworkslt physical files to the server?

0 Answers  

---

please give me query code of unique fuction select UNIQUE (name) from emp_info Incorrect syntax near the keyword 'UNIQUE'.

1 Answers   TCS,

---

Do you know what is a with(nolock)?

0 Answers  

---