I wanted to thank everyone again for your help, I rebuilt the stats and it works like a dream every report in 1-2 seconds. Your all the true heroes!

Hey Grant,

I ran them both again for some of the statistics, other than the date the Query is identical.

With the Query that works quickly on 6/3...

I'm looking into the above now, I'm essentially walking into the db with-out any of it's history Jeff so I'm not sure what has been done in the past. I...

How would I Capture plans? I ran a trace and gathered the Query from the trace, ran the query against the server itself and found when the issue started, everything...

I checked the config file, it is set up currently like this:

<httpRuntime executionTimeout="3600"  maxRequestLength="1048576">

I checked the web.config file? From what I've gathered so far...

Thank you for the article, I am going through it all today, hopefully I will find a solution and get back to you!