Ha - that tag line about space couldn't be more wrong.

I did a quick check.

deleting the rows from the table in sql 2000 used 852M log space

deleting the rows from...

The query plan generator in 2008 is very different from the one in 2000.

So the time difference is expected on big / complex queries.

I'd break the joined queries into individual...

Just in case anyone searches and wants to know what happened.....

I think our server hardware guy had local drives and a tape drive on the same scsi channel.

He moved the...

I recently noticed that the backup database command in sql2005 does not truncate my transaction log like it does in sql2000.

That could be the cause of your ever increasing transaction...