Explain different types of self contained sub query?

0 Answers  

---

if 3 duplicate records in a table,i want to delete 2 duplicate records by keeping 1 duplicate and 1 original as it is,how?

5 Answers  

---

How to provide Security for package?

1 Answers   Convergys,

---

What is an execution plan? When would you use it?

0 Answers  

---

i want only duplicates rows from coloumn ex. emp_id(colomn name)1,1,2,3,3,4,5,5. so i want only duplicates no.

3 Answers   iFlex,

---

What is full outer join in sql server joins?

0 Answers  

---

What is the use of floor function in sql server?

0 Answers  

---

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

0 Answers   HCL, Wipro,

---

How does using a separate hard drive for several database objects improves performance right away?

0 Answers  

---

What happens if null values are involved in comparison operations?

0 Answers  

---

Do you know what is a linked server in sql server?

0 Answers  

---

What is sql server used for?

0 Answers  

---