Browse by Tags

• 5.0 sp1
• Book
• downgrade
• Index
• indexed view
• NAV
• nav 5.0
• SIFT
• SP1
• SQL
• sql server
• upgrade
• view
• vsift

• The NAV/SQL Performance Field Guide - 3rd Edition

  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... Posted Oct 04 2008, 10:00 AM by Jörg A. Stryk with | with 5 comment(s) Filed under: SQL, Performance, Book

• Downgrading NAV

  Well, a current discussion is whether to go for NAV 5.0 Service Pack 1 or not. On the one hand, NAV 5.0 SP1 has lots of improvements regarding SQL performance (Indexed Views, Buffered Inserts, etc.), on the other hand there are other issues and problems (slow FlowFields, lacking SQL 2000 capability,... Posted Jun 05 2008, 08:59 AM by Jörg A. Stryk with | with 11 comment(s) Filed under: Performance, SIFT, NAV, vsift, sql server, 5.0 sp1, upgrade, downgrade

• NAV/SQL Troubleshooter’s Wish-List

  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... Posted Nov 19 2007, 09:06 PM by Jörg A. Stryk with | with 18 comment(s) Filed under: SQL, Performance, NAV

• 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... Posted Oct 30 2007, 10:45 AM by Jörg A. Stryk with | with 5 comment(s) Filed under: SQL, Performance, Index, view, SP1, nav 5.0, indexed view

• 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... Posted Oct 28 2007, 11:29 AM by Jörg A. Stryk with | with 10 comment(s) Filed under: SQL, Performance, Index, SIFT