Merge was designed for loosely connected systems that occasionally synchronize their data. Example SalesForce.

Peer-to-Peer was simply an extension of bi-directional transactional replication with low latency in mind.

It is useful in...

Well ... that depends soooooo much on the place !!!!

It is usually employed on very large organizations.

Where I work for example we don't have titles and compensation is...

what exactly is "real-time" about this ? 🙁

mister.magoo (4/28/2010)

---

In terms of performance on queries like your example, I agree there should be very little difference, although as Jeff said, that may not be true for very large...

Your Server name, Your network connectivity or a defined alias is preventing distribution agent to connect.

A LOT!

Merge replication

- is trigger based

- It uses only merge agent

- It could be set to track column changes instead of row changes

- It could optimize the final changes...

I am sure that the "CASE" version is way much faster!

Something like this ?

SELECT [Contract].ProjNumber, [Contract].Description, [Contractor].[Name], [Contractor].City,

MIN([Estimate].Estimate) OVER(PARTITION BY Estimate.ProjNumber) as "Lowest Estimate"

FROM Contractor INNER JOIN

[Estimate] ON Contractor.ConNumber = [Estimate].ConNumber INNER JOIN

[Contract] ON Estimate.ProjNumber = [Contract].ProjNumber

GROUP BY

[Contract].ProjNumber, [Contract].Description, Contractor.[Name],...

Maybe something like :

SELECT @intPeriodID,

MAX(CASE WHEN PeriodId = @intPeriodID THEN PeriodName + ' (' + CAST(WorkDays...

Did you restart the LogReader agent?

LogReader only replicates "committed" transactions.

IF you have a PK violation on the primary it *wont* replicate because the action is rolledback.

IF you see that the values were replicated somehow they...

We have been using that for the past 5 years with the FAT FINGER case in mind!

One more comment: The use of READPAST should be carefully considered for two reasons:

1. If you need to preserve the order you must exclude it

2. If you are using READ_COMMITED_SNAPSHOT...

You will have to make "smarter" index maintenance.

- If you can isolate only the necessary indexes that will help alot with the availability.

- Secondly you will have to see if...

I don't tend to praise a lot of articles, this one has my 5 stars!

Great Job.