We have 48GBs of RAM and 38 of that is dedicated to SQL (nothing else runs but I wanted to leave some breathing room).

The processors are Xeon E5645 (two...

SQL: Microsoft SQL Server 2008 (SP3) - 10.0.5500.0 (X64) Sep 21 2011 22:45:45 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1...

Sorry, I should have been more specific.

USING #TradeVolumes AS Source --(TradeID, AnalysisTypeID, VolumeTypeID, [Hour], [Value])

That little puppy did the job.

That worked! Thanks everyone for the help! Things have been smooth the last 24 hours!

Thanks for the merge tip. When I tried to create a new sproc, I got this error:

"TradeID" is not a recognized table hints option. If it is intended as a...

Hey Craig,

Thanks for the speedy help!

I created a clustered index per your suggestion. A side question before I dive into this more. With a table of ten million entries and...