Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

how to check last index rebuild sql server


SELECT name AS Stats,

STATS_DATE(object_id, stats_id) AS LastStatsUpdate

FROM sys.stats
where name = 'AK_AK_TP_DATA_PDWS_ODS'
order by LastStatsUpdate desc;
Source by www.sqlserver-dba.com #
 
PREVIOUS NEXT
Tagged: #check #index #rebuild #sql #server
ADD COMMENT
Topic
Name
9+4 =