After upgrading from SQL2005 to 2008 SP1, we're suddenly observing disproportional expansions of the database log file during large transactions.
Example: inserting 75 million rows into table B, deleting those same 75M rows from table A, both in the same transaction. Total amount of data about 2 times 20GB, but database log file grows to 150GB and beyond.
Never seen this in SQL2005, before upgrading.
I couldn't find this documented as a known regression in SQL2008 anywhere.. anyone seen this, too?