• In the somewhat special case of ETL, I'd sometimes like to turn of logging.

    If a data load fails, the destination table can be truncated and the load can start over again, so you would not have to worry about inconsistency.

    I'm only talking about the import layer here (the E of ETL). If updates are performed on datasets in the database, I would very much like logging, as I would like to go back to a previous state if necessary. But for imports, nah, I don't need logging 🙂

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP