antonio.collins (10/8/2012)
a trigger can be written so it is only fired if some column(s) of interest are set/modified.
Not entirely true. A trigger fires for every qualifying DML action. For INSERT and UPDATE actions it's true we have the UPDATE() function to check whether the DML operation included a reference to a specific column but that does not preclude the firing of the trigger, i.e. if the trigger is enabled we always incur the overhead of the trigger firing.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato