[This thread is associated with Part 18 of the SQL Credit series.]

Do you see something that would make the OUTPUT clause work as fast as the trigger?

Wrapping the DestinationTableBase INSERT and the HistoryTableBase INSERT in a transaction helped performance at the numbers I was running, but it's quite possible that at much larger rowcounts, the transaction would actually hurt performance.