• Stewart "Arturius" Campbell - Friday, January 12, 2018 2:39 AM

    Interesting question to end the week on, thanks Steve.
    However, I wonder why anyone would need to do this (other than obtaining a benchmark)?

    The only use case I have for this, it is when you need to have databases in full recovery model, but you don't care about point in time recovery (sounds crazy, but keep reading), for instance if you have Availability Groups/Mirroring in DEV but you don't really care about transaction logs, you can clear the log using TO DISK = 'NUL'

    Cheers