USE Keyhouse --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
 
DBCC DBREINDEX('diary',' ',50)
DBCC DBREINDEX('diarydelegations',' ',50)
DBCC DBREINDEX('diaryAttachments',' ',50)