You searched for the word(s):
< 1 second(s)
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 ...