If it is a multi processor box you can use the MAXDOP query hint to ensure that that query only uses 1 processor.

Are all of you DB's on the same Server?

Currently we keep the most current year in the table. The data is rolling so today the data from Feb 12 of 2001 was over written. We have...

I set up a 3 tables on every SQL Server that we have (about 20) that has servername, dbname, tablename, and 365 additional columns D1 through D365. Every night...

You could enable the /3GB switch in the boot.ini file this will allow the applicaiton to use up to 3GB RAM instead of 2. Not sure if it will...