Statistics Update Date

In order to determine the datetime that the statistics of an index where last updated the STATS_DATE function can be used.  Below is an example to determine when the statistics were last updated for the Primary Key (PK_Orders) on the Orders Table.

SELECT STATS_DATE(object_id(‘orders’), INDEXPROPERTY(OBJECT_ID(‘orders’), ‘PK_Orders’, ‘indexid’))