• That blog post is wrong in a few places.

    This, for example, is wrong.

    Bulk logged recovery model performs much better than simple logged recovery model because it uses minimal log space and minimal logging is required.

    So is this

    Main draw back of the full recovery model is that, you have to setup a regular transaction log backup to avoid the growth of transaction log files, otherwise the log files keep growing until the next full backup.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass