I have found an informative article that shows how to enable and disable indexes in SQL Server using SQL Server Management Studio and Transact-SQL hope this will help you out, see from here: http://www.sqlserverlogexplorer.com/enable-and-disable-indexes/