1 -Course Overview (4.88 MB)
2 -Utilizing Expert Tools for Advanced Query Solutions (8.17 MB)
3 -Refactoring Complex Queries for Efficiency (6.21 MB)
4 -Demo Analyzing Execution Plans (10.88 MB)
5 -Demo Refactoring Complex Queries for Efficiency (7.58 MB)
6 -Demo SQL Query Optimization SARGable vs Non-SARGable (7.19 MB)
10 -Demo Query Performance and Server Configurations (12.6 MB)
11 -Flow Chart Conducting a Comprehensive Optimization Project (4.61 MB)
7 -Managing Indexes Effectively in SQL Server (4.38 MB)
8 -Demo Resolving Database Lock with Indexes (10.03 MB)
9 -Handling Performance Issues in Large-Scale Data (3.19 MB)
1 -Course Overview (7.99 MB)
2 -Interpreting Results from Query Tuning Assistant (3.3 MB)
3 -Demo Interpreting Query Tuning Assistant results (20.99 MB)
4 -Reading Execution Plans (2.76 MB)
5 -Demo Reading Execution Plans in Query Store Reports (24.89 MB)
6 -Improving Performance (5.97 MB)
7 -Demo Improving Performance with Missing Index Feature (17.47 MB)
8 -Adaptive Intelligence Query Processing (3.08 MB)
10 -Demo WHERE Clause Changes for Improved Performance (29.32 MB)
11 -Query Store and Wait Resources (3.12 MB)
12 -Demo Query Store Wait Resource (16.45 MB)
13 -Maintenance Plans (2.92 MB)
14 -Demo Maintenance Plans (10.57 MB)
15 -Improve Performance (2.19 MB)
16 -Demo Add Index and Query Index Usage (14.63 MB)
17 -Project Plans (5.91 MB)
9 -WHERE Clause Conditions Affecting Performance (3.2 MB)
1 -Course Overview (6.78 MB)
2 -Query Execution Steps (13.35 MB)
3 -Query Plans Explained (8.81 MB)
4 -Demo Query Plans Explained (5.17 MB)
5 -What Is SQL Server QTA (4.2 MB)
6 -Set up and Execute QTA (5.34 MB)
7 -Demo Set up and Execute QTA (2.92 MB)
10 -Demo Analyze Results of QTA Project (5.55 MB)
11 -Identify Query Plan Improvements (2.49 MB)
12 -Demo Identify Query Plan Improvements (3.22 MB)
13 -Interpret and Apply Best Practices (2.41 MB)
14 -Optimize a Query (2.29 MB)
15 -Demo Optimize a Query (5.79 MB)
16 -Summary (1.9 MB)
8 -Overview (2.67 MB)
9 -Analyze Results of QTA Project (2.24 MB)
1 -Course Overview (5.14 MB)
2 -Introducing SQL Server Query Tuning (7.78 MB)
3 -Demo Utilizing Query Tuning Tools (18 MB)
4 -Demo Understanding Query Behavior in Real-world Applications (10.54 MB)
5 -Comparing and Contrasting OLTP versus OLAP Systems (6.57 MB)
6 -Demo Implementing Performance Enhancements Across Environments (18.25 MB)
7 -Demo Analyzing, Optimizing, and Troubleshooting Complex Queries (9.94 MB)
8 -Demo Executing a Real-world Query Optimization (12.88 MB)
9 -Applying Best Practices in Query Tuning (7.03 MB)