I’ve stumbled across many index interrogation queries over the years and each had something unique to offer. I thought I would share the one I use. It functions at the database level so you’d need to run it once per database. I successfully used it to drop unused indexes and defragment several production servers this [...]