Answer / Sachin Kumar Sharma

Yes, in SQL Server, a server stores the actual data for databases.

Explain the advantages of merge replication?

1 Answers  

---

Well sometimes sp_reanmedb may not work you know because if some one is using the db it will not accept this command so what do you think you can do in such cases?

2 Answers  

---

How do you measure the performance of a stored procedure?

3 Answers   Infosys,

---

please bar with my english i having a database called tblhallreservation in which res_date is date field has to select all the fields in table deponding on month either has to display all details for the month jan or feb and so on

1 Answers  

---

How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?

1 Answers  

---

What is the Control Flow in SSIS

1 Answers   HCL,

---

Explain Capacity planning to create a database? and how to monitor it?

1 Answers  

---

Plz tell about backup&recovery?

3 Answers  

---

define and explain the differences between clustered and non-clustered indexes.

1 Answers   Microsoft,

---

what is differece between union and union all

6 Answers  

---

What are statistics?

1 Answers  

---

Explain what is the main purpose of having conversation group?

1 Answers  

---