While struggling with NAV/SQL performance issues for many years I scribbled down countless pages about various issues, learned by own experience or from colleagues, taken from numerous knowledgebase articles, whitepapers, etc. or heard in several webcasts. In 2006 I started to put all this into a structured...
Ho, ho, ho … well, X-Mas is coming soon, time to make a wish-list! In my special case I would like to ask for several things making life with NAV and SQL easier. I'm not asking for "science fiction" features like " non-blocking posting routines " or " different code versions...
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...
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...