April 2009 - Posts
After all the theory about VSift in my previous blog posts now a tip about how to tune VSIFT. Before I continue first this. VSift is not a bad technology but the implementation in NAV has one big downside. The good old SIFT levels have disapeared. In older versions of NAV there was a SIFT Level property. This enabled you to decide which SIFT level best suited your implementation. Many people say: Disable all top levels. But I disagree on that. Measure the exact levels you need and only enable those...
With the introduction of VSIFT, a new perception was introduced. There are no more Zero SIFT records. More about VSift in http://dynamicsuser.net/blogs/mark_brummel/archive/2009/04/12/vsift-the-day-after.aspx With the classic SIFT it was possible to have SIFT records that did not contain any totals. These were called Zero SIft Records or Sift Zombies. They were easy to delete by optimising the Dynamics NAV tables but if you forget to do that regularly there could probably be thousands to millions...
This time another tip on how to use the SQL Management Studio. Dynamics NAV (Navision) keeps a copy of all tables on SQL server for each company you create, no matter if the table is populated or not. This way of creating tables can lead to a long list of tables in the SQL Management Studio. Expanding the table tree can even take minutes on heavy used systems. How to avoid that. Step 1. Go to the SQL Management Studio, connect to the server and expand the database you want to use Step 2, right click...
Some time ago a new technology for SIFT was introduced. SIFT is a technology that makes it possible in NAV to use the flowfields with the powerfull flowfilter technology. It stands for Sum Index Flow Techology. In the classic database the flowfield data was kept at index level. SQL does not have these capabilities so they had to work their way around it. As most of you know, the claccic way to do tis was with secondary tables which were updated though SQL triggers. These triggers where created and...
I know that this blogpost is far from orriginal but I am always looking for this information so I am putting it in my blog The table $ndo$dbproperty has a field DatabaseVersionNo. This is a list of recent versions. With special thanks to Dean McRae! / Database versions for: 2.50 // 1 : Beta 1 data formats // 2 : Beta 2 data formats (change in Code field value format from space-padded prefix to hex prefix) // 3 : Beta 3 data formats (change in Code field value format from hex prefix to no prefix or...
Last months I have been teaching a lot of NAV2009 upgrade workshops in The Netherlands, Belgium and the UK. One of the questions I am getting often is how to link a subpage to another subpage. In the UK workshop we started some experimenting. We found that when creating a subpage you get a field called provider ID in the properties. This field is used in factboxes to link a factbox to the subpages, for example Item statistics to a salesline. When you populate this field with the ID of the subpage...
Time for some tips about how to use the SQL Server Management Studio. This is a really great tool which should be more used by NAV DBA's. First tip is how to include column headers when copying query results. This is something we often use when analysing systems remotely. When opening the management studio goto - tools - options Then select - Query Results - SQL Server - Results to Grid And select "Include column headers when copying or saving the results". After this, the column headers...