Let me add my version too. No cursors in the implementation. Many (but not all) of the latest SQL server versions' index options. Both indexes and primary keys are scripted....

We found Service Broker to be very useful in situations where the number of services is low. However in a larger environment setting up and maintaining the routes is a...

Good to see that that helped you. But it was merely a guess for me.

You're only getting vague answers and you only have yourself to blame for that: you've...

To be able to store all characters you should use nvarchar() or nchar() (as opposed to varchar() or char()) everywhere where the values are stored. i.e. in all your tables,...

The extra where clause that MS added to fix the deferred update issue does functionally fix the issue on small(ish) numbers of rows in the _CT tables. When however I...

Oh and maybe to help you with your issues, here's a way to use cdc to only act upon changed data without using the mask feature: (I've typed this without...

Thank you dlcraig. I will have a look at your test script to see if it produces the same result for me. I'm having a holiday right now, but I...

So far I see a lot of unfounded assumptions in this thread and little founded problems.

My firm has implemented a lot of services in our software based on service...

Hi Kevin,

I can't help you with why the query is slow when run by the merge agent, but I think I do know what makes it run fast when run...

You forgot to mention what type of replication you are running; snapshot, transactional or merge.

There are some tables in each replicated database (their names differ per replication type), generated during...

dwain.c (4/3/2013)

---

P Jones (4/3/2013)

---

As another MERGE fan I'd use

WHEN NOT MATCHED BY SOURCE AND (t.ID = s.ID) THEN DELETE;

in the original merge statement.

But I've no complaints about the...

Phil Factor wrote a nice article about error handling when transactions are involved here[/url]. The only thing I had to add to it, is already in the comments below the...

Nice one Hilda,

More like a braintrainer, than for any actual purpose I tried to come up with something that could do the same task with a little less elaborate code....

@Ryan.Polk: Yes, you can do that, but it is not the same. First, as you just demonstrated, it is easy to forget that you need to add the...

Excellent article indeed. However like in most articles on merge, you do not mention the fact that merge doesn't have a where clause. i.e. if you want to use only...