SQL script to reindex all tables in your tables

reindex-all-indexes.sql

DECLARE @TableName nvarchar(255)
DECLARE TableCursor CURSOR FOR
SELECT table_name FROM information_schema.tables
WHERE table_type = 'base table' And TABLE_SCHEMA = 'dbo'
OPEN TableCursor

FETCH NEXT FROM TableCursor INTO @TableName
WHILE @@FETCH_STATUS = 0
BEGIN
   PRINT CONCAT('Reindexing: ',@TableName,'...')
   DBCC DBREINDEX (@TableName,' ',0) WITH NO_INFOMSGS
   FETCH NEXT FROM TableCursor INTO @TableName
END
CLOSE TableCursor
DEALLOCATE TableCursor
GO