Running out of disk space when updating a large table

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