I did include the data, but perhaps not very clear - try this with the headers.

Ahh many thanks

Hi all - I appreciate your comments, I am pretty weak in this area especially when the code get this big I often get lost. Typically I have been...

Ok guys and gals I here is the query in question along with the XML for the plan and the missing index statement. I understand if you think this...

Hi there, I will post this tomorrow if thats ok, the query is ginourmous which is why I was only intrigued by this aspect of it.

Thanks for the info in...

Yeah I tried to do that but the jobs use TSQL and a CMDEXEC steps. I guess I won't be able to change the TSQL one, but the CMDEXEC...

I see thats great thanks for all the help, I will check out if the logic is correct first of all then maybe use what Alex has provided as an...

Its quite complicated, as the view its querying also performs a mass of min and avg functions to bring back the mins and avgs per batch_id.

If I was to turn...

ah cool nice graph 🙂

still left with what seems to be an uninvestigatory error though 🙁

So it does - thanks guys and gals.

I have only done a service restart not a machine reboot, but in any case my log says things like this, and there is also a dump.

10/20/2011 11:37:58,spid33s,Unknown,File activation failure....

I did yes - many times :s

My server is SQL 2005 x86 and AWE is not switched on, so I guess this is why its stuck at 200,000?

Ok I think I have found some information stating that PLE just affects the buffer pool. However I now have a follow up question on this. If my...

Hi

So what about PLE then does this affect both caches? or just the buffer cache?