Tag: crash recovery

• Bulk Changed Map (BCM): The Minimally Logged Advantage

  

  2014-05-14 - General, Series, SQL Server Internals, Storage Wednesday

  The Bulk-Logged recovery mode can provide a performance gain for your database. Check out how SQL Server uses the Bulk Changed Map to make this possible.

  [more…]

• Eight Reasons why your Transaction Log Files keep growing

  

  2014-01-12 - General, Log Reuse Wait, Series, SQL Server Internals, Transaction Log

  SQL Server organizes the transaction log as reusable virtual log files. However, there are eight reasons that can prevent their reuse causing the log file to grow. Find out what those reasons are and what to do about it.

  [more…]