Disable Indexes with SQL

Disable Indexes with SQL

Sometimes you will need to disable an index, albeit temporarily. In order to disable an Index, make use of the following T-SQL Query:

USE DatabaseNameGO ALTER INDEX NameOfIndex ON Table.Field DISABLE GO SELECT NAME AS [IndexName], TYPE_DESC AS [IndexType], CASE IS_DISABLED  WHEN 0 THEN 'Enabled' ELSE 'Disabled'  END AS [IndexInfo],  FILL_FACTOR AS [FillFactor] FROM SYS.INDEXES WHERE OBJECT_ID = OBJECT_ID('Table.Field') ORDER BY IndexName, IndexInfoGO
Share the Post:
data observability

Data Observability Explained

Data is the lifeblood of any successful business, as it is the driving force behind critical decision-making, insight generation, and strategic development. However, due to its intricate nature, ensuring the

Heading photo, Metadata.

What is Metadata?

What is metadata? Well, It’s an odd concept to wrap your head around. Metadata is essentially the secondary layer of data that tracks details about the “regular” data. The regular