This issue was well beyond sp_lock. It's 32 bit and on it's own box ( not a VM). As i understand it-SQL server takes 80% of server resource which is...

Thanks for your response.

There was 3.2GB on the box- 2.5G allocated to SQL. The average avaliable mememory was less than 200mb across the day although we'd reduced the number...

I'm currently suffering from the same issue. All the performance tuning in the world is still leading to this error message:-

'The...

I've Recently been working with derived and temporary tables and in most instances I've found the performance issues to be neglible. To be fair I'm using relatively small data sets.

But...