Microsoft Dynamics NAV Database Optimization StepsMAINTENANCE PLANUse SQL Server "Maintenance Plans" to manage NAV database optimization- Create a plan to degrafment indexes (ex. every night) > Microsoft Scriptlook at my blog "MSDN Microsoft Script"blogs.dotnethell.it/.../Defragment-All-Indexes-In-A-Database-Microsoft-Script__16778.aspx- After recalculate statistics- Create a plan to rebuild the indexes at least once a week (if you have time also each night instead of degrament) - Rebuilding  
Leggi tutto il post...