• If you want to remove all the data from a table, use TRUNCATE TABLE because its damn fast. The transaction log will just contain the TRUNCATE TABLE command.

    If you use DELETE FROM then the transaction log contains a record for EVERY ROW in the table, a slower process.


    Julian Kuiters
    juliankuiters.id.au