• Hi,

    As you said you have big tables, then enabling trace flag 2371 can be of asset for your databases. See this

    http://blogs.msdn.com/b/saponsqlserver/archive/2011/09/07/changes-to-automatic-update-statistics-in-sql-server-traceflag-2371.aspx

    Regards,

    IgorMi

    Igor Micev,My blog: www.igormicev.com