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

As Mike showed, you need to write the update statement first.

Once you do that, just enclose it in a stored procedure.

create procedure UpdateDownload

as

update....

return

Let me say that I might recommend you...

change the file sizes in the database properties in SSMS, or you can use the ALTER DATABASE command (http://msdn.microsoft.com/en-us/library/aa275464%28SQL.80%29.aspx) modify the file size.