Answer Posted / riyaj

Xtreme Performance

What is pivot and unpivot?

631

---

What is identity?

542

---

What are different types of schemas?

510

---

Tell me what is the stuff and how does it differ from the replace function?

534

---

What are different replication agents and what's their purpose? : sql server replication

561

---

---

Explain hostprotectionattribute in sql server 2005?

590

---

Define clusters?

642

---

What are the different types of sub-queries?

594

---

What is difference between order by and group by?

567

---

What is difference between materialized view and view?

476

---

What is molap and its advantage? : sql server analysis services, ssas

537

---

What is sub query and its properties?

535

---

How do you delete a data source?

535

---

How can I change procedure name in sql server?

530

---

How can sql injection be stopped? : sql server security

542

---