Answer / Pramod Kumar Jaiswal

Analysis Services Repository (ASR) in SQL Server is an XML-based internal metadata storage for Analysis Services objects, such as cubes, dimensions, and measures. The ASR stores all the relationships between these objects and can be used to design, build, and maintain complex data models.

Benefits of Stored Procedures?

1 Answers   Wipro,

---

How to fetch records from a One to Many relationship table. eg: wanna get details of all orders for a specific customer. (do not want repeatation of master table records for child table records)

2 Answers  

---

What is the purpose of using COLLATE in a query?

1 Answers  

---

What do you understand by coalesce in sql server?

1 Answers  

---

Can we add an identity column to decimal datatype?

1 Answers  

---

How to use clusters?

1 Answers   Amdocs,

---

Issues related in upgrading SQL Server 2000 to 2005 / 2008

1 Answers  

---

What is the difference between truncate and delete commands?

1 Answers  

---

What does indexation mean?

1 Answers  

---

Define left outer join?

1 Answers  

---

WRITE A FUNCTION TO DISPLAY THE OUTPUT OF AN EXISTING TABLE RANGE LIKE COMMAM SEPERATED VALUES LIKE RANGE1,RANGE2,...

2 Answers   TVS,

---

How do you test your database? : sql server database administration

1 Answers  

---