Managing Large Transactions

Four common transaction types can result in extensive logging:

• Mass updates
• Table deletes
• Inserts based on subqueries
• Bulk copies into a database

The following sections explain how to use these transactions so they do not cause extensive logging. Because of the amount of data that SQL Server logs, it is important that you manage large transactions efficiently.