SQLpassion Online Training about Intelligent Query Processing

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.)

It’s now a week ago, since Microsoft has finally released SQL Server 2019. Therefore, I’m running on December 9, 2019 an online training about Intelligent Query Processing in SQL Server 2017/2019.

The Intelligent Query Processing feature family includes new functionalities that improve the performance of existing OLTP/OLAP workloads with almost no query rewrites. During this one-day long online training we will cover the following new features in SQL Server 2017/2019:

  • Intelligent Query Processing in SQL Server 2017
    • Adaptive Joins
    • Interleaved Query Execution
    • Memory Grant Feedback
    • Lightweight Query Profiling Infrastructure
  • Intelligent Query Processing in SQL Server 2019
    • Deferred Compilation of Table Variables
    • Batch Mode on Row Store Indexes
    • Approximate Count Distinct
    • Scalar UDF Inlining

Please check-out this link for more details about the training (detailed agenda, dates, pricing) and how to sign-up.

Thanks for your time,

-Klaus

It`s your turn

Your email address will not be published. Required fields are marked *

SQLpassion

Copyright © 2018 by SQLpassion e.U. · Imprint · Offerings · Academy · Contact · Data Protection · Go to Top