← all nuggets
NuggetJun 28, 2026
IGNORE_DUP_KEY — what it is, since when, and the performance trap
An old SQL Server index option that drops duplicate rows on insert instead of failing the whole statement, handy for idempotency but ~18x slower on a clustered index.
sql-servert-sqlindexperformance
Embedded as a standalone HTML file · runs in a sandboxed iframe · styling is the nugget's own