A few responses. I was thinking the average house is 4 people, 2 computers these days, TV, fridge, etc. I think my house is a little large, but these days...

Paul has a good book, though I think I like the Inside SQL Server series better.

I agree with Gail. The clustered indexes are probably more important, and you should have them on your tables, so you'll need to rebuild.

And you'll need space to rebuild.

Sounds like you've made a good decision from your last posts. Good luck!

The article states that airflow is an issue, and you definitely need to control it and ensure fresh air is coming in. The heat exchanger, which passes outside and inside...

It always depends.

I would tend to use the EXISTS clause if I could. I think there are shortcuts at times where it bails early and is more efficient. It really...

There was a debugger in 2000. If I remember right, the service account for SQL needed to be an admin for this to work.

Do you mean new hardware? I'm a little confused as to what was installed where and what you want to uninstall and accomplish.

Is this a remote SQL Server or another data source?

You can attach a screen shot using the Post options below as well.

Hardware is the only RAID I'd recommend for any server. Maybe software on a desktop, but not a server.

I'm not sure you gain from having two files on one device...

I'd run a trace of some sort, looking for the backup event in between the time when you run a full and the time a diff is scheduled. There must...

I do agree with the other Mr. Jones that this hard. And we have two basic issues as I see it.

1. Making it easy for people to post questions

2. Making...

Andy Warren and I gave a presentation on this at PASS and I'll give a few thoughts.

First they're different jobs. I don't think you can manage and do technical stuff,...

Hopefully not an ache to your ear! :w00t:

Thanks