Thanks for the article. It brought back a lot of memories of times when I've had such request.

I agree with Steve's comments. Most of the time...

roger.plowman (3/17/2010)

---

TheSQLGuru (3/16/2010)

---

The optimizer is INCREDIBLY intelligent. Serious rocket science type of stuff. But it only has so much information to go on and (perforce) a limited amount...

So what you're saying is around 137 BC she'd be a goddess in the...

Grant Fritchey (3/16/2010)

---

CirquedeSQLeil (3/16/2010)

---

Roy Ernest (3/16/2010)

---

CirquedeSQLeil (3/16/2010)

---

You wrote an...

Bob,

Thanks for a well written consise and much needed article. I've book marked it for the next time someone asks me why their query worked fine in the...

Excellent Editorial. Been there, done that, have the t-shirt. Both as the DBA or engineer taking the heat triaging the situation and as the management accessing what went...

Good question but I hate "Select all that apply" questions.

CirquedeSQLeil (3/12/2010)

---

Alvin Ramard (3/12/2010)

---

I emailed you my question. Even though I had...

A couple jobs ago on a sql server 2005 standard edition instance I had a problem like that with a memory leak. Randomly, even when the server wasn't busy...

Jason,

Thanks for a good article, I enjoyed reading it.

homebrew01 (3/9/2010)

---

The system databases are so small, there's no good reason not to back them up.

Trying to see how much you can get away without doing isn't really a good...

Love it! Keep them comming.

Lol. I saw that thread. You all cracked me up. I...

Nice article. It was well written and enjoyed it. I see that this is a reprint. Did you ever publish the 2nd part?

I didn't know about...

Chris Morris-439714 (3/5/2010)

---

Jack Corbett (3/5/2010)

---

For those not on Twitter, I passed the 70-432 Implementing and Maintaining SQL Server 2008 exam yesterday. Easier than I thought it would be....