I consider scheduling a SQL Server job that reorganizes all tables nightly. We don't have enterprise, so we cannot rebuild online (this means we need to reorganize). We also don't want to invest too much time in fragmentation and space maintenance so we are seeking a solution that can be implemented quickly and does not require further time investments in the future.
Testing on a restored production backup showed that reorganize is almost as good as rebuild for reducing fragmentation and regaining space.
Is this a reasonable idea? Does this scheme create problems for availability or maintainability? Is this a reasonable long-term solution?