Thanks for the informative article.
One question though. My question is to know if there is any advantage of one method over the other. Or is it just preference (...I say toMato and you say TomaTo case)
In part II, active logging with triggers, on INSERT the code stores the INSERTED record. On DELETE, it stores the DELETED record. But on UPDATE it stores the new record from the INSERTED table rather than the row that is being deleted.
I've always stored the row that is being deleted (i.e. from DELETED table except for INSERT).
I see both methods to be of same value. but wanted to know what you think of it.
SqlTimes Blog on Sql Server