Statistics update

  • Hi

    How to know the date & time of update of statistics in SQL Server 2005 ?

    Please help.

  • Select *, STATS_DATE(object_id, stats_id) LastUpdate From sys.stats

    You can join it with sys.objects to get the table name.

  • Small tweak to Oliiii's query will give the object name as well

    Select object_name(object_id), STATS_DATE(object_id, stats_id) LastUpdate From sys.stats

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply