Richard Doering has a script to check use stats for databases on a SQL Server instance. Because the script is built around index usage stats (sys.dm_db_index_usage_stats), it is important to note that it only keeps track of index usage since the last time SQL Server restarted, or the last time somebody reset the DMVs. As…