Maybe you could target meeting some SLAs, perhaps responding to all requests within xx days or answering all emails within a day or something that shows you are working well...

The script above should help, but why would that date impact whether or not something was being decommissioned? I'd think it was being used or not.

Be aware that you might have issues with this if the server is at 100% CPU. You might want to set something up with a monitoring solution on the Windows...

Are you looking to partition the tables across multiple file groups or databases? What is the problem you are trying to solve?

You don't want to do this in T-SLQ, it's horribly inefficient. Holding a file handle is asking for concurrency issues. Using a cursor wastes resources. And SQL Server will not...

XQuery is the choice for this, but it's limited in 2000.

This is really something you want to do in another language, not T-SQL.

You can do all that, but most people just won't read the rules/ideas/hints, and just post a question.

We have PDF versions and are working with developers to get an "ebook" section here on the site.

Log backups will keep the log at a manageable size.

You should have free space in your data files, which is used up as you add data and make changes.

How big...

It was always one of my favorite things early on in this site to answer questions and help others. I've always felt that most of the people reading the forums...

Robert,

I agree and I'm always happy to see people posting hints rather than complete solutions. Especially when people haven't made any attempt at it themselves.

Never hurts to apply a little more pressure. You've got fans now!

thanks for the recommendations on speakers. I'll check them out. Always good to find someone worth listening to.

Also , the network can be unreliable. Copies and other file operations tolerate this. The SQL Backup process won't.

You really want to back up locally and then copy to a...

norecovery can't be used with notrunate apparently. I don't see anything in BOL, but I bet you can remove the no_truncate and it will work.

http://msdn.microsoft.com/en-us/library/aa225964(SQL.80).aspx