Deleting records fast

Use TRUNCATE instead of DELETE on tables that do not contain any foreign keys for a faster delete. Truncate does not post to the log.
You could temporarily remove all foreign keys, then use Truncate, then add the foreign keys again I guess too.