it seems that you are quite familiar with this forum . so table defintion , index , test data was expected. it is better to get the result faster.

Anyways...

What about the setting up maximum limit of Memory.... (I might be hitting the nail in dark holding with it other hand. 😀 )

indexs should include column which are part of

Where

order by

group by

JOINs...

you need to test (as i havent tried this )but i think you cant restore database of prior versions.

Always post table defintion along with test data to get faster resultsl.people here steal their time to help others , sometimes they dont have time to frame everything here.please see...

NO.

but see if these link can help you

http://blogs.msdn.com/b/karthick_pk/archive/2012/06/22/a-significant-part-of-sql-server-process-memory-has-been-paged-out.aspx

http://support.microsoft.com/kb/918483

LDF...

see this link too Statistics

NO.

Have you read the link which...

let me guess it is because "to cover most of the queries" ?

ANy reason why you ONLY need this particular error msg?:w00t:

Another link http://sqlserverplanet.com/troubleshooting/sql-server-slowness

djordan 4543 (1/7/2013)

---

with the script provided - is there anything in particular to look for . I ran the script during high memory usage and low memory usage and I...

Jason-299789 (1/7/2013)

---

You can solve this with a Calendar Table, once you have a Calendar table in place its simple to then run a Cross tab to get the values, in...

And how will you show output result for above