• That is an error in the article! This is wrong:

    For large databases, do not use auto update statistics. Update statistics via maintenance jobs instead. I recommend the following maintenance jobs:

    • Update statistics on work days with at least 10% sampling (100% for filtered indexes)
    • Update statistics every Saturday with fullscan

    It should instead be:

    For large databases, do not use auto update statistics. Update statistics via maintenance jobs instead. I recommend the following maintenance jobs:

    • Update statistics daily with at least 10% sampling (100% for filtered indexes)