Thanks 😉 but CXPACKET is not a problem here - we have already decreased this wait time and we are fine with it. My main concern is output from sys.dm_os_memory_clerks...

Yes, already done it. The two main are: CXPACKET and RESOURCE_SEMAPHORE on tempdb (both are apx. 60% of total wait time).

Hi Steve,

I think that you can move the definition of TMP_Charges into join (in your main query), like this:

SELECT Customers.Surname,

Customers.Forenames,

Plans.PolicyNumber AS [Policy Number],

Plans.CurrentValue AS [Fund Value £],

Products.ProductName...