dwain.c (10/27/2013)

---

guy.stephens (10/27/2013)

---

Much as we love the Merge statement in my workplace, we seem to be running into deadlocking problems that we haven't had when using the UPDATE/INSERT .. LEFT JOIN approach.

We haven't investigated too deeply but are tending back to UPDATE/INSERT on large datasets. Would be glad to hear from anyone else who has experienced this.

I personally have not experienced this issue, however with a 28% performance hit it wouldn't surprise me.

I would say that if you are really expecting to INSERT/UPDATE 100s of 1000s of rows, it might be a good idea to stick to the traditional.

I guess the key words here are "it depends."