SQL

SELECT      OBJECT_NAME(i.object_id) AS TableName,     i.last_user_seek,     i.last_user_scan,     i.last_user_lookup,     i.last_user_update FROM      sys.dm_db_index_usage_stats i JOIN      sys.objects o ON i.object_id = o.object_id WHERE      o.type = 'U' -- User tables     AND i.database_id = DB_ID() ORDER BY      GREATEST(ISNULL(i.last_user_seek, '1900-01-01'),              ISNULL(i.last_user_scan, '1900-01-01'),              ISNULL(i.last_user_lookup, '1900-01-01'),              ISNULL(i.last_user_update, '1900-01-01')) ASC;