Looks interesting I'll give it read thank you

It is based on more than one column and the suggested order is the same as the existing index, and they are the only columns filtered by in the query....

What my theory is there is something going wrong in the try block that is causing a bypass of the catch which was my reason for adding the xact_abort on....

When it is causing the blocking it is the head block I've also tried running the profiler while it's acting as the head block and its not doing anything. I...