Tag Archives: Rebuild Index

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

To know which Tables need rebuild index in MSSQL

Some times we need to rebuild the index of the tables in MS-Sql database .In those case we consider the which tables real need the rebuild of the index.As per my knowledge below query is help to know which tables … Continue reading

Posted in Articles | Tagged , , , | Leave a comment