There are a few things. There isn't a client per se. There are client tools, which you will find in a group in Programs ( SQL Server 2005), but every...

This typically happens when you run a backup, and add a new backup file in the "Backup Database" dialog. Since the new file is highlighted and the one that was...

There are a few issues, and Clive has talked well about them.

The more often you run log backups, the smaller they are. However, to apply them, you need to interrupt...

Improving query performance depends upon many things. You have to look at the queries, see if more indexes would help. Or if different indexes would help. How often do the...

You misquoted MSDN. The quote before that says IF the data files need more space and can't get it, a database engine error is issued. The quote misleads people to...

The cursor thing isn't a big deal for adding these. It's a one time loop.

For the programming, you want to avoid them and just write out the statements. Not sure...

tempdb is highly dependent on activity and data sizes. If you have a 500MB database, 10GB is way overkill.

Disk space is cheap, and it makes sense to just assign some...

Even if the disk fills up, data can be interested into a database provided it does not need to grow. Databases typically have free space in them, and if yours...

You have a full log file. Are you running backups? Is msdb in simple recovery mode or full?

Please post your question in the edit box, not the title.

I'd definitely look at SS2K8. There are bugs, but overall it's a more mature, stable version of SS2K5.

Possibly. Not sure if that patch hits shared components or not.

Why not setup a separate instance on another test machine, or even in a VM? I wouldn't gamble with production.

I'd rename the table. That will tell you if it's still being used.

Quick.

You have to connect to each SQL Server and run this. There isn't another way.

You can write a script using sqlcmd to do this, looping through the list of servers,...

Nope, good to call me out. I probably am missing more.

I've not really used WSUS since I want control over when and where they are applied to which machines. I...

If you want to overwrite backups, use the same file name and the WITH INIT clause. However this isn't a great practice. If it fails partially in there, you don't...