SQL SERVER – Find Statistics Update Date – Update Statistics

SELECT name AS index_name,
STATS_DATE(OBJECT_ID, index_id) AS StatsUpdated
FROM sys.indexes
WHERE OBJECT_ID = OBJECT_ID('Sunlight')
GO


GO
UPDATE STATISTICS HumanResources.Department
WITH FULLSCAN
GO