Yep, they do.

The good news is, I tracked down the problem yesterday!!

I grabbed a 'fast' older version of the sproc off another server for comparison purposes. When I forced...

Sorry, they are seperate queries, the one sproc returns multiple result sets

Select x from tbl1

Select y from tbl2

select z from tbl3

Slightly more complex obviously

>How many rows are in temp table #t

In the vast majority of cases (and certainly the one I'm concerend with here), only a single row.

>How many rows does this...

G'day guys, back at work now...

I've run the Round 1 changes above on a database which is showing these symptoms. DBCC UPDATEUSAGE showed a lot of updates, but it...

I haven't had a chance to drop in to work to give it a whirl, I'm enjoying my holidays too much

Rest assured, I...

That's an unreal response guys, I should have asked about 1/2 a head of hair ago!!

I can post SQL, query plans etc, but I'm on hols for a few weeks....