What is query optimizer in sql server?

0 Answers  

---

What is the appropriate number of test cases that you can write on a database?

2 Answers   Microsoft,

---

What is the main difference between ‘between’ and ‘in’ condition operators?

0 Answers  

---

Does the order of columns in update statements matter?

0 Answers  

---

as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration

0 Answers  

---

---

What is a unique key constraint?

0 Answers  

---

Tell me the difference between clustered and non-clustered index?

0 Answers  

---

What are mdf,ndf,ldf files and how to see the data in those files?

6 Answers   Accenture,

---

Their are two tables 'A' and'B'.Table 'A' contains 3 columns named 'eid','ename','dept'. Table 'B'contains 3 columns named'sid','designation','salary'. We have to retrieve the names of employees working in the same department,same designation and same salary. Its urgent can anyone help me out in this problem.

6 Answers   Tech Mahindra,

---

Difference between 2NF &3NF ?

0 Answers   Cap Gemini,

---

What are the common performance issues in sql server?

0 Answers  

---

Is index a datbase objects in sql server?

2 Answers  

---