GSquared(4/20/2009)

---

Honestly, if you want to learn how to handle pressure way beyond anything you'll encounter in the workaday world, here are some options: join the military for a few years...

Nicholas Cain (4/20/2009)

---

The question is more about how you handle a pressure situation than the actual details. If you can handle that being thrown at you in an interview and...

The question is more about how you handle a pressure situation than the actual details. If you can handle that being thrown at you in an interview and not get...

If you are just looking to archive then create the new table with the same schema as the old.

Insert into that table based off of some incrementing timestamp value, delete...

Is there not facility within the application to schedule backups of the databases on a regular basis?

Unfortunately the only way to go back is to reinstall SQL and restore the database backups prior to the upgrade.

In SQL 2008 Microsoft have included the ability to uninstall Service...

Sorry if my first question came across a bit brutal. I spent three long years trying to find a DBA worth hiring and the only one I found was a...

GilaMonster (4/18/2009)

---

Good point. Last time I had one of these one of the manager's first questions was 'Where do I order supper from and what do you want?'

In that case,...

And don't be going all "Dad's Army" on us.... Don't Panic :w00t:

I don't know how that can be Lynn, we only see this new fangled telephony thingamybob in the last couple of years 😉

Deflect to the manager.

Say you are working on it and will provide regular updates every 15 minutes.

Put poeple at ease and let them know you are in control...oh, and don't...

The question has nothing to do with your skill as a DBA. Knowing SQL is but a part of the job.

There's no hard and fast answer. That's the point, you either got it, or you don't.

If you can't answer then you should be looking at nothing more than a junior...

If it's a subscriber set the recovery mode to SIMPLE, you can let the log manage itself. Maybe you want to put a cap on growth. If you needed more...

Here's my personal favourite to spring:

It's 3pm on a Friday, your production OLTP environment is down, every hour down costs the company one million dollars. People are phoning constantly, folks...