Despite the warnings are disappeared job hanging more than 16 hours in this stage : https://www.brentozar.com/pastetheplan/?id=BJqia74-8 . Can you see something different this time ?

Thank you

Hi Grant , When I followed your instructions I see this errors under warning :

Type conversion in expression (CONVERT(date,[m].[CPUDT],0)) may affect "CardinalityEstimate" in query plan choice; Type conversion in expression...

I can not upload the file here . but here is the execution plan https://www.brentozar.com/pastetheplan/?id=rygp4aVxU

• This reply was modified 5 years, 8 months ago by inthernorth. Reason: fileextension
• This reply was modified 5 years, 8 months ago by inthernorth.
• This reply was modified 5 years, 8 months ago by inthernorth.
• This reply was modified 5 years, 8 months ago by inthernorth.

Hi Eirikur, please see execution plan ,approx 3 hours still hanging.