Execute the following Microsoft SQL Server Transact-SQL (T-SQL) script in Management Studio (SSMS) Query Editor, SQLCMD or other client software to disable an index, check its status, enable an index and check the status again:

USE AdventureWorks;

ALTER INDEX [IX_SalesOrderHeader_CustomerID] ON Sales.SalesOrderHeader DISABLE
GO
select * from sys.sysindexes where name='IX_SalesOrderHeader_CustomerID'
GO
ALTER INDEX [IX_SalesOrderHeader_CustomerID] ON Sales.SalesOrderHeader REBUILD
GO
select * from sys.sysindexes where name='IX_SalesOrderHeader_CustomerID'
GO