True enough. @=)

Oh, yes. I've been on the interviewer side of the table myself. It makes me appreciate that I was smart enough to build myself a SOHO and actually work things...

Maybe for you it is, but some of us didn't have paid professional IT experience when coming into this field and others have to work for employers who require the...

Far away from the point??? What do you mean?

Yeah, that sounds sooo familiar. Glad I'm not the only one with that problem. @=)

The main database I oversee was so not meant for the use people are putting it...

Just curious... How is performance (read/write) on those insane indexes of yours, Jeff?

You can shrink manually, but it's not recommended. And if you're having to shrink the log files often, you don't have enough disk space and/or you have really terrible queries...

Look in BOL for "OpenXML" (use the Index feature). This will give you a lot more information than just a post.

SQL Server requires you to prep a "memory space"...

You should do regular database size checkups to see how often and how much your database grows on a weekly & monthly basis. Then configure your max database size (presuming...

Try dumping their DNS cache and see if that works. It might be that these servers have a specific DNS name that hasn't (for whatever reason) been refreshed on those...

Adrian & Steve,

I would love your help. :w00t:

I'm in no rush, so take your time. And you can do as many or as few of my articles as you...

Congratulations!

The first step is always the hardest. @=)

I prefer Transcendor myself. Plus Microsoft's website for certification usually has a 10 question "sample" you can look at.

If you get more cert study books, aside from the training...

Hmm. Interesting. But it sounds awfully bulky and hard to maintain to me.

There's no way I would want to implement something that "complicated" in my environment. We'd constantly be forgetting...

NP. Glad I could be of help.