SQL Server Query Tuning Strategies



If you have a database driven application which reacts very slowly when the data increases, then you are right in this online training! You will learn, how you can tune SQL Server Queries with concrete Index Tuning Strategies. You will also see how SQL Server caches and reuses Execution Plans, and which terrible problems can occur in SQL Server based on this behaviour.

In this 6 hour long online training you will learn about:

  • Index Tuning
    • Search Arguments
    • Bookmark Lookups
    • Tipping Point
    • Index Intersection
    • Filtered Indexes
    • Indexed Views
  • Plan Caching
    • Plan Cache
    • Plan Caching
    • Parameter Sniffing