Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Statistics update Expand / Collapse
Author
Message
Posted Friday, September 17, 2010 5:26 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 8:53 AM
Points: 273, Visits: 1,431
Hi

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

Please help.
Post #988082
Posted Friday, September 17, 2010 5:55 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, April 11, 2014 1:11 AM
Points: 206, Visits: 756
Select *, STATS_DATE(object_id, stats_id) LastUpdate From sys.stats

You can join it with sys.objects to get the table name.
Post #988092
Posted Friday, September 17, 2010 10:49 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, January 30, 2014 8:52 AM
Points: 1,618, Visits: 20,966
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
Post #988408
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse