How to replace cursor for performance

Felix 2015-07-06 11:25:35

Aaron Bertrand 2015-07-06 14:08:51
It is not possible to give any advice on the cursor you're using. You've anonymized the plan in an older version of Plan Explorer, which simply stripped all statements to avoid revealing private information. Please generate a new actual plan using an updated version of Plan Explorer (you can download build 8.4.33 here and read about the changes here), or upload a new, non-anonymized version of the plan.