I have a big insert script I need to run. Its about 55,000 records and 160 columns. The script is already created and I can't create it again.
The problem I have is that this runs for about 4 hours or so, and during that time the system that uses this database gets really slow and timeout a lot.
I would not care if my INSERT is slower but it shouldn't impact other users.
I was thinking in doing some batch of let's say 500 rows and use the
WAITFOR, but was wondering if there could be a better option for doing this.