By configuration files are you referring to something like a .ini file containing connection string information or are you talking about something else?

You're absolutely correct. Not sure how I missed that. Thanks

Some of these have already been touched on but ...

1. Implementing views without understanding them. Far too often I've seen views that either were not needed, or referenced views,...

Thanks for the links. I'll give the WMI fix a try. Besides reboots we've also been able to temporarily fix the problem (and I stress temporarily) by following...

I'm curious if your WMI problems are the same as ours. Only on our 64bit servers we have noticed that periodically WMI appears to stop working. We have...

Here's an update. I opened a case with Microsoft in late January and unfortunately it is still open. They now want me to run a lightweight version of...

No. We don't have it on.

Looks like I am 0 for 3. Not good. I did some reading so let's see if I have a better understanding.

No. Parallelism occurs when SQL runs certain...

Thanks Thomas. I'll check out the link, but my comments are based upon two BOL articles. Here is a quote from one.

Use the cost threshold for parallelism option...

Thanks Gail and Thomas,

Gail, I found out this week my understanding of parallelism was incorrect and am still trying to fully comprehend its meaning. I had thought parallelism refers...

I'm sending him the formulas for plan cache and telling him we have to agree to disagree because I don't wish to discuss this further. He's now telling me...

Thanks Gail. I'm going to work with our SAN people (notice the Star Wars reference) today. I've been telling them for a couple of months we are not...

Bingo. You guessed it. He's now hitting us with claims about adhoc plans consuming 28-32GB of cache and that the cache will never be released because the plans...

The vendor indicated it's a mix of batch and short transactions. We haven't had a good opportunity to witness what occurs more, short transactions or large batch. At...

Same here.