DB Tricks » Deleting large number of rows without filling the transaction log. Sometimes, when you try to delete a large number of rows from a table the transaction file may grow to the point that you will run out of disk space.
In other occasions, when the transaction log growth is limited, the delete can fail with the following message: The transaction log for database ‘database name’ is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases There are several ways to overcome this issue: LINQ to SQL. MSDN Library Articles and Overviews .NET General LINQ: .NET Language Integrated Query LINQ to SQL: .NET Language-Integrated Query for Relational Data .NET Language-Integrated Query for XML Data.
