Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning Why create statistics on every column of every table in a database. RE: Why create statistics on every column of every table in a database.

  • March 24, 2010 at 9:15 am

    #1138987

    SQLDraggon (3/23/2010)

    I told them there is no reason to do that for every column and every table ... but they insist.

    Put the burden on them. Ask them to provide you with reasons why you should do it. Have them provide reasons and sources. Thus you can more easily counterpoint their demands.

    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