Tag Archives: optimization

Rebuild Index using Query in MS-Sqlserver

In MS-Sqlserver by using below query to rebuild index of the tables. DECLARE @TableName varchar(255) DECLARE @TableSchema varchar(100) DECLARE TableCursor CURSOR FOR SELECT TABLE_SCHEMA,TABLE_NAME¬† FROM information_schema.tables WHERE table_type = ‘base table‘ OPEN TableCursor FETCH NEXT FROM TableCursor INTO @TableSchema,¬† @TableName … Continue reading

Posted in Articles | Tagged , , | Leave a comment