What I think you'd want to do is calculate the sizes of all rows that you have in the db, for all tables, and give that to the customers as...

Out of curiosity, how much timeout did you set for how many GB of data?

This works well with Tony's DBW editorial on tuning.

The less you write good code, the more DBAs needed.

We will never get away from admins. We might have less / GB...

Excellent points.

I think that you ought to try to tune your code, you ought to go back and refactor it when you can. However deadlines, and time pressures can force...

I'd agree that the foundations were set with the generation before the boomers. The boomers built on their work, but the explosion of computing, the push to cheaper chips, to...

If the package cannot complete all steps, it fails. So that is the mail you are getting. It isn't a "backup" it's a package.

One thing you can do is use...

Jobs run local to the instance, on local time.

I'm not sure what you are asking.

I would make sure you run a DBCC checkdb in msdb.

These don't help you in backup recovery.

The LSNs are the sequences of transactions. In ordr to restore you need the logs in sequence for there to be a chain...

There's a gap often between development and operations, but I believe it's often due to a lack of professionalism. I've seen too many development groups that don't do more than...

Even if you script things, there are possibly names, identifiers, keywords, etc that are not valid on SQL 2000.

What are you trying to do? Can you not install SQL 2005...

Bru has good advice. I would make sure you have good backups of all databases in case you need to need to rollback. That would be an uninstall of SQL...

That's why you should move to Denver :), 2 hour flight to Seattle.

I'm glad it appears to be resolved and you didn't have to do anything. I'd cautiously watch the apartment for a new, smaller camera, or blinds/shades moving.

Hope for the best,...

There are any number of ways you could hash things. Here's a quick article on the functions you use (http://weblogs.asp.net/bradygaster/archive/2003/11/26/39935.aspx).

Basically instead of

insert users (username, password) select (@user, @pwd)

you'd do a...