Answer / Shyam Ji Mishra

There are two types of database schemas in SQL Server Analysis Services (SSAS): 1) Physical Schema: Represents the underlying structure of the data sources that provide data to the cube. 2) Logical Schema: Defines the relationships between objects within the multidimensional model and organizes them into dimensions, hierarchies, and measures.

How to insert new line characters into strings?

1 Answers  

---

Define indexes?

1 Answers  

---

How to convert numeric values to integers in ms sql server?

1 Answers  

---

When would you use it?

1 Answers  

---

Creating Tables Using SELECT

1 Answers  

---

How do you create an execution plan?

1 Answers  

---

can foreign key take role of primary key?

5 Answers   CarrizalSoft Technologies, TCS, Villa Marie,

---

Explain intellisense for query editing

1 Answers  

---

How to Install SQL SERVER 2005 remotely?

1 Answers   IBM,

---

What are different backups available in sql server?

1 Answers  

---

What is the language structure to add a record to a table?

1 Answers  

---

What is a view? is View updatable?

17 Answers   IBM, L&T,

---