I landed here searching for a possible answer after running an insert script thats 40k rows long.

Breaking it up with GO perfectly solved the issue.

Thanks !