D365 Business Central/NAV
Presentation Type: Presentation
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.