Abstract: You have been working with SQL Server for a while now. You want to speed up the workload but you do not have the time to go deep into the internals and figure out the tricks yourself. In this 40-minute, demo-focused LIVE session, you will learn about three tuning techniques that will improve the execution time of your workloads. And guess what? You can apply them to production right away.

Modules

  • Technique 1: Stats Update (Cardinality Estimation)
  • Technique 2: Indexes (Speed up data retrieval and cause less IO)
  • Technique 3: Tweak the query (TSQL rewrite)