What happens if you add a new index to large table?

0 Answers  

---

How to sort the query output with order by clauses in ms sql server?

0 Answers  

---

How can you start sql server in different modes?

0 Answers  

---

What is storeprocedure?Tell me synatx for how to write stored procedure.

1 Answers   Cap Gemini,

---

What are the advantages of using views. Why do we need views when we have SPs?

4 Answers   247Customer,

---

---

What do you do in data exploration

0 Answers   EXL,

---

What is service broker? : sql server database administration

0 Answers  

---

Is candidate a key?

0 Answers  

---

1.What is the deferece between DBMS & RDBMS? 2.How can you trouble shoot? If u will get error while installing sql server? 3.How can u trouble shoot slow running query? 4.how can u trouble log shipping errors? 5.why do we use merge replication instead of T.log replication?

7 Answers   Microsoft,

---

What is difference between equi join and inner join?

0 Answers  

---

What is role playing dimension with two examples? : sql server analysis services, ssas

0 Answers  

---

what is denormalization and when would you go for it? : Sql server database administration

0 Answers  

---