When updating a large table using transaction, make sure there is enough space for the log file.

This includes …

  • BEGIN TRANSACTION
  • Alter column in a table
  • Create index

Tips …

  • Shrink database data and log files beforehand
  • Break up the query into multiple queries
  • Adding more space to the drive where the log file resides
  • Create indexes after alter table has completed
Last modified: July 16, 2020

Author

Comments

Write a Reply or Comment