An ACID Trip: How SQL Server Transactions Work

In a recent consulting engagement a system administrator asked me “what’s the point of the transaction log? ” followed by “do we need it?” and “can’t we delete it?”

Continue reading