Category: Transaction Log

Paul White explains in detail the factors SQL Server considers when enabling minimal logging for inserts into an empty clustered table.
Paul White explains in detail the factors SQL Server considers when enabling minimal logging for inserts into a table without a clustered index.
Itzik Ben-Gan explains log buffer flushes and shows how to use them to help balance performance, transaction size, and durability.
November 14, 2018 | SQLPerformance.com | T-SQL, Transaction Log 0
With detailed information and his uncanny knack for explaining technical concepts very well, Paul White concludes his series on ACID...

Get the best SQL query analysis and optimization tool – free!

Plan-Explorer-logo-RGB-800px
  • Index Analysis Sandbox
  • Statistics Analysis with Histogram
  • Management Studio Add-in
  • Plan Diagram
  • Deadlocks
  • History and Comments
Free Download Learn More