I had a similar problem with SP3a where the stored procedure would work IF it had no parameters, otherwise it would take 50x as long to complete.

I would check...

Thanks to everyone for the tips so far,

I did know about log files on a seperate physical drive and that has been in place for a while. I was chatting...

Thanks for the replies,

I have made some head  way using the execution plan of the two main queries. Because I was always filtering the results of the table via two...