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: Thursday, July 31, 2014 11:06 AM
Points: 274, Visits: 1,466
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: Monday, July 28, 2014 7:21 AM
Points: 206, Visits: 764
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: Friday, August 1, 2014 6:18 AM
Points: 1,618, Visits: 20,980
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