{"id":1190,"date":"2014-07-07T18:37:53","date_gmt":"2014-07-08T01:37:53","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/joe\/?p=1190"},"modified":"2014-07-07T18:39:27","modified_gmt":"2014-07-08T01:39:27","slug":"new-course-sql-server-common-query-tuning-problems-solutions-part-1","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/joe\/new-course-sql-server-common-query-tuning-problems-solutions-part-1\/","title":{"rendered":"New Course: &#8220;SQL Server: Common Query Tuning Problems and Solutions &#8211; Part 1&#8221;"},"content":{"rendered":"<p>Pluralsight published my latest course, &#8220;<a title=\"SQL Server Common Query Tuning Problems and Solutions\" href=\"http:\/\/pluralsight.com\/training\/Courses\/TableOfContents\/sql-server-common-query-tuning-problems-solutions\" target=\"_blank\">SQL Server: Common Query Tuning Problems and Solutions &#8211; Part 1<\/a>&#8220;. \u00a0Part 1 is 2 hours and 31 minutes and covers the following:<\/p>\n<p><strong>Module: Validating Assumptions<\/strong><\/p>\n<ul>\n<li>Downstream Impact of Bad Assumptions<\/li>\n<li>Cardinality Estimation and Predicates<\/li>\n<li>Selectivity<\/li>\n<li>Query Cardinality Questions<\/li>\n<li>Cardinality Estimate Inputs<\/li>\n<li>Statistics<\/li>\n<li>Demo: DBCC SHOW_STATISTICS STAT_HEADER<\/li>\n<li>Demo: DBCC SHOW_STATISTICS DENSITY_VECTOR<\/li>\n<li>Demo: DBCC SHOW_STATISTICS HISTOGRAM<\/li>\n<li>Demo: Histogram Direct Step Hit<\/li>\n<li>Demo: Scaling the Estimate<\/li>\n<li>Demo: Histogram Intra-Step Hit<\/li>\n<li>Demo: Density Vector With an Unknown Runtime Value<\/li>\n<li>Demo: Parameter Sniffed Value Estimation<\/li>\n<li>Demo: Distinct Value Estimation<\/li>\n<li>Impact to Query Execution and Performance<\/li>\n<li>Identifying Bad Assumptions<\/li>\n<li>Demo: Viewing Estimated Vs. Actual Row Counts<\/li>\n<li>Demo: sys.dm_exec_query_profiles<\/li>\n<li>Demo: Root-level Skews via sys.dm_exec_query_stats<\/li>\n<li>What Variance is Problematic?<\/li>\n<\/ul>\n<p><strong>Module: Troubleshooting Bad Assumptions<\/strong><\/p>\n<ul>\n<li>Model Assumptions<\/li>\n<li>Demo: Jagged Distributions<\/li>\n<li>Demo: Correlated Predicates<\/li>\n<li>Demo: Correlated Predicates in SQL Server 2014<\/li>\n<li>Demo: Correlated Join Predicates, Independent Filter Predicates<\/li>\n<li>Demo: Searching for Off-Histogram Values<\/li>\n<li>Demo: Searching for Off-Histogram Values in SQL Server 2014<\/li>\n<li>Troubleshooting Questions<\/li>\n<li>Demo: Missing Statistics<\/li>\n<li>Demo: Selectivity Guesses<\/li>\n<li>Demo: Stale Statistics<\/li>\n<li>Demo: Inadequate Sampling<\/li>\n<li>Demo: Parameter Sensitivity<\/li>\n<li>Demo: Table Variable Usage<\/li>\n<li>Demo: MSTVF Usage &#8211; Part<\/li>\n<li>Demo: Data Type Conversions<\/li>\n<li>Demo: Buried Predicates<\/li>\n<\/ul>\n<p><strong>Module: Tuning Imprecision Problems<\/strong><\/p>\n<ul>\n<li>Demo: SELECT *<\/li>\n<li>Demo: Unnecessary Sorts<\/li>\n<li>Demo: Needless DISTINCT<\/li>\n<li>Demo: UNION Vs. UNION ALL<\/li>\n<li>Demo: Leading Wildcards<\/li>\n<li>Demo: Hidden Cartesian Products<\/li>\n<li>Demo: Data Type Conversion Issues<\/li>\n<li>Demo: Redundant Logic and Overlapping Object References<\/li>\n<\/ul>\n<p>And part 2 will be published soon!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Pluralsight published my latest course, &#8220;SQL Server: Common Query Tuning Problems and Solutions &#8211; Part 1&#8220;. \u00a0Part 1 is 2 hours and 31 minutes and covers the following: Module: Validating Assumptions 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 [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[38],"tags":[],"class_list":["post-1190","post","type-post","status-publish","format-standard","hentry","category-sql-server-training"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.9.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>New Course: &quot;SQL Server: Common Query Tuning Problems and Solutions - Part 1&quot; - Joe Sack<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.sqlskills.com\/blogs\/joe\/new-course-sql-server-common-query-tuning-problems-solutions-part-1\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"New Course: &quot;SQL Server: Common Query Tuning Problems and Solutions - Part 1&quot; - Joe Sack\" \/>\n<meta property=\"og:description\" content=\"Pluralsight published my latest course, &#8220;SQL Server: Common Query Tuning Problems and Solutions &#8211; Part 1&#8220;. \u00a0Part 1 is 2 hours and 31 minutes and covers the following: Module: Validating Assumptions 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 [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/joe\/new-course-sql-server-common-query-tuning-problems-solutions-part-1\/\" \/>\n<meta property=\"og:site_name\" content=\"Joe Sack\" \/>\n<meta property=\"article:published_time\" content=\"2014-07-08T01:37:53+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2014-07-08T01:39:27+00:00\" \/>\n<meta name=\"author\" content=\"Joseph Sack\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Joseph Sack\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/new-course-sql-server-common-query-tuning-problems-solutions-part-1\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/new-course-sql-server-common-query-tuning-problems-solutions-part-1\/\",\"name\":\"New Course: \\\"SQL Server: Common Query Tuning Problems and Solutions - Part 1\\\" - Joe Sack\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/#website\"},\"datePublished\":\"2014-07-08T01:37:53+00:00\",\"dateModified\":\"2014-07-08T01:39:27+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/#\/schema\/person\/533eb0113a15fb5a6e8067a49e4ae648\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/new-course-sql-server-common-query-tuning-problems-solutions-part-1\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/joe\/new-course-sql-server-common-query-tuning-problems-solutions-part-1\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/new-course-sql-server-common-query-tuning-problems-solutions-part-1\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server Training\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/category\/sql-server-training\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"New Course: &#8220;SQL Server: Common Query Tuning Problems and Solutions &#8211; Part 1&#8221;\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/#website\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/\",\"name\":\"Joe Sack\",\"description\":\"SQL Server Performance Tuning, High Availability and Disaster Recovery Blog\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/#\/schema\/person\/533eb0113a15fb5a6e8067a49e4ae648\",\"name\":\"Joseph Sack\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/a4b39a7719a6bfff1add3ec00527810734579ee114d6d983e8e68f937b77be96?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/a4b39a7719a6bfff1add3ec00527810734579ee114d6d983e8e68f937b77be96?s=96&d=mm&r=g\",\"caption\":\"Joseph Sack\"},\"description\":\"Joe Sack is a Principal Consultant with SQLskills. He has worked as a SQL Server professional since 1997 and has supported and developed for SQL Server environments in financial services, IT consulting, manufacturing, retail and the real estate industry. Prior to joining SQLskills he worked at Microsoft as a Premier Field Engineer supporting very large enterprise customer environments. He was responsible for providing deep SQL Server advisory services, training, troubleshooting and ongoing solutions guidance. His areas of expertise include performance tuning, scalability, T-SQL development and high-availability. In 2006 Joe earned the \u201cMicrosoft Certified Master: SQL Server 2005\u201d certification and in 2008 he earned the \u201cMicrosoft Certified Master: SQL Server 2008\u201d certification. In 2009 he took over responsibility for the entire SQL Server Microsoft Certified Master program and held that post until 2011. He was given the SQL Server MVP award in 2013.\",\"sameAs\":[\"http:\/\/3.209.169.194\/blogs\/joe\",\"https:\/\/twitter.com\/https:\/\/twitter.com\/josephsack\"],\"url\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/author\/joe\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"New Course: \"SQL Server: Common Query Tuning Problems and Solutions - Part 1\" - Joe Sack","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.sqlskills.com\/blogs\/joe\/new-course-sql-server-common-query-tuning-problems-solutions-part-1\/","og_locale":"en_US","og_type":"article","og_title":"New Course: \"SQL Server: Common Query Tuning Problems and Solutions - Part 1\" - Joe Sack","og_description":"Pluralsight published my latest course, &#8220;SQL Server: Common Query Tuning Problems and Solutions &#8211; Part 1&#8220;. \u00a0Part 1 is 2 hours and 31 minutes and covers the following: Module: Validating Assumptions 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 [&hellip;]","og_url":"https:\/\/www.sqlskills.com\/blogs\/joe\/new-course-sql-server-common-query-tuning-problems-solutions-part-1\/","og_site_name":"Joe Sack","article_published_time":"2014-07-08T01:37:53+00:00","article_modified_time":"2014-07-08T01:39:27+00:00","author":"Joseph Sack","twitter_misc":{"Written by":"Joseph Sack","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/joe\/new-course-sql-server-common-query-tuning-problems-solutions-part-1\/","url":"https:\/\/www.sqlskills.com\/blogs\/joe\/new-course-sql-server-common-query-tuning-problems-solutions-part-1\/","name":"New Course: \"SQL Server: Common Query Tuning Problems and Solutions - Part 1\" - Joe Sack","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/joe\/#website"},"datePublished":"2014-07-08T01:37:53+00:00","dateModified":"2014-07-08T01:39:27+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/joe\/#\/schema\/person\/533eb0113a15fb5a6e8067a49e4ae648"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/joe\/new-course-sql-server-common-query-tuning-problems-solutions-part-1\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/joe\/new-course-sql-server-common-query-tuning-problems-solutions-part-1\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/joe\/new-course-sql-server-common-query-tuning-problems-solutions-part-1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/joe\/"},{"@type":"ListItem","position":2,"name":"SQL Server Training","item":"https:\/\/www.sqlskills.com\/blogs\/joe\/category\/sql-server-training\/"},{"@type":"ListItem","position":3,"name":"New Course: &#8220;SQL Server: Common Query Tuning Problems and Solutions &#8211; Part 1&#8221;"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlskills.com\/blogs\/joe\/#website","url":"https:\/\/www.sqlskills.com\/blogs\/joe\/","name":"Joe Sack","description":"SQL Server Performance Tuning, High Availability and Disaster Recovery Blog","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlskills.com\/blogs\/joe\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.sqlskills.com\/blogs\/joe\/#\/schema\/person\/533eb0113a15fb5a6e8067a49e4ae648","name":"Joseph Sack","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/joe\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/a4b39a7719a6bfff1add3ec00527810734579ee114d6d983e8e68f937b77be96?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a4b39a7719a6bfff1add3ec00527810734579ee114d6d983e8e68f937b77be96?s=96&d=mm&r=g","caption":"Joseph Sack"},"description":"Joe Sack is a Principal Consultant with SQLskills. He has worked as a SQL Server professional since 1997 and has supported and developed for SQL Server environments in financial services, IT consulting, manufacturing, retail and the real estate industry. Prior to joining SQLskills he worked at Microsoft as a Premier Field Engineer supporting very large enterprise customer environments. He was responsible for providing deep SQL Server advisory services, training, troubleshooting and ongoing solutions guidance. His areas of expertise include performance tuning, scalability, T-SQL development and high-availability. In 2006 Joe earned the \u201cMicrosoft Certified Master: SQL Server 2005\u201d certification and in 2008 he earned the \u201cMicrosoft Certified Master: SQL Server 2008\u201d certification. In 2009 he took over responsibility for the entire SQL Server Microsoft Certified Master program and held that post until 2011. He was given the SQL Server MVP award in 2013.","sameAs":["http:\/\/3.209.169.194\/blogs\/joe","https:\/\/twitter.com\/https:\/\/twitter.com\/josephsack"],"url":"https:\/\/www.sqlskills.com\/blogs\/joe\/author\/joe\/"}]}},"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-json\/wp\/v2\/posts\/1190","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-json\/wp\/v2\/comments?post=1190"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-json\/wp\/v2\/posts\/1190\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-json\/wp\/v2\/media?parent=1190"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-json\/wp\/v2\/categories?post=1190"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-json\/wp\/v2\/tags?post=1190"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}