[Index] Statistics age

This is pretty handy. Lets you know if your stats are out of date.

Found at http://furrukhbaig.wordpress.com/2007/08/17/index-statistics-age/

SELECT
           'Index Name' = ind.name,
           'Statistics Date' = STATS_DATE(ind.object_id, ind.index_id)
FROM
           SYS.INDEXES ind
WHERE
           OBJECT_NAME(ind.object_id) = ''