LabLynx KB:Rebuild indexes on a SQL server database

The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

This is an article specific to the Category:LabLynx knowledge base. Its context outside of LabLynx, Inc may not be apparent, thus why it appears inside the LabLynx KB namespace.

How to rebuild indexes on a SQL server database

This linked article explains the following script: Tips for Rebuilding Indexes

Here is the script to rebuild all of the indexes on all the tables in a SQL server database:

          USE DatabaseName --Enter the name of the database you want to reindex
          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 DBREINDEX(@TableName,' ',90)
          FETCH NEXT FROM TableCursor INTO @TableName
          END
          CLOSE TableCursor
          DEALLOCATE TableCursor