Explain few of the new features of sql server 2008 management studio

0 Answers  

---

What is indexed view? How to create it?

0 Answers  

---

Explain microsoft sql server functions?

0 Answers  

---

Repair mdf file

2 Answers  

---

how to delete duplicate rows from table

9 Answers   CSC,

---

---

What is the difference between resultset and resultsetmetadata?

0 Answers  

---

Do you know what is similarity and difference between truncate and delete in sql?

0 Answers  

---

How to name query output columns in ms sql server?

0 Answers  

---

What is the use of Port no?

1 Answers   Wipro,

---

Can you please differentiate between a primary key and a unique key?

0 Answers  

---

one of my database size is 2gb and Unrestricted Growth for Data file up to 10%.But every day after day I am getting Primary Data file is full 99.999 please take appropriate actions.Why it is? Even disk space is also not full,but still I am getting the alerts.

1 Answers   Cognizant,

---

Explain log shipping and mention its advantages.

0 Answers  

---