Just for info:

I tried the MAXDOP but this had no effect.

I don't think its a thread issue. My understanding is that if a multi-thread is used for the aggregate, then...

Hi

Thanks for the replies.

The number of rows is currently around 65000 and about to double. The "group by" will split that into sets of about 30 rows for each...