Fair enough, and thanks for the comments. To some extent I agree with your view of it.

When you post or reply to a thread, you can select to subscribe to the thread with email notification.

How big, how much common data?

If there's any chance for one causing issues on the server, especially with heavy tempdb usage, and might require it's own server, I'd say...

Terry is correct. The space is available to be re-used by the next reindex job, or by data growth, but the file size does not shrink as far as the...

I think you're missing out by ignoring blogs as well. First, if it's not their writing, I think you'll see that in the interview. What they put on their blog...

I know quite a few people that still enjoy Microsoft, both inside SQL Server and outside of it. Meeting some of the developers and PMs at the MVP Summit was...

string manipulation can be a bit tricky. I think Garadin has you on the right track for part of it.

To pull out the car, you need some rules about how...

Elliot is correct, you upgrade your license to 2008 from 2000, picking the edition you want. Standard -> Enterprise may be costly, and I'm not sure you save much if...

Of course! I was surprised to see the Broncos win, but it was a great...

I think you can be anonymous, or create a local account.

Doing what you think is the best practice, or implementing something independently doesn't necessarily mean you are managing yourself. Managing yourself includes communication with your boss and appraising them of...

If you rarely restart SQL Server, the log grows like crazy. I'd set a job to periodically cycle error logs. However I would also increase the number of logs you...

Looks like a good plan overall. I agree with Silverfox, don't shrink.

Everything is still logged in simple mode. Once the transaction commits, the space is reused.

The index is rebuilt as a separate copy, that's in the data file, and you need...

What do you mean by disturb the log? When you set up a new database (new or restored), the log starts from zero. Old logs don't matter.

You would use WITH...