Home Forums SQL Server 2012 SQL 2012 - General Index Maintenance and Update Stats RE: Index Maintenance and Update Stats

  • July 25, 2014 at 3:21 am

    #1732294

    SQLSlammer-133701 (7/23/2014)

    I hope this doesn't get viewed as a thread hijack..but TheSQLGuru.

    If you are updating stats more than once week, at what point do you update stats with FULLSCAN? or do you not bother with that?

    I preferentially do FULLSCAN whenever the system allows it.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service