Answer / Bobindra

{"replication": "Database replication is a method used to copy and keep database data consistent across multiple databases, called replicas. In SQL Server, there are two main types of replication: 1) Transactional Replication: It copies data from the publisher database to one or more subscriber databases. Changes made to the publisher database are propagated to the subscriber databases. 2) Merge Replication: It allows multiple publishers and subscribers to exchange data bi-directionally. Each subscriber can also make changes, which can then be propagated back to the publisher."}

What is difference between view and materialized view?

1 Answers  

---

What are the types of subscriptions in SQL Server replication?

1 Answers   HCL,

---

Please give me queries for the following 1. To get the count of duplicate records. 2. A query to delete the duplicate records.

3 Answers   247Customer,

---

How do clustered indexes store data?

1 Answers  

---

explain the type of contraints

3 Answers  

---

How to update existing rows in a table?

1 Answers  

---

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

1 Answers   HCL,

---

What do you mean by cardinality?

1 Answers  

---

employee table has employee id ----------- empid ---------------- 1 2 3 3 3 4 5 5 5 6 6 6 7 here the values r repeated two times.how to select the repeated values only.i.e 3,5,6 should alone come.

3 Answers  

---

When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?

1 Answers  

---

How to manipulate data from one table to another table ?

1 Answers   MCN Solutions,

---

What is sql server schema compare? How we can compare two database schemas?

1 Answers  

---