I still don't understand the Cadillac reference.  Is he referring to a company that used to have a reputation for putting out luxury cars and now just put out hideous...

You don't need to recreate the DTS job, just select the System DSN from the list in the connection object in your DTS job.  If you have the User DSN...

Things to check :

System DSN - looks like you already did this, double check it anyway!

Log SQL Server on as Local System account

How are you calling the DST job -...

10 terabyte database maintenance for a begining DBA?  Ouch.  I got three things to for him to do on this project - Research, Research, Research.  I hope you have high...

Grasshopper - when you say that the daily backups are sent to the file server and then restored to the secondary.  Is the restore automated?

Do you get any performance increase...

I have ran the tests at multiple points during the day with varying loads on each servers.  We always get the same results within a couple hundread rows returned. 

I did not know about the 'update in place' rule.  It makes sense about the varchar, but why the NULL? 

I do not have a clustered index on this table.  This is because the table is heavily updated and selected.  There are very few inserts or deletes on the table. ...

Turned off autonegotiate and set it to:

100mps full - network card couldn't communicate

100mps half - network card couldn't communicate

10mps full - network card ran ok

10mps half - network card ran...

We modified the applications and removed Named Pipes and got about a 4% increase in query times.

I CAN'T BELIEVE I DIDN'T SEE THAT. 

I really need to get more sleep.  Our system went down over the weekend and I pulled an all-nighter to get it back up. ...

I our 6 years with 2 large production servers, we have had to restore from SQL server backups twice.  We have probably had to restore a certain table that was...

BCP dump and scripts of databases are useful if you have a table that someone dropped or wiped out on accident.  We have actually had to restore more often from...

Didn't put in database sizes. Sorry about that.  Pulled an all day & nighter Sunday to Monday to get system back up at 6am.

Database sizes vary from 5gig to 30gig. ...

Both servers have the same database except for the smaller row counts on the new server.

Ok, here's what I did yesterday:

Defragged all drives - (Diskeeper - boottime and runtime)

Added /3GB...