Recentemente eu criei um post mostrando Quando ativar e desativar índices no SQL Server. Solicitei que fosse feito uma documentação inclusive para identificar quais índices estão desativados na base de dados, porém não coloquei como encontrar os índices desativados.
Bem simples, vou colocar o script abaixo que já mostra quais são os índices desativados e quais tabelas eles pertencem.
SELECT sys.objects.name AS Tabela, sys.indexes.name AS Indice FROM sys.indexes inner join sys.objects ON sys.objects.object_id = sys.indexes.object_id WHERE sys.indexes.is_disabled = 1 ORDER BY sys.objects.name, sys.indexes.name
If you are a fan of online gambling, then you must have come across gry…
On the internet online casinos have transformed the betting industry, enabling players to vegas.hu online…
Casinos online offer free spins to draw new customers. These bonuses are usually very profitable,…
In recent times, online casino sites have actually obtained enormous appeal among gamers, providing a…
Bitcoin, the most preferred cryptocurrency worldwide, has reinvented lots of industries, including the on baixar…
Online slots have turned into one of one of the most preferred forms of home…
