the query is just an single update statement. There are four update triggers on this table, with nested stored procedures, not to mention all the FK references.

We cannot script out this database and post it on a public forum due to the fact that 1. it is a third party vendor and 2. this database supports a trading system.

I just wanted to mention that applying the latest CU and using trace flag 4199 does not help. We have a case opened with MSFT. If we find a resolution I will post back.

Thanks for reaching out, much appreciated.