There is a task in the maintenance plans that will do this (maintenance cleanup).

Or try another reboot. I've seen things get stuck in prior versions, no real reason. A reboot fixed it.

If you do want to reboot, I might run sqldiag and capture...

Jack has a good list, I also used to log the sp_configure options.

I'd set up a database for this stuff, make it a standard name (I used dba_admin) and then...

I was going to write what Gail did. I like the idea of persisting these in a table variable and then writing them out. I'd still use TRY CATCH, but...

Do you have a backup before 10/18?

Even on tape?

nice question, I missed the clustered part.

The engine definitely should inform someone if this doesn't work.

Glad you like it.

I think you might be right, and we will be looking at ways that we can easily move people from one side to the other, maybe...

I think we'd like pictures from both you and...

Statistics are the big thing, but it also depends on the size of the table. For example, if you have a table with 100 rows, it probably will just scan....

I'll say that I don't think that's appropriate. Denigrating an entire group is bigoted, and not necessary.

I agree with Gail. Work on one, then the other. No reason to do them together.

You're updating all rows, no reason to seek. Need to scan to hit all the rows.

Apologies, maybe a little patronizing. Nothing wrong with those jobs, but for the most part those aren't skilled jobs. Anyone can do them, and that's usually why the pay is...

You should be able to re-run setup and add in additional features.

If you have a database backup, that's good, but an uninstall won't mess up your mdf/ldf. You'll just have...

Yes, if you don't know what to do. Even if you have staff, hire someone for a couple days to examine the system and train someone on your staff.