Post Closed as "duplicate" by LowlyDBA, Marcello Miorelli, McNets, kevinsky, mustaccio of
    Bumped by Community user
    Bumped by Community user
5 edited tags
| link
4 adding memory clercks for blocking
source | link

Memory Clercks for Blocking:

enter image description here

Memory Clercks for Blocking:

enter image description here

3 Full execution plan.
source | link

Full Execution Plan: Part 1: enter image description here

Part 2: enter image description here

Part 3: enter image description here

Full Execution Plan: Part 1: enter image description here

Part 2: enter image description here

Part 3: enter image description here

2 deleted 23 characters in body
source | link
1
source | link