A good example might be when you have all-or-nothing ETL processes ... Aaron also provides a great many links to other resources that discuss the inner workings of the SQL Server transaction log, ways ...