how to improve this select statemant
2017-09-25 19:58:45
2017-09-26 11:12:53
Can you try to use option (maxdop 1) at the end of the query and then check the performance.
The maxdop in the select operator is 24 and that looks a bit odd