Without being able to see the rest of the execution plan nor have the execution plan where we can drill into the properties of each node, it's likely to remain...

Not nearly enough information.  My recommendation is to download a copy of sp_WhoIsActive by Adam Machanic (Google for it, please) and find out what is running (it'll show the actual...

Maybe if I ask a third time... 😉
You say the last batch caused the file to grow so let's talk about the nature of your batches vs the rest of...

Lot's of people have been doing that trick with RowNumber.  Thinking about the code behind the scenes, it should be guaranteed but MS refuses to state that...