The install should write something in the log file about where it failed. Look at the bottom and work your way back to an error (get past the cleanup/rollback). The...

You do not need to recompile if you are cleaning up fragmentation. The plans don't take fragmentation into account that I know of, just statistics. If you have a huge...

This isn't a solution, but can you not stop the backup job from SQLAgent? Does it show as running?

Also, is this only backing up one database? I'd also dig into...

That's what you have to do unless you remove the FK reference.

The references usually exist so that you don't get child data that's orphaned, or lost without a parent.

The hosts files doesn't require a reboot, but not sure if that's cached. If it is, that's an issue.

2 - Replication will still run and wait for the server to...

I'm sure traffic is much worse in places other than Cambridge. It's felt small, and a contained craziness to the driving. I'm just not used to people going up on...

Rob,

It's just here to teach you something about the product, not propose a solution. If we had E, then everyone would answer and not look it up

Good you like your job, James and the extra hours are fun when you do.

good resources and you might be right. I know it's worked for me in some simple projects, but the time to get up to speed was long. Much longer...

A bullet to the disk drive? You hunting moose up there in Alaska?

It's so those hard smashes will leave a rug burn!!!

Fuzz on a tennis ball? Who cares is the answer, unless you're interviewing for...

Michael,

That's a good point and I hadn't thought about ETL becoming more a developer's area. However far SSIS has improved the ETL capabilities of SQL Server, it's also left behind...

Expecting more hours is definately illegal, but it's often assumed.

It can be hard either way. Taking care of errands, meeting the cable guy, etc. are easier when there are two...

Using full scale disk encryption, like Pointsec, is a good start, but I don't think developers should have real corporate data on their laptops. Obfsucate or scramble the data for...

Modern Physics in 21 days?

I did not like Particle Physics in my college days. I somehow figured out the math and could solve the problems, but didn't understand the meaning...