What I'd look for is items in Profiler that are either

a) executed a large number of times (group by and count the SQL command/proc call)

b) things that take a long...

Add two columns to the tables, specify default constraints, use a format file with bcp or specify which data from the file goes to which columns.

bcp/BULK INSERT is not a...

I've got an old article on this, but as Silverfox mentioned, it's not a simple thing to do. What have you done, or what do you understand about the process?

http://www.sqlservercentral.com/Forums/Topic1603-32-1.aspx

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