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

This course teaches how to recognize and diagnose numerous types of SQL Server query performance problems.

  • +

    Course Syllabus

    Course Introduction
    - 1m 32s

    —Course Introduction 0m 51s
    —Course Structure 0m 41s
    Troubleshooting Inefficiency
    - 28m 38s

    —Module Introduction 0m 59s
    —Demo: One-Row-At-A-Time-Processing 3m 12s
    —Demo: The Forgotten Trigger 4m 5s
    —Demo: Scalar Function Inhibited Parallelism 2m 14s
    —Demo: Scalar Function Row by Row Execution 3m 17s
    —Demo: Too Few Rows Per Batch 3m 36s
    —Demo: Not Using TOP When You Can 2m 57s
    —Demo: Unnecessary Many-To-Many 4m 8s
    —Demo: Excessive Fragmentation and Scans 3m 47s
    —Module Summary 0m 18s
    Tuning OLTP vs. DSS Patterns
    - 47m 28s
    Advanced Query Tuning Patterns
    - 59m 47s

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