Stats should be automatically updating. Run them manually if you have big data changes (loads or deletions), or schedule them if you have regular changes, prob weekly.

Backups - Like Ronda's...

SQL 2000 - One mailbox. The reason is the service account logs into Outlook and Exchange/SMTP servers, using that particular account. You can do it personally with Outlook, but you...

Never turned this on, but I think EM does check periodically anyway to see if the server is alive. Even logging to the Event logs (which is annoying for admins,...

Carla,

I'd actually ask you start a thread in the SQL2K or SS2K5 Security areas on authentication. It's worthy of it's own discussion.

I will say it's good you're looking into it...

Robert,

Sounds like you either have a great job (if you don't mind chugging along) or a bad one and need to look around. Management has a huge impact on things....

I think that very little of SQL is portable these days, Jeff. The basic SELECT code might not be too bad, but I'm sure anything beyond a single statement requires...

I tend to agree with Jasmine. I comment stuff that isn't inherently obvious about why the code is written this way. A business rule, fix a bug, etc. I expect...

It looks like you want a sequence within each set of values. Is this something permanent that you need or is it for reporting? Meaning do you want to add...

OK, first, I didn't work on any 431 books, so don't blame me

Second, you definitely can have multiple snapshots on a database. There...

I think your MCDBA is recognized forever, but as a SQL 2000 certification. SQL 2005 has the MCITPro and MCTS certifications. My guess is they will be updated for SQL...

Can't tell you what the cost is. It's a decision for the people in that situation. Lots of people accept shoddy work in construction, engineering, medicine, etc. for a short...

You are partially right on the opportunity cost. Andy, Brian, and I were all earning hundreds of dollars a month writing when we started this site, at least a car...

Actually there are days the stalls aren't taken care of. There's a tolerance for delays and there are possibly days where food is left out because no one can get...

Jeff,

you bring up great points and I mostly agree.

But the problem for me is that you're talking risk. Most of us have no idea, well not zero, but very, very...

Ha, not sure this site was a risk. It was a hobby that grew and grew and it was fun to put time into. If it had never gotten beyond...