Hi,

I've not noticed anyone else suggest this alternative, so here goes:

Use cache files to slim down your data.

Try to avoid putting data into staging tables if at all possible. It...

Ah, didn't realise you weren't already referencing the view directly. The optimiser is smart, but sometimes it does need a helping hand. It usually finds reasons not to use a...

Have you tried turning this into a stored procedure and including the WITH RECOMPILE option when you create it? This will force the optimiser to recalc the execution plan every...