{"id":1193,"date":"2014-08-11T15:21:58","date_gmt":"2014-08-11T22:21:58","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/joe\/?p=1193"},"modified":"2014-08-11T15:27:42","modified_gmt":"2014-08-11T22:27:42","slug":"new-course-sql-server-common-query-tuning-problems-solutions-part-2","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/joe\/new-course-sql-server-common-query-tuning-problems-solutions-part-2\/","title":{"rendered":"New Course: \u201cSQL Server: Common Query Tuning Problems and Solutions \u2013 Part 2\u2033"},"content":{"rendered":"<p style=\"color: #555555;\">Today, Pluralsight published my latest course, \u201c<a style=\"font-weight: inherit; font-style: inherit; color: #005187;\" title=\"SQL Server Common Query Tuning Problems and Solutions\" href=\"http:\/\/pluralsight.com\/training\/Courses\/TableOfContents\/sql-server-common-query-tuning-problems-solutions-part2\" target=\"_blank\">SQL Server: Common Query Tuning Problems and Solutions \u2013 Part <\/a><span style=\"text-decoration: underline;\">2<\/span>\u201c. \u00a0Part two is 2\u00a0hours and 17 minutes long and covers the following:<\/p>\n<p style=\"color: #555555;\"><strong>Troubleshooting Inefficiency<\/strong><\/p>\n<ul>\n<li>Demo: One-Row-At-A-Time-Processing<\/li>\n<li>Demo: The Forgotten Trigger<\/li>\n<li>Demo: Scalar Function Inhibited Parallelism<\/li>\n<li>Demo: Scalar Function Row by Row Execution<\/li>\n<li>Demo: Too Few Rows Per Batch<\/li>\n<li>Demo: Not Using TOP When You Can<\/li>\n<li>Demo: Unnecessary Many-To-Many<\/li>\n<li>Demo: Excessive Fragmentation and Scans<\/li>\n<\/ul>\n<p style=\"color: #555555;\"><strong>Tuning OLTP vs. DSS Patterns<\/strong><\/p>\n<ul>\n<li>Defining OLTP and DSS<\/li>\n<li>OLTP Characteristics<\/li>\n<li>Demo: Stop-And-Go Operators<\/li>\n<li>Demo: Finding Timeout-Prone Queries<\/li>\n<li>Demo: Over-Indexing<\/li>\n<li>Demo: OLTP and Parallelism<\/li>\n<li>Demo: OLTP and Deep Trees<\/li>\n<li>DSS Characteristics<\/li>\n<li>Demo: Expanding the AdventureWorksDW2012 Database<\/li>\n<li>Demo: Unwanted Serial Plans<\/li>\n<li>Demo: Gatekeeper Row Issue &#8211; Part 1<\/li>\n<li>Demo: Gatekeeper Row Issue &#8211; Part 2<\/li>\n<li>Demo: Gatekeeper Row Issue &#8211; Part 3<\/li>\n<li>Demo: Aggregation Queries and Columnstore Index Opportunities<\/li>\n<li>Demo: Distinct Aggregation Issue<\/li>\n<\/ul>\n<p style=\"color: #555555;\"><strong>Advanced Query Tuning Patterns<\/strong><\/p>\n<ul>\n<li>Demo: New-Feature Abuse<\/li>\n<li>Demo: Recursive CTE Estimate Skews<\/li>\n<li>Demo: Seeks, Scans, Predicates, and Filters &#8211; Part 1<\/li>\n<li>Demo: Seeks, Scans, Predicates, and Filters &#8211; Part 2<\/li>\n<li>Demo: Seeks, Scans, Predicates, and Filters &#8211; Part 3<\/li>\n<li>Demo: Unmatched Indexes<\/li>\n<li>Demo: Disused Filtered Statistics<\/li>\n<li>Demo: Interpreting RetrievedFromCache<\/li>\n<li>Demo: Amplification and Distinct Value Counts<\/li>\n<li>Demo: Join Hints and Forced Order<\/li>\n<li>Demo: CTEs vs. Derived Tables<\/li>\n<li>Demo: One Procedure With Multiple Optional Input Parameters<\/li>\n<li>Demo: Procedure Sub-Branching<\/li>\n<li>Demo: Verifying Instance Workload Complexity<\/li>\n<\/ul>\n<p style=\"color: #555555;\">And if you are new to\u00a0Pluralsight or considering a subscription,\u00a0<a href=\"https:\/\/www.sqlskills.com\/sql-server-training\/online-training\/\" target=\"_blank\">be sure to review the ever-growing course catalog from the entire SQLskills team<\/a>!<\/p>\n<p style=\"color: #555555;\">\n","protected":false},"excerpt":{"rendered":"<p>Today, Pluralsight published my latest course, \u201cSQL Server: Common Query Tuning Problems and Solutions \u2013 Part 2\u201c. \u00a0Part two is 2\u00a0hours and 17 minutes long and covers the following: Troubleshooting Inefficiency 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 [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28,38],"tags":[],"class_list":["post-1193","post","type-post","status-publish","format-standard","hentry","category-performance","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>SQL Server: Common Query Tuning Problems and Solutions \u2013 Part 2<\/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-2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server: Common Query Tuning Problems and Solutions \u2013 Part 2\" \/>\n<meta property=\"og:description\" content=\"Today, Pluralsight published my latest course, \u201cSQL Server: Common Query Tuning Problems and Solutions \u2013 Part 2\u201c. \u00a0Part two is 2\u00a0hours and 17 minutes long and covers the following: Troubleshooting Inefficiency 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 [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/joe\/new-course-sql-server-common-query-tuning-problems-solutions-part-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Joe Sack\" \/>\n<meta property=\"article:published_time\" content=\"2014-08-11T22:21:58+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2014-08-11T22:27:42+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-2\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/new-course-sql-server-common-query-tuning-problems-solutions-part-2\/\",\"name\":\"SQL Server: Common Query Tuning Problems and Solutions \u2013 Part 2\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/#website\"},\"datePublished\":\"2014-08-11T22:21:58+00:00\",\"dateModified\":\"2014-08-11T22:27:42+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-2\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/joe\/new-course-sql-server-common-query-tuning-problems-solutions-part-2\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/new-course-sql-server-common-query-tuning-problems-solutions-part-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Performance\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/category\/performance\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"New Course: \u201cSQL Server: Common Query Tuning Problems and Solutions \u2013 Part 2\u2033\"}]},{\"@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":"SQL Server: Common Query Tuning Problems and Solutions \u2013 Part 2","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-2\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server: Common Query Tuning Problems and Solutions \u2013 Part 2","og_description":"Today, Pluralsight published my latest course, \u201cSQL Server: Common Query Tuning Problems and Solutions \u2013 Part 2\u201c. \u00a0Part two is 2\u00a0hours and 17 minutes long and covers the following: Troubleshooting Inefficiency 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 [&hellip;]","og_url":"https:\/\/www.sqlskills.com\/blogs\/joe\/new-course-sql-server-common-query-tuning-problems-solutions-part-2\/","og_site_name":"Joe Sack","article_published_time":"2014-08-11T22:21:58+00:00","article_modified_time":"2014-08-11T22:27:42+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-2\/","url":"https:\/\/www.sqlskills.com\/blogs\/joe\/new-course-sql-server-common-query-tuning-problems-solutions-part-2\/","name":"SQL Server: Common Query Tuning Problems and Solutions \u2013 Part 2","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/joe\/#website"},"datePublished":"2014-08-11T22:21:58+00:00","dateModified":"2014-08-11T22:27:42+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-2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/joe\/new-course-sql-server-common-query-tuning-problems-solutions-part-2\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/joe\/new-course-sql-server-common-query-tuning-problems-solutions-part-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/joe\/"},{"@type":"ListItem","position":2,"name":"Performance","item":"https:\/\/www.sqlskills.com\/blogs\/joe\/category\/performance\/"},{"@type":"ListItem","position":3,"name":"New Course: \u201cSQL Server: Common Query Tuning Problems and Solutions \u2013 Part 2\u2033"}]},{"@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\/1193","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=1193"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-json\/wp\/v2\/posts\/1193\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-json\/wp\/v2\/media?parent=1193"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-json\/wp\/v2\/categories?post=1193"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-json\/wp\/v2\/tags?post=1193"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}