Microsoft – SQL Server – Index – IgnoreDupKey / Pros and Cons
As promised and worthy of Microsoft SQL Server MVP, Paul White, delivered
a must read article on Index – IgnoreDupKey.
Please follow-along :
A creative use of IGNORE_DUP_KEY
http://sqlblog.com/blogs/paul_white/archive/2013/02/01/a-creative-use-of-ignore-dup-key.aspx