Besides asking for rewrite or maybe more hardware (if under realllllllllllllllll y high memory pressure) I don't see what you can do.

Sean Lange (5/23/2011)

---

Take me with you I could use...

ehdium-drivers (5/23/2011)

---

Me too, I was finding that many query plans are being compiled ad hoc.

(57% of batch requests result in compilation)

I would like if the server reused more my...

Why the heck was I thinking about pivot for this ?!?! Officially taking the rest of the day off 😎

Whenever I feel like adding and hint I ask myself something similar to this :

Am I really smarter than the best MS engineers who had years and trillions of...

Check the plan for the query with the where condition. I bet you have an index seek with bookmark lookup which is actually more expansive than a full scan.

I'd...

SELECT MAX(CASE WHEN Result = 'Fair' THEN 1 ELSE 0 END) AS Fair,

MAX(CASE WHEN Result = 'Good' THEN 1 ELSE 0 END) AS Good,

MAX(CASE WHEN Result = 'Excellent' THEN 1...

Thanks for the feedback. Might help someone else someday.

Not sure I'd go...

Maybe you should post as QOTD... nice piece of trivia!

There seems to be a lot missing from this logic and even a few requirements. No offense but are you sure this is not some sort of homework?

The degree...

there's no magic bullet for any global tuning process... always takes a...

Where are yo not clear going about this? This is really straight forward especially with the clear steps.

What have you tried, where are your road blocks?

maryamzolfaghar (5/22/2011)

---

I could not wait more so UNWILLINGLY I stopped the sql server and restarted it and everything was OK then. I really wanted to find out the root of...

It's not supposed to work like that. It's supposed to be the very next statement after the select >> set @rc = @@ROWCOUNT.

My guess is that in your query...