Is SQL2000 more clever than SQL2005?

I have seen a number of (good) arguments that some issues with Dynamics NAV on SQL2005 are caused by a bad query optimizer in SQL2005, and that the SQL teams need to fix this. After all, some issues we see on SQL2005 did not exist in SQL2000. This blog tries to argue that SQL2005 is…

0

Index Hinting in Platform Update for Microsoft Dynamics NAV 4.0 SP3 KB940718

Introduction On SQL Server, you can use index hinting to force the server to use a particular index when executing queries for FINDFIRST, FINDLAST, FINDSET, FIND(‘-‘), FIND(‘+’), FIND(‘=’) and GET statements. Queries generated by the form runtime will be affected by index hints in the same way.   Index hinting can help avoid situations where…

0

KB articles for Microsoft Dynamics NAV 4.0 SP3 ERP Application

Since the release of Microsoft Dynamics NAV 4.0 SP3 we have released the following knowledgebase (KB) articles (PartnerSource Login credentials are required): 1.       KB940206 – Apply 2.       KB934132 – Bank Account 3.       KB924268 – Blanket Orders 4.       KB926349 – Blanket Orders 5.       KB932268 – BOM 6.       KB933009 – BOM 7.       KB939711 – Business Analytics 8.      …

0

KB articles for Microsoft Dynamics NAV 5.0 ERP Application

Since the release of Microsoft Dynamics NAV 5.0 we have released the following knowledgebase (KB) articles (PartnerSource Login credentials are required): 1.       KB938398 – XBRL 2.       KB937512 – Overdue Amounts (LCY) 3.       KB937722 – Accounting Period New Company 4.       KB936064 – Outlook Integration 5.       KB936535 – Web Links 6.       KB939253 – Bank Reconciliation 7.       KB938272…

1

Servicepacks & Platform Updates for Microsoft Dynamics NAV

Servicepacks & Platform Updates for Microsoft Dynamics NAV Microsoft Dynamics NAV sustained engineering team has released the following servicepacks and platform updates (PartnerSource Login is required): Microsoft Dynamics NAV 3.70 –          Microsoft Dynamics NAV 3.70.A (SP1) –          Microsoft Dynamics NAV 3.70.B (SP2) 1.       Platform Update for Microsoft Dynamics NAV 3.70.B KB890640 Microsoft Dynamics NAV 4.0 Releases: –          Microsoft…

0

How to search for a Microsoft Dynamics NAV hotfix kb article

On partnersource it is quite simple to search available hotfixes (if you know how!).   1. Visit https://mbs.microsoft.com/knowledgebase/search.aspx (PartnerSource login credentials are required) 2. Choose product “Microsoft Dynamics NAV” 3. Search for “kbqfe” 3. Choose a module or search them all   Limitations are 100 articles per search but to get the latest ones you can…

0