Is it worthwhile to schedule optimisation job (update stats and rebuild index) on another server so it can be run on a database that was created on SQL Server 2005 Express from an application installation?
I know it is probably a good idea to atleast change the autogrowth setting from 1MB but what about the weekly database optimisation jobs?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!