We had the same problem with many stored procedures that did multi-row inserts. It was all thanks to the "improvements" they made in the optimizer (Cardinality Estimator specifically, IIRC). We "patched" the problem by using the Trace Flag that says to use the old CE. Unfortunately, that also means that our "get out of the woods patch" has become the fix because people don't understand that we actually do need to tweek,n,peak the inserts and won't even try to fix them.
is pronounced ree-bar and is a Modenism for R
First step towards the paradigm shift of writing Set Based code: Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair
How to post code problemsHow to post performance problemsForum FAQs