Answer / jijo

Synchronizing data and object between systems .

For example i have 50gb data in Delhi server(Publisher or
source ) i need to replicate into tow locations one into
mumbai server 10gb data (subscriber ) and another one into
kerala server 20gb data.

Publisher ---Source
Subscriber ---destination
Distributor--- Receive from publisher and forward to sub

Type of replications

1)Snapshot (one way)
Data refresh of the subscriber every time you synchronize.

2)Merge Replication (Two way)
Both publisher and subscriber can make change to the data.
Conflict :- When two participant chenge the same row at same
time

3)Transactional replication
As change made at the publisher its send to the distributor
and distributor into subscriber

What is instead of dml trigger?

0 Answers  

---

What do you mean by data manipulation language?

0 Answers  

---

What are explicit and implicit transactions?

4 Answers   BirlaSoft,

---

What is data block and how to define data block size?

0 Answers  

---

What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration

0 Answers  

---

---

Syntax to find the used space and free space of the Data file in a database(SQL Server). Following queries didn't give the exact Used space and Free Space Information sp_spaceused;DBCC showfilestats;exec MyDbName.dbo.sp_spaceused;SP_HELPFILE Can any one tell me the query for how to find the exact used data file space and free space in a Data File?

2 Answers   Cognizant,

---

Name three version of sql server 2000 and also their differences?

1 Answers  

---

What are the types of indexes?

0 Answers  

---

Explain insert into select statement?

0 Answers  

---

What is database replicaion? What are the different types of replication you can set up in SQL Server?

5 Answers   Aptech, HCL, Perpetual, SAIC,

---

What is trigger ?

7 Answers   Cap Gemini, SQL,

---

What is Trace flag?

1 Answers   Wipro,

---