If you look at the message on the INSERT it says:

"The query had to wait 1164 seconds for MemoryGrant during execution"

That's nearly 20 minutes.

https://techcommunity.microsoft.com/t5/sql-server/understanding-sql-server-memory-grant/ba-p/383595

Try adding this to the...

Further update: I took a backup of the database to a different server (2019 Dev edition), restored there and ran the entire process in 56 seconds. On the client's server...

Attachments seem to have not worked... Trying again with both in a zip file.

Hi Andrew - Thanks for your comment, this helped a lot (I was too tired last night to come back and comments, but just wanted to say thanks!)

• This reply was modified 4 years, 10 months ago by  nscd.

Thanks for all the input everyone. What I've realized reading all this is that the bigger problem is really that our DBA isn't proactive. There probably is more than enough...

Thanks for the input so far.

Maybe just a bit of clarification: I have already spoken to him about this around expectations, being more proactive (esp. identifying additional true...