I know this isn't very Ruby or rails specific, but if you are doing big changes to your db on big datasets and you don't use transactions, you deserve whatever comes your way.<p>Realize you've fucked up? A quick <i>ROLLBACK TRANSACTION</i> and you are safely back where you started. This is so freaking simple, I can't believe people aren't using it.