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

Advertisements

Thinking of getting a bigger pool?

SQL Server 2014 introduced us to a number of great new features, one that’s often overlooked but can quite easily improve the performance of read-heavy OLTP workloads, especially on resource constrained hardware, is Buffer Pool Extensions (BPE).

Continue reading