SQl stats

• Satya_0000

  Mr or Mrs. 500

  Points: 544

  More actions

  November 27, 2011 at 6:35 am

  #263542

  How to find when the statistics were updated in a database?

• viiki.seth

  Ten Centuries

  Points: 1127

  More actions

  November 27, 2011 at 6:38 am

  #1413168

  Here is a query to find.

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

• Satya_0000

  Mr or Mrs. 500

  Points: 544

  More actions

  November 27, 2011 at 6:40 am

  #1413169

  thanks Vikki.