Some concerns with or disadvantages of MERGE: 1.  Books online says that MERGE "may produce incorrect results" if a cte is used to filter out rows from the source or target, so in that case you do not end up with an assurance that there hasn't been a mistake. 2.  To me, a lot harder on the eyes than UPDATE/DELETE FROM if all ...