• The default is 0. Your instructor might have set it to 80 for their purposes.

    No single default fill factor is appropriate for all indexes. It should be evaluated case by case.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events