Tag Archives: SQL Index

Bygga om index i en SQL-DB

Så här bygger man om alla index i en SQL-databas. DECLARE @TableName varchar(255) DECLARE TableCursor CURSOR FOR SELECT table_name FROM information_schema.TABLES WHERE table_type = ‘base table’ OPEN TableCursor FETCH NEXT FROM TableCursor INTO @TableName WHILE @@FETCH_STATUS = 0 BEGIN DBCC … Continue reading

Posted in SQL Server | Tagged , | Comments Off on Bygga om index i en SQL-DB