Thanks for the reply Chris.

I see what you mean, I've modified the query, the execution plans show a marked performance increase which is good.

Guess I'll just see what happens this evening, I just wish I knew what exactly was calling this, I'm guessing it's something internal to SSRS and it's doing routine clean up of expired data, it just seems odd that this occurs every evening at 2am.

Nic