The Microsoft Dynamics GP Product Management and Marketing team has published some performance stats that are good enough reasons to upgrade to Microsoft SQL Server 2008 if you are a Microsoft Dynamics GP customer running SQL Server 2005 or even SQL Server 2000. Their stats revolve around the use of SQL Server 2008’s row compression and page compression features and their ability to save a good amount of storage space.
Don’t forget that the vardecimal storage format, the predecesor of row compression and page compression, was made available in Microsoft SQL Server 2005 SP2 and can be enabled to save data storage once you understand all its capabilities. For more information on vardecimal storage format check the following article:
- Microsoft Technet: Reducing Database Size by Using Vardecimal Storage Format
For more information on Microsoft SQL Server 2008 row compression and page compression features visit the following articles:
- Microsoft Technet: Creating Compressed Tables and Indexes
- Microsoft SQL Server Storage Engine team: Types of Data Compression in SQL Server 2008
Please remember that Microsoft SQL Server 2008 is only supported if you are running Microsoft Dynamics GP v10 with Service Pack 2 (Build Number: 10.00.1061) or later. For information on Microsoft SQL Server versions and service packs, check my previous article here.
Until next post!
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC