https://www.sqlservercentral.com/blogs/improving-instead-of-insert-cardinality-estimates-for-inserted-and-deleted-pseudotables-in-sql-2014
Improving instead-of-insert cardinality estimates for inserted and deleted pseudotables in SQL...
Tricky triggers In my last entry I noted that the performance of "instead-of" triggers can be tricky. One of the reasons for...