Disable all non-clustered indexes
        Posted  
        
            by spender
        on Stack Overflow
        
        See other posts from Stack Overflow
        
            or by spender
        
        
        
        Published on 2010-03-25T17:58:01Z
        Indexed on 
            2010/03/25
            18:13 UTC
        
        
        Read the original article
        Hit count: 430
        
I select a number of non-clustered indexes from my database with the following:
SELECT  sys.objects.name tableName,
        sys.indexes.name indexName
FROM    sys.indexes
        JOIN sys.objects ON sys.indexes.object_id = sys.objects.object_id
WHERE   sys.indexes.type_desc = 'NONCLUSTERED'
        AND sys.objects.type_desc = 'USER_TABLE'
I'd like to run the following over each of the results:
ALTER INDEX indexName ON tableName DISABLE
How would I go about doing this? Is there a better way?
© Stack Overflow or respective owner