I'm using mssql 2008 and have a big insert script i need to run. Its about 55.000 records and 160 columns. The script is already created and I cant create it again.

The problem i have is that this runs for about 4 hours or so, and during that time the system that use this database get really slow and timeout a lot.

I would not care if its slower my insert but i can bather the normal users with it.

I was thinking in doing some batch of lets say 500 rows and use the waitfor, but was wondering if there could be a better option for doing this.

Any suggestions are really appreciated.

Thanks!

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.