Team Blog

Paul White explains minimal logging for inserts into b-tree indexes using Fast Load Context, and why it might not always work as expected.
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.
1

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

Get a Free 2-Week Trial

Start your free trial of any of our products today.

Free Trial

2-Week Trial