Grant Fritchey (8/12/2008)

---

I'm sorry the article wasn't clear enough on these points. I was really hoping to help people who had been stuck like I was. It seems I may...

Sorry, I meant that I figured out how...

Actually I figured it out after a...

In the article, does the rule output data to the Event Log?

If not, how can I get a rule to do so?

Thanks!

SQLEngine (8/8/2008)

---

Marios, I agree completely. I've had some "challenges" dealing with MS support as well, and have found lack of documentation and expertise... So that's why these posts, blogs, forums...

Grant Fritchey (8/8/2008)

---

Yeah, that's pretty common. We have a Microsoft consultant who comes in on site to help us with OM issues. I showed him what I was doing and...

Grant Fritchey (8/8/2008)

---

Thanks. I'm glad it was at all helpful. Keep an eye out for Thomas LaRock articles too. I know he's got a new one coming becuase he let...

Grant Fritchey (6/5/2008)

---

Thanks guys. I realize it's kind of an obscure topic, but I had such a hard time tracking down the individual pieces of information that I felt compelled...

No takers?

Vivien Xing (8/3/2008)

---

Another addict seeks advice here.

Marios, how did you resolve your problem? Does Microsoft help you anyhow? Any story to share?

I encountered the same problem and need...

GilaMonster (8/2/2008)

---

Marios Philippopoulos (8/2/2008)

---

FULL SCAN, though it works to alleviate production issues, is a maintenance nightmare. One cannot run it on the whole database all the time because it will...

Grant Fritchey (8/2/2008)

---

And that's why we've only had to do the FULL SCAN in a few places and on a somewhat irregular basis. Most indexes, most of the time, if...

i6004835 (8/1/2008)

---

I'm not quite sure also about SQLDMO_1. But it seems from other posts in the internet to be a system process. Some say that It is linked with Enterprise...

GilaMonster (8/1/2008)

---

Possibly more accurate to say, "If Rows Sampled is much less than Rows and you are dealing with a large table and you have a non-uniform data distribution,...

Don't forget about tempdb! Place tempdb data files in their own independent physical array, if possible. This may be more critical than RAID level.