Home Forums SQL Server 2005 T-SQL (SS2K5) delete records in sql without entry in transaction log RE: delete records in sql without entry in transaction log

  • You want deletes in the transaction log. That's how you can do a rollback if there is a problem. Plus, transaction processing is an essential part of the system maintaining data integrity.

    If you want to remove data without logging, you can't be selective, you can use the TRUCATE statement, but there are all kinds of limits on that.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning