Author Archive | Lars Westman

Binary Conversion

Here’s a piece of code if you want to convert to binary using C/AL Int2Bin(InStr : Text[50]) BinStr : Text[50] WHILE Quotient > 0 DO BEGIN i += 1; IF i MOD 8 = 1 THEN BinStr := PADSTR(”, 8, ’0’) + BinStr; //Insert 8 zeros for each new byte Remainder := Quotient MOD 2; […]

Continue Reading 0

Upgrade NAV-runtime and enable Style Sheets

Lately there has been many upgrades of NAV-runtime since customers are upgrading their PC:s to Windows 7. There’s usually no big deal to upgrade only the run-time enviroment but keep in mind that it’s not supported by Microsoft if You should run into problems, so do Your testing before doing it on a production database. […]

Continue Reading 0

Disable Parameter Sniffing in SQL2008

Microsoft has released Cumulative Update Package 7 for SQL2008 SP1 (KB797065). In this update there is a new feature (trace flag 4136) that let us control wether or not the Query Optimizer should do parameter sniffing (KB980653). You may remember all the debates on the forums about index hinting and parameter sniffing in NAV 4.0 […]

Continue Reading 0

Move Your non-clustered indexes

When You create a NAV-database You end up with tables, clustered indexes and non-clustered indexes in the same filegroup. That’s not optimal from a performance perspective. You can gain performance by separating the actual data (tables/clustered indexes) from Your non-clustered indexes by moving these to a separate filegroup and a separate array of disks. If […]

Continue Reading 0

Missing indexes

Index tuning in Dynamics NAV is often done by analyzing indexes and how they are used. There’s a nice tool from the MS NAV Team that You can run from inside NAV to analyze You existing indexes. But what if You are missing indexes and are facing read problems rather than problems write performance? Could I […]

Continue Reading 0

Key Groups

One important area in performance tuning is the setup of keys and indexes. A key in NAV is by default maintaned as an index in SQL Server Index Tuning Indexes help the user to get data out of the database fast, but needs to be updated as soon as data is changed which cost performance. […]

Continue Reading 0

Installing NAS on Windows 2008

User Account Control in Windows 2008 surely has it’s benefits. But it really has some down sides also. When You install the Application Server (NAS) on a w2k8 logged in as a user which is local admin (but not logged in as administrator) everything looks just just fine. The install finishes with no errors. The […]

Continue Reading 0