Development

BC/NAV

Breakout Sessions

DEV08 - Supercharge your NAV/BC SQL queries

BCUG/NAVUG Presenter(s)

• 

  Adam Jacobson

  President
  Red Three Consulting

You get basic SQL. Your reports tie out and your users like your results. But sometimes, things don’t run as quickly as expected. Or you make a change to stored procedure and your query goes from instantaneous to minutes. In this session, we’ll review some basic query tuning techniques and how you can use them to get your queries in top shape. Topics will include specific SQL issues like SARGAbility, Temp Tables and Date Tables as well as general approaches to query development in relation to various reporting and BI tools.