write a query to remove duplicate records without using primary key column?

2 Answers   ABCO,

---

what is the output for this query select * from employee where 1=1;

4 Answers  

---

You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?

0 Answers  

---

What is a Linked Server?

1 Answers  

---

How to install sql server 2005 express edition?

0 Answers  

---

---

What are constraints? Explain different types of constraints?

26 Answers   Emsang, Kendriya Vidyalaya(Kvs), Polaris, Wipro,

---

What is 2nf in normalization?

0 Answers  

---

Which tcl commands are available on the sql server?

0 Answers  

---

Can primary key be a foreign key?

0 Answers  

---

What is use of except clause? How does it differ from not in clause?

0 Answers  

---

What is the impact on other user sessions when creating indexes?

0 Answers  

---

What is blocking and how would you troubleshoot it?

3 Answers   HCL,

---