I agree with Jeffrey, shrinking causes fragmentation on data files and is a waste of resources on log files. Set the files to be the amount of space you need...

The differentials should take longer and longer as you get further from the full backup, be sure you test this to know what your times are. Perhaps test the full...

Guess no one is working today or my cell phone woes didn't strike anyone as funny.

I do think they ought to adhere to a schedule, but not at the expense of bad code. And this is a management issue, not a coder issue. I think...

When you say rollback, what do you mean? DBCC should allow you to reseed the identity value. If you get that message, then I would guess the identity property is...

Is that USB powered?

I think dphillips has an interesting idea. The meta data is there, why does it drive the display for everyone.

That's a fairly major change, and one that I'm not sure...

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.