This SQL-sentence helps you find the tables with enabled or disabled indexs.
I haven’t been able to find this information through SSMC.
SELECT name, is_disabled FROM sys.indexes
where is_disabled = 1
This SQL-sentence helps you find the tables with enabled or disabled indexs.
I haven’t been able to find this information through SSMC.
SELECT name, is_disabled FROM sys.indexes
where is_disabled = 1