SDU Tools: List Disabled Indexes in SQL Server Databases

added by DotNetKicks
6/18/2019 12:56:59 PM

1 Kicks, 156 Views

I carry out a lot of basic health checks on SQL Server databases. One issue that I come across fairly regularly is that the databases contain indexes that have been disabled. Most of the time, when I investigate why that's happened, the customer has used some sort of ETL process and has disabled the indexes ...