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