A little bit of analysis of your problem is this. You say that the query may return server million records. Lets just say there are 2,000,000 results ....

Two things to add.

One is that if you built this import routine in a recursive fashision you could have something like:

exec ImportRecords @StartRecord, @EndRecord, @BlockSize.

The first level of recursion would...

Yes,

The Corvette is paid for now. All is good. I am working on projects that are actually enjoyable again.

Update:

The project was a huge failure as I expected.

It was so convoluted that the required functionality was never able to be implimented. Most screens never worked as expected even...

Thank you Matt.

It looks like this is a least one of the issues. I also found that temp DB is on the C: drive and is probably sharing disk...

Try this it will tell you the 100 slowest querys that have run in the last 24 hours. Note that it actually measure each query. If the query...

Well I could post the company name, embarasing them in a public forum could be grounds for firing, so I will not. I have payments on my 2003 Red...

I noticed that one person said "This is brilliant and I wish I though of it". Please post some reasons why. Have you had experience with this? ...