Monthly Archives: January 2014

NAV2013R2 | Maintain SIFT Index


As I already explained in my last blog post the way performance tuning is done in NAV2013R2 has changed from previous versions. Rather than issueing a SQL Statement for each flowfield in each row on a listpage NAV now uses OUTER … Continue reading

Posted in General, Performance, Keys, Indexes, SQL Server | 3 Comments

NAV2013R2 | SQL Integer Issues


It’s been a while since I had time to blog, and still I do not really have the luxury of time but there are at least two things important enough to share. At the moment I am involved in a … Continue reading

Posted in General, Performance, Keys, Indexes, SQL Server | 3 Comments