Yes, most of these were my next steps. Unfortunately, however, I can't get the files on separate drives (let alone fast ones). And yes, I implemented # tables, not @...

Yes, all the same as were on the original 'real' tables.

None at all - any recommendations would be very gratefully received; pre-sizing, autogrowth settings, file location?

Update. I made a copy of the original database and then developed the copy to use # tables instead of 'real' tables for much of the calculation. (That took a...

Yes, we've got plenty of UDFs but we're slowly eliminating any which access data in tables and I'm pretty sure that any which do aren't involved in the calculations in...

Why do we need so many SPs? I hope it's because we're doing some fairly complicated calculations, the details of which I won't bore you with. Suffice to say, however,...

Thanks for your replies.

We have an index on the SPID column (of course!) but not a clustered one. I was concerned that this might make the situation worse, given that...

Use a tally table surely?