Blandry, I miss that. Too many places I've worked in the last decade didn't require code reviews. It seemed once Y2K passed without a big issue, lots of companies just...

There shouldn't be. I was puzzling over how someone could do this. We should not allow blank emails.

Sorry, Gail. Rebuilt laptop on the road, no VPN, but I shall look into it.

Perhaps it is a secret admirer? Or Phil has started some new contest to see who...

I second Gail's recommendations on those books. They're worth reading.

I've always struggled with this. Red Gate's Dependency Tracker (grown out of a conversation that Andy and I had with Red Gate) really helps if you depend on these things.

I...

A disaster encompasses many things, not just losing a data center. A disaster can be someone deleting a single table (or even row), coffee spilled on a server, all the...

I don't know what a snap server does, but I can think of two things. The bad block you've mentioned, and you'd need vendor tools to check this at a...

What was it set to before, and why? I'd be wary of altering this unless you know why it is not 0. Or that you make sure that you're not...

Any version/edition of SQL Server 2008 can restore a compressed backup, however only enterprise can make one.

It does have to be 2008.

You could automate this by looping through the tables and doing a BCP out for a schema, however that doesn't get views/procs/functions.

Jack's suggestion might be the best one.

Be sure that you are now running transaction log backups, and that you took a full backup after the shrink and change from simple.

I'm surprised it took so long for someone to want a bartender. Getting up on stage almost necessitates that for some people!

Yes, you have a hot spot on the table. Note that depending on the CLI, you could have a hot spot there as well. The key is that you also...

For a heap, when you insert data, it adds to to the next page in the last extent (or makes a new page). For deletes, space is marked as deleted,...

Dave,

We'd be happy to work with you to get an article done.

The first step is usually stop and think essay, think about high school/college, and structure things like that. Write...