If a query optimizer picks a deferred-mode update for a table that qualifies for minimally logged operations, the minimally logged settings are overridden for that statement and the statement works in deferred mode, but with full logging. Applications that generate DML statements in deferred mode with large transaction logging do not benefit from minimal logging. Once you execute a deferred-mode operation for multistatement transactions on a table, all subsequent DML statements on this table are fully logged.
