Hugo

Thanks for your time and the detail explanation.

Lee

Hugo

Per your test recommendation I reworked the query as you described below. However, I did need to change the query to a direct update instead of an update via...

Scott

I've attached the "Actual" execution plan. Attached zip contains the XML output of the execution plan. Hopefully this will work for you.

Thanks

Lee

ScottPletcher (1/4/2016)

---

I just noticed the OR condition...

Scott

I created the clustered index on ProcessDate/SOID as you stated and also created a NC index on SOID.

Doing so has made the execution plan much more complicated and increased the...

I reviewed the windows event logs and did not find anything that pertained to the issues I was having.

However, I have found that the issue appears to be the result...