Explain how does the report manager work in ssrs?

0 Answers  

---

What does it mean to invest in the index?

0 Answers  

---

Difference b/w Clustered & non-clustered index? Not the bookish definition, but how they internally works in SQL Server?

1 Answers   United Healthcare,

---

Tell me what are cursors and when they are useful?

0 Answers  

---

What is the difference between inner join and equi join?

0 Answers  

---

How do you delete duplicate rows in sql server?

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,

---

You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?

0 Answers  

---

What is sql server profiler?

0 Answers  

---

What is an execution plan? How would you view the execution plan?

0 Answers  

---

Differnce between sel server 2000 and 2005

3 Answers  

---

When multiple after triggers are attached to sql table, how to control the order of execution?

0 Answers  

---