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...

This is a logged operation, and so two copies of the index are needed until the reindexing is finished.

Your databases are growing because you have not properly sized them. The...

If this is production, call MS. Don't mess around with this.

Are you sure it's the same code?

Can you post it?

Silverfox is correct, this wouldn't apply if you don't hold a MS certification.

I wouldn't look at the exam page, look at the certification page and choose the path the makes...

Yes, that's all you do. Monitor the size and free space, and keep enough space to last you 3-6 months. Increase it in one large chunk for the next 3-6...