So, you want to use MERGE, eh?

Please don't. Every time I see a question about MERGE, I scramble for the links I post to urge people to change their minds. So I put them together here.

If you insist on using MERGE, the biggest TL;DR is: Please ALWAYS use HOLDLOCK on the target.