Checking for unused indices across your database should also be a part of housekeeping. Usually i would schedule checking for unused indices on quarterly basis. Just to minimize surprises on a database suddenly timing out. The DMV for checking on usage and statistics is sys.dm_db_index_usage_stats. Here’s a script that i use most of the time […]