Orion SQL Database Maintenance

Here is a more in depth defrag you can run from SQL Studio

DECLARE @CoreTable VARCHAR(255)

DECLARE CoreCursor

CURSOR FOR

SELECT table_name

FROM information_schema.tables

WHERE table_type = 'base table'

OPEN CoreCursor

FETCH NEXT

FROM CoreCursor INTO @CoreTable

WHILE @@FETCH_STATUS = 0

BEGIN

PRINT 'Reindexing Table:  ' + @CoreTable

DBCC DBREINDEX(@CoreTable, '', 80)

FETCH NEXT

FROM CoreCursor INTO @CoreTable

END

CLOSE CoreCursor

DEALLOCATE CoreCursor