The DynamicsBlogger gives us a great example of how dangerous SQL maintenance can be in his new post: SQL Maintenance blooper.
SQL Maintenance Blooper
Archived post from 2009. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.