Do you know what are pages and extents? : SQL Server Architecture

0 Answers  

---

What do you know about normalization and de- normalization?

0 Answers  

---

Tell me what are the advantages of using stored procedures?

0 Answers  

---

let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration

0 Answers  

---

Explain what is analysis service repository?

0 Answers  

---

---

What are the type of joins? When do we use Outer and Self joins?

3 Answers  

---

How will you add a dimension to cube? : sql server analysis services, ssas

0 Answers  

---

How to delete all rows with truncate table statement in ms sql server?

0 Answers  

---

How to get the query of a table in sql server?

0 Answers  

---

How to create hyperlink from returned sql query ?

0 Answers   MCN Solutions,

---

OPTIMIZATION OF SP,CURSOR,TRIGGERS

0 Answers  

---

What are transactions and its controls?

0 Answers  

---