The Case of the Blocking Merge Statement (LCK_M_RS_U locks)
Category:
indexing
Recently I got a fun question about an “upsert” pattern as a “Dear SQL DBA” question. The question is about TSQL, so it lent itself to being answered in a blog post where I can show repro code and screenshots.