I know it's a little late to write my last post from Convergence 2008 EMEA in Copenhagen, but I have been thinking a lot about what I should write. So this post is not really about Convergence, just inspired by the last day. Of cause with the announcement of Microsoft Dynamics NAV 2009 most of the...
This post describes one scenario in which this error occurs. There may be others. In the late 4.0 versions of the NAV executables, all tables in NAV had a clustered index created on SQL for the primary key (Index 0). However, the table objects in 4.0 versions did not have the Clustered property set on...
Well, a current discussion is whether to go for NAV 5.0 Service Pack 1 or not. On the one hand, NAV 5.0 SP1 has lots of improvements regarding SQL performance (Indexed Views, Buffered Inserts, etc.), on the other hand there are other issues and problems (slow FlowFields, lacking SQL 2000 capability,...
Upgrading Dynamics NAV (database upgrade) is a timely task, but the time to upgrade (transfer data) can be somewhat reduced on sql option by taking few simple steps. Due to large transaction volume and amount of indexes and sifts, transfering data (running upgrade toolkit codeunits: step 1 and 2 ) can...