We're running RMS HQ 2.0.0113 on SQL Server 2k5. Each morning a maintenance plan is run on the HQ database that does (in order): a full backup, Check DB Integrity (includes indexes), Update Statistics (tables and views, All existing statistics, Full scan), Rebuild Indexes (tables and views, original amount of free space), and then sends an e-mails reporting success/failure.
Most Mondays, and occasionally in the middle of the week, though the staff has problems generating reports (i.e. Detail Sales for the day before). Sometimes the report will just be very slow (taking 10 min rather than 10 seconds), but often the reports will just time out.
Using the Reindex function in HQ Administrator cleans it up. Is there something different about the way HQ does a reindex as opposed to the Rebuild Index Task? If so, is there a way to automate it and include that in our morning maintenance?