In some companies it’s almost impossible to make a full index rebuild, because they have only a few hours of maintenance windows You can adapt this script to rebuild a specific number of indexes during each day, during a specific hours. If you have several companies in a database you can even adapt it to rebuild each company at a specific hour of day. This scripts only runs in SQL Server 2005. This script isn’t complete you have to adapt it to your current company and define fragmentation values...
This will be the first in a series of three posts. The objective is to give a general overview of using EDI with Navision and Commerce Gateway (CG) 1 –Commerce Gateway workflow 2 –Customize Commerce Gateway 3 – Using Biztalk To use EDI with Navision isn’t necessary to use Commerce Gateway or either BizTalk. There are add-ons that replace Commerce Gateway and BizTalk functionalities. BizTalk without Commerce Gateway Users that don’t feel comfortable with commerce Gateway can use other means to achieve...