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 1

### Course Summary

There are a wide variety of common performance problems that you will encounter when query tuning. Part 1 of this two-part course begins by showing how to validate query execution assumptions around statistics and cardinality in order to ensure you're tro

• +

### Course Syllabus

 ● Course Introduction ◦ Course Introduction ◦ Course Scope ◦ Course Structure ● Validating Assumptions ◦ Module Introduction ◦ Downstream Impact of Bad Assumptions ◦ Cardinality Estimation and Predicates ◦ Selectivity ◦ Query Cardinality Questions ◦ Cardinality Estimate Inputs ◦ Statistics ◦ Demo: DBCC SHOW_STATISTICS STAT_HEADER ◦ Demo: DBCC SHOW_STATISTICS DENSITY_VECTOR ◦ Demo: DBCC SHOW_STATISTICS HISTOGRAM ◦ Demo: Histogram Direct Step Hit ◦ Demo: Scaling the Estimate ◦ Demo: Histogram Intra-Step Hit ◦ Demo: Density Vector With an Unknown Runtime Value ◦ Demo: Parameter Sniffed Value Estimation ◦ Demo: Distinct Value Estimation ◦ Impact to Query Execution and Performance ◦ Identifying Bad Assumptions - 1 ◦ Demo: Viewing Estimated Vs. Actual Row Counts ◦ Identifying Bad Assumptions - 2 ◦ Demo: sys.dm_exec_query_profiles ◦ Demo: Root-level Skews via sys.dm_exec_query_stats ◦ What Variance is Problematic? ◦ Module Summary ● Troubleshooting Bad Assumptions ◦ Module Introduction ◦ Model Assumptions ◦ Demo: Jagged Distributions ◦ Demo: Correlated Predicates ◦ Demo: Correlated Predicates in SQL Server 2014 ◦ Demo: Correlated Join Predicates, Independent Filter Predicates ◦ Demo: Searching for Off-Histogram Values ◦ Demo: Searching for Off-Histogram Values in SQL Server 2014 ◦ Troubleshooting Questions - 1 ◦ Demo: Missing Statistics ◦ Demo: Selectivity Guesses ◦ Demo: Stale Statistics ◦ Demo: Inadequate Sampling ◦ Demo: Parameter Sensitivity ◦ Demo: Table Variable Usage ◦ Demo: MSTVF Usage - Part 1 ◦ Demo: MSTVF Usage - Part 2 ◦ Demo: MSTVF Usage - Part 3 ◦ Troubleshooting Questions - 2 ◦ Demo: Data Type Conversions ◦ Demo: Buried Predicates - Part 1 ◦ Demo: Buried Predicates - Part 2 ◦ Module Summary ● Tuning Imprecision Problems ◦ Module Introduction ◦ Demo: SELECT * ◦ Demo: Unnecessary Sorts ◦ Demo: Needless DISTINCT ◦ Demo: UNION Vs. UNION ALL ◦ Demo: Leading Wildcards ◦ Demo: Hidden Cartesian Products ◦ Demo: Data Type Conversion Issues ◦ Demo: Redundant Logic and Overlapping Object References ◦ Module and Course Summary

Course Fee:
USD 29

Self-Study

### Course Status:

Active

1 - 4 hours / week

This course is listed under Development & Implementations and Data & Information Management Community

Related Posts: