For bonus minutiae, SQL Server has a problem with upserts. Here is the old school and the new way for handling it. https://sqlperformance.com/2020/09/locking/

For bonus minutiae, SQL Server has a problem with upserts. Here is the old school and the new way for handling it. https://sqlperformance.com/2020/09/locking/upsert-anti-pattern https://sqlperformance.com/2020/09/locking/upsert-anti-patte... https://learn.microsoft.com/en-us/sql/relational-databases/performance/optimized-locking https://learn.microsoft.com/en-us/sql/relational-databases/p...