Hi Grant,

Many thanks for the response, that does make sense and although a little painful it will give peace of mind.

I'm all too familiar with MS and their suspect patching...

Where a full backup is not suitable  / available for a particular script update, i sometimes take an approach to make a copy of some individual tables/ fields using bcp...

Or this is another alternative to consider for execution plan review....

https://www.sentryone.com/plan-explorer

James

Hi DBG

I see that you have a begin transaction out of the TRY loop and the last associated COMMIT within the TRY loop. In this scenario you could just have...

Hi there, 

There are a number of items to consider when running in older compatibility modes...

Main point to consider is SQL 2014 introduced a new cardinality estimator...