• Whether you have triggers on a table or not has no bearing on whether transactions are written to the transaction log. All transactional operations are logged (in all recovery models) so you will not gain anything tangible by dropping vs disabling a trigger.

    Also, triggers do not operate asyncronously, somehow mining the transaction log. They will be fired for each relevant DML statement as part of the same transaction.