2012-05-20T11:43:59Z Lukyn email@lukyn.cz Copyright 2012, Lukyn SPHPBLOG -- vypne všechny nonclustered indexy (SQL server 2005)
DECLARE @indexName VARCHAR(128)
DECLARE @tableName VARCHAR(128)

DECLARE [indexes] CURSOR FOR

SELECT [sysindexes].[name] AS [Index], [sysobjects].[name] AS [Table]--,*
FROM [sysindexes]
INNER JOIN [sysobjects] ON [sysindexes].[id] = [sysobjects].[id]

WHERE [sysindexes].[name] IS NOT NULL
AND [sysobjects].[type] = 'U'
AND indid<>1 -- není to PK (pk má vždy 1)
AND ([sysindexes].status & 64) = 0 -- vyloučit statistiky (pokud chci statistiky tak <>0)

OPEN [indexes]

FETCH NEXT FROM [indexes] INTO @indexName, @tableName

WHILE @@FETCH_STATUS = 0
BEGIN

exec ( 'ALTER INDEX [' + @indexName + '] ON [' + @tableName + '] DISABLE')
PRINT 'ALTER INDEX [' + @indexName + '] ON [' + @tableName + '] DISABLE'

FETCH NEXT FROM [indexes] INTO @indexName, @tableName
END

CLOSE [indexes]
DEALLOCATE [indexes]

--COMMIT TRAN
ROLLBACK TRAN]]> http://www.lukyn.cz/blog/index.php?entry=entry100204-082947 2010-02-04T00:00:00Z 2010-02-04T00:00:00Z Veřejné fotky na picasa webu ]]> http://www.lukyn.cz/blog/index.php?entry=entry090506-162754 2009-05-06T00:00:00Z 2009-05-06T00:00:00Z






]]> http://www.lukyn.cz/blog/index.php?entry=entry060924-222603 2006-09-24T00:00:00Z 2006-09-24T00:00:00Z ]]> http://www.lukyn.cz/blog/index.php?entry=entry051101-085932 2005-11-01T00:00:00Z 2005-11-01T00:00:00Z Jitřenka A
Jitřenka B ]]> http://www.lukyn.cz/blog/index.php?entry=entry050305-170100 2005-03-05T00:00:00Z 2005-03-05T00:00:00Z