Ok... confusion has set in, Richard... in your latest post, you say "A large number of the reports do have to be bang up to date" and in a previous...

Turn off auto update of statistics?  Why?  Most folks consider that to be a form of "death by SQL"...

To go along with James Moore's suggestion about creating a temp table of all the dates in the range...

There are a lot of folks that keep an "auxilliary calendar table"...

Just for giggles, monitor the size of the databases, especially TempDB, when this happens.  I'd do a DB Size "profile" right after a reboot to use as a baseline.

The other...

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITED

I believe I said that...

"Now that I've said all those negative things about them, correctly formed views with the right indexes on the underlying tables can be a...

Like I said....

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=350069#bm350229

I sure missed something, there... sorry.  I've not had the same problem with it... lemme dig a little deeper...

Heh, sorry... was having a bit of fun, there.

In al seriousness, the folks that have been saying that an unlimited number of columns is not necessary are all talking from...

I can think of no good reason to do such a thing.

One of the things that a lot of folks don't realize is that most DB's that do a form...

Yep...  I've found that lots of folks create monster views with too many columns and really poorly formed SQL with aggragates out the wazoo so its "reusable" code and solves...

Heh... text file...

SELECT @@SPID

The dummy BatchID table is a good one, but I'd probably use it to collect some parametrics about each batch...

Text files of this nature are easy to load and you don't need BCP or any of that so long as you have the right privs...

Let's say you have...