Optimize SQL 2005 databases on a schedule
How can I optimize my SQL 2005 databases on a schedule?
Software/Hardware used:
Software/Hardware used:
ASKED:
June 28, 2011 6:21 PM
UPDATED:
June 28, 2011 10:06 PM
Answer Wiki:
Define optimize. Do you want to rebuild the indexes? If so than either use a maintenance plan and schedule it, or grab one of the many tools to help you do this (some are free, some aren't) and schedule them to run from a SQL Agent job.
If you are talking about adding indexes, changing the schema of the tables, etc. you'll have to do that manually (or at least you should).
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
