MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

SQL Server: Common Query Tuning Problems and Solutions - Part 2

Course Summary

There are a wide variety of common performance problems that you will encounter when query tuning. Part 2 of this two-part course begins by covering common problems arising from writing and using inefficient Transact-SQL code. You'll then learn about quer

  • +

    Course Syllabus

    ● Course Introduction
        ◦ Course Introduction
        ◦ Course Structure
    ● Troubleshooting Inefficiency
        ◦ Module Introduction
        ◦ Demo: One-Row-At-A-Time-Processing
        ◦ Demo: The Forgotten Trigger
        ◦ Demo: Scalar Function Inhibited Parallelism
        ◦ Demo: Scalar Function Row by Row Execution
        ◦ Demo: Too Few Rows Per Batch
        ◦ Demo: Not Using TOP When You Can
        ◦ Demo: Unnecessary Many-To-Many
        ◦ Demo: Excessive Fragmentation and Scans
        ◦ Module Summary
    ● Tuning OLTP vs. DSS Patterns
        ◦ Module Introduction
        ◦ Defining OLTP and DSS
        ◦ OLTP Characteristics
        ◦ Demo: Stop-And-Go Operators
        ◦ Demo: Finding Timeout-Prone Queries
        ◦ Demo: Over-Indexing
        ◦ Demo: OLTP and Parallelism
        ◦ Demo: OLTP and Deep Trees
        ◦ DSS Characteristics
        ◦ Demo: Expanding the AdventureWorksDW2012 Database
        ◦ Demo: Unwanted Serial Plans
        ◦ Demo: Gatekeeper Row Issue - Part 1
        ◦ Demo: Gatekeeper Row Issue - Part 2
        ◦ Demo: Gatekeeper Row Issue - Part 3
        ◦ Demo: Aggregation Queries and Columnstore Index Opportunities
        ◦ Demo: Distinct Aggregation Issue
        ◦ Module Summary
    ● Advanced Query Tuning Patterns
        ◦ Module Introduction
        ◦ Demo: New-Feature Abuse
        ◦ Demo: Recursive CTE Estimate Skews
        ◦ Demo: Seeks, Scans, Predicates, and Filters - Part 1
        ◦ Demo: Seeks, Scans, Predicates, and Filters - Part 2
        ◦ Demo: Seeks, Scans, Predicates, and Filters - Part 3
        ◦ Demo: Unmatched Indexes
        ◦ Demo: Disused Filtered Statistics
        ◦ Demo: Interpreting RetrievedFromCache
        ◦ Demo: Amplification and Distinct Value Counts
        ◦ Demo: Join Hints and Forced Order
        ◦ Demo: CTEs vs. Derived Tables
        ◦ Demo: One Procedure With Multiple Optional Input Parameters
        ◦ Demo: Procedure Sub-Branching
        ◦ Demo: Verifying Instance Workload Complexity
        ◦ Module Summary
        ◦ Course Summary


Course Fee:
USD 29

Course Type:


Course Status:



1 - 4 hours / week

This course is listed under Development & Implementations , Data & Information Management and E-Commerce Community

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top