> actual good MERGE syntax While not the shit-show of bugs it was upon introduction in SQL Server 2008, there are still reasons to be careful with MERGE in SQL

> actual good MERGE syntax While not the shit-show of bugs it was upon introduction in SQL Server 2008, there are still reasons to be careful with MERGE in SQL Server: it can still deadlock with itself in some circumstances, has issues with filtered indexes, can cause problems with CDC (wrong operation(s) get logged), … (I actually like SQL Server, but the implementation of MERGE found there-in is certainly not one of the things I like about it!)