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.

Is this a remote SQL Server or another data source?

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