Answer Posted / rajeev

Index is used for fast searching and batter performance.

What is the maximum size of a dimension? : sql server analysis services, ssas

1000

---

Difference between Inner vs outer joins?

894

---

What is a View ? Can we insert, Update and delete a view?

940

---

What is thr feature of change data capture?

918

---

How to test subquery results with the exists operator?

1033

---

How to disable triggers using "disable trigger"?

1000

---

What is sub-query in sql server?

1139

---

Explain few of the new features of sql server 2008 management studio

859

---

How do you drop an index?

862

---

What is an identity?

937

---

Explain syntax for viewing trigger?

884

---

How to test a dml trigger in ms sql server?

986

---

What is raid, and how it can influence database performance?

1008

---

List some case manipulation functions in sql?

966

---

What is filestream?

942

---