Microsoft SQL Server Optimization for Microsoft Dynamics NAV

Marcin Woch

Abstract


This article presents some methods of SQL Server 2000 or SQL Server 2005 for Microsoft Dynamics NAV optimization. It focuses on database design, programming standards and a hardware configuration.

Keywords


optimization; SQL 2000; SQL 2005; Microsoft Dynamic NAV; server

Full Text:

PDF

References


Microsoft Business Solutions Navision 4.0 Course: 8404B Installation and Configuration Training. Microsoft Corporation, 2004.

Dupont-Roc P., Gatchalian R., Serrano D.: Microsoft Dynamics NAV 4.0 Hardware Guide. 2006.

Muhlbaher H.: Optimizing Dynamics NAV on SQL Server - Application. 2007.

Muhlbaher H.: Optimizing Dynamics NAV on SQL Server - Infrastracture. 2007.

Raheem M., Sonkin D., D'Hers T., LeMonds K.: Inside SQL Server 2005 Tools. Addison Wesley Professional, Boston 2006.

Woody B.: Administrator's Guide to SQL Server 2005. Addison Wesley Professional, Boston 2006.

Rankins R., Jensen P., Bertucci P.: Microsoft SQL Server 2000. Księga eksperta. Helion, Gliwice 2003.

Bieniek D., Dyess R., Hotek M., Loria J., Machanie A., Soto A., Wiernik A.: Microsoft SQL Server 2005 Implementation and Maintenance, Self Paced Training Kit. MSPress, Redmont 2006.

Nielsen P.: SQL Server 2005 Bibie. Wiley Publishing, Inc, Indianapolis 2007.

Thomas O., McLean I.: Optimizing and Maintaining A Database Administration Solution by Using Microsoft SQL Server 2005. Microsoft Press, Redmont 2006

Microsoft Dynamic NAV 5.00 Applications Designer’s Guide. Microsoft Corporation, Radmont 2007




DOI: http://dx.doi.org/10.21936/si2007_v28.n2.553