• Just had this same question on another thread with a trigger and doing a large insert...almost verbatim from the other thread:

    One thing I can say is that if you were to alter your trigger to skip the update and you supplied the correct DOB in your INSERT statement you would save yourself a ton of I/O. You would need to do some impact analysis however to ensure a change like this would not compromise your data should other inserts or updates supply invalid values for that column thereby circumventing the usefulness of the trigger. If that were a concern there are other things you could do with CONTEXT_INFO to skip the work in the trigger for only your batch process.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato