October 2007 - Posts

MS Dynamics NAV 5.0 Service Pack 1

Well, at Convergence 2007 in Copenhagen it was announced (Session: NAV Keynotes) that in Q1 2008 the SP1 for NAV 5.00 would be released (dates are subject to change, of course). During the "Meet the Experts" session little more information about the SP's content was published. As we had no chance to really looking into the technical details, this post is more guessing than knowing. Here is what I considered most important: SIFT Tables will be replaced by Indexed Views "Buffered...

Included Columns vs. SIFT Tables

Base on David's "hint, hint ) I made my promise come true and copied this from a current thread: SIFT tables include aggregated information of e.g. "Ledger Entry" tables to display these values in FlowFields. The aggregation is done via SQL Server site triggers which are programmed really poor and performing bad (I skip some details here). Hence, it is necessary to minimize the number of SIFT indexes and bucktes to get the optimal balance between reading and writing performance...

Welcome to Jörg's Blog: Dynamics NAV Performance on SQL - My Two Cents

Here we go! So, this is my very first BLOG! I don't know why .... I have been writing postings in hundreds of forum threads, but never dared to put it a BLOG ... hmmm, feels somewhat "different" than answering or asking questions ... Most of you might know me for years, knowing that I'm focusing on NAV/SQL Performance issues and everything related. This BLOG should be the attempt to "concentrate" my statements - My Two Cents - so I guess I will primarily Copy & Paste...