How do you manipulate data?

0 Answers  

---

Can you force a query to use a specific index?

0 Answers  

---

Delete duplicate rows from a table without primary key by using a single query Table Employee empname salary A 200 B 300 A 200 C 400 D 500 D 500 Output should be A 200 B 300 C 400 D 500

14 Answers  

---

What is a performance monitor?

0 Answers  

---

How do I create a partition table in sql server?

0 Answers  

---

IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do

0 Answers  

---

Do you know what is a trace frag? Where do we use it?

0 Answers  

---

Is trigger fired implicitely?

2 Answers  

---

select top 5 * from emp order by newid() my question is , how this query get executed?

5 Answers  

---

What do you understand by triggers and mention the different types of it?

0 Answers  

---

How to concatenate two character strings together?

0 Answers  

---

What is a join and their types?

2 Answers   Challenger Financial,

---