Goodbye Nav_Developer, hello NAV Team-blog

To make things just a little bit simpler, some of the NAV blogs have now been combined into the NAV Team Blog. So from now on, that is where we will blog. All content from this blog has already been migrated to the NAV Team Blog. So this post will be the last post on…


How using SQLIndex property can affect which index NAV uses

The usual rule for specifying a key in NAV is, that it will chose the first key that matches all the fields specified by SETCURRENTKEY, RunformLink, etc. Example:Table 21 “Cust. Ledger Entry” has the following keys (not all of them listed):   – Entry No.  – Customer No.,Posting Date,Currency Code  – Customer No.,Open,Positive,Due Date,Currency Code  –…


Problems in transformation forms to pages using TransformationTools

After Microsoft Dynamics NAV 2009 SP1 release more and more developers start using it and trying to adopt existing solutions for new 3tier environment.Most workload comes from trying to adopt current forms to new object – pages.Particularly transformation could be done by using TransformationTools (http://msdn.microsoft.com/en-us/library/dd338789.aspx), however it is not “best ever” and partners reporting problems and require to…

1

Table Information including Index information (Usage, Blocks and Reads)

  The query below combines these three queries into one:Index Usage QueryRecent Bocking HistoryTable Information Query   It can be used to just see the number of records in each table. But also by just changing “ORDER BY”, it can be used to see which index cause most blocking / wait time / updates or…


Troubleshooting multi-machine installations of NAV 2009

The NAV 2009 documentation walkthroughs provide step-by-step instructions for installing NAV 2009 on 2 or 3 machines. However, we have found that some of the same configuration issues come up time after time after installation. When on calls with partners and customers, it seemed to me that this information was spread out all over the place, so…

3

Translate this site using Windows Live Translator

A new translator service is now available for all whose browser is set to one of the following languages: English, German, French, Italian, Spanish, Portuguese, Netherlands Dutch, Russian, Chinese Simplified, Chinese Traditional, Japanese, Korean, Arabic. To use it: Scroll down, and on the right hand side of this page, select your language under “Translate this site…


Index Usage Information Tool

Attached at the end of this post is a set of NAV objects that collects index usage information, and displays it in a NAV client so that you can sort tables by no. of Indexes / Index Reads / (Index) Block wait time, etc.:   The tool is using these three SQL Queries / DMVs:…


Converting company names for NAV Web Services

A few weeks ago I saw an up tick in the number of cases having problems accessing exposed web service. Some of the problem has been because the “CRONUS USA, Inc.” company name converts to an unfamiliar “CROUNS_USA_x002C__Inc”. This will be changing in NAV 2009 SP1, but until that time it would be helpful to…

0

How to read a SQL Profiler trace file into a SQL table

Just a small tip that I use often when I have a large SQL Profiler trace. Rather than reading through trace files line by line, you can read it into a table and then query it. This syntax creates a new table in SQL Server and loads your trace file into it: SELECT * INTO…