{"id":4897,"date":"2018-06-11T09:19:32","date_gmt":"2018-06-11T16:19:32","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/paul\/?p=4897"},"modified":"2018-06-11T09:19:32","modified_gmt":"2018-06-11T16:19:32","slug":"new-live-online-training-class-in-october-fixing-slow-queries-inefficient-code-and-cachingstatistics-problems","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/paul\/new-live-online-training-class-in-october-fixing-slow-queries-inefficient-code-and-cachingstatistics-problems\/","title":{"rendered":"New live online training class in October: Fixing Slow Queries, Inefficient Code, and Caching\/Statistics Problems"},"content":{"rendered":"<p style=\"text-align: justify;\">Continuing our series of live, online classes, <strong>Erin, Jonathan, and\u00a0Kimberly\u00a0will be delivering their new\u00a0<a href=\"https:\/\/www.sqlskills.com\/sql-server-training\/iequery\/\" target=\"_blank\" rel=\"noopener noreferrer\"><em>IEQUERY: Immersion Event on Fixing Slow Queries, Inefficient Code, and Caching\/Statistics Problems<\/em><\/a>\u00a0in October!<\/strong>\u00a0The class will be delivered live via WebEx\u00a0on\u00a0October\u00a023-25 (roughly 12-13 hours of content including Q&amp;As; about the same as two full workshop days!) and the attendees\u00a0will have lifetime access to the recordings\u00a0following the end of the class.<\/p>\n<p style=\"text-align: justify;\">Rather than have people try to watch a full day of training at their computer for one of more days, the class will run from 10am to 3pm PST each day, with two 90-minute teaching sessions, each followed by Q&amp;A, and a lunch break. We chose to do this, and to spread the class over a few days, so the times work pretty well for those in the Americas, Africa, and Europe. We also realize that this is complex content, so want to give attendees time to digest each day\u2019s material, plus extensive Q&amp;A.<\/p>\n<p style=\"text-align: justify;\">Here are some select quotes from prior attendees of Erin&#8217;s\/Jon&#8217;s\/Kimberly&#8217;s online\u00a0classes:<\/p>\n<ul>\n<li><em>\u201cExtremely pleased with the course. FAR exceeded my expectations.\u201d<\/em><\/li>\n<li><em>\u201cWell worth the time and expense to attend. Would highly recommend this to others.\u201d<\/em><\/li>\n<li><em>\u201cGreat course \u2013 very informative \u2013 very great instructors \u2013 I am sure to be back!\u201d<\/em><\/li>\n<li><em>\u201cGreat course. Good new info for me, plus refresher on other info. Thanks!\u201d<\/em><\/li>\n<li><em>\u201cBoth Erin and Jon have a vast knowledge of not only SQL Server &amp; tools, but also effective presentation.\u201d<\/em><\/li>\n<li><em>\u201cThanks for taking the time to better my knowledge of SQL and allow me to better my career.\u201d<\/em><\/li>\n<li><em>\u201cKimberly is incredibly knowledgeable and was able to adapt the techniques to all the different scenarios presented to her.\u201d<\/em><\/li>\n<li><em>\u201cGreat course. I could hear clearly, the content was relevant to current day problems, and provided clear instruction.\u201d<\/em><\/li>\n<li><em>\u201cLoved the online aspect. It felt like I was there with the question ability and having the questions just answered right there. I felt I had a voice and could ask anything and the ability to watch it later made it totally worth the registration.\u201d<\/em><\/li>\n<li><em>\u201cI really enjoyed the ability to ask questions as the course went along so that I didn\u2019t forget what I wanted to ask while you were teaching. This allowed for questions to come through and class to continue until a good stopping point to answer the questions. Plus having the questions written from other attendees was nice for future reference instead of trying to remember from an in-person class discussion.\u201d<\/em><\/li>\n<\/ul>\n<p style=\"text-align: justify;\">The class is split into three parts, with each part taught by a different instructor:<\/p>\n<ul>\n<li><strong>Part 1\/Day 1: Capturing Query Information and Analyzing Plans (presented by Erin Stellato)<\/strong>\n<ul>\n<li>Baselining options and considerations<\/li>\n<li>Sources of query performance data (e.g. DMVs, Extended Events or Trace)<\/li>\n<li>Capturing and comparing execution plans<\/li>\n<li>Finding essential information in a plan<\/li>\n<li>Misleading information in a plan<\/li>\n<li>Common operators<\/li>\n<li>Operators and memory use<\/li>\n<li>Predicates and filters<\/li>\n<li>Parallelism in plans<\/li>\n<\/ul>\n<\/li>\n<li><strong>Part 2\/Day 2: Removing Anti-Patterns in Transact-SQL (presented by Jonathan Kehayias)<\/strong>\n<ul>\n<li>Set based concepts for developers<\/li>\n<li>Design considerations that affect performance<\/li>\n<li>Reducing\/eliminating row-by-row processing\n<ul>\n<li>CURSORs and WHILE Loops, scalar UDFs, TVFs<\/li>\n<\/ul>\n<\/li>\n<li>Understanding Sargability and eliminating index scans in code<\/li>\n<li>Profiling during development and testing properly<\/li>\n<\/ul>\n<\/li>\n<li><strong>Part 3\/Day 3: How to Differentiate Caching \/ Statistics problems and SOLVE THEM! (presented by Kimberly L. Tripp)<\/strong>\n<ul>\n<li>Troubleshooting Statement Execution and Caching\n<ul>\n<li>Different ways to execute statements<\/li>\n<li>Some statements can be cached for reuse<\/li>\n<li>Statement auto-parameterization<\/li>\n<li>Dynamic string execution<\/li>\n<li>sp_executesql<\/li>\n<li>Stored procedures<\/li>\n<li>Literals, variables, and parameters<\/li>\n<li>The life of a plan in cache<\/li>\n<li>Plan cache limits<\/li>\n<li>Bringing it all together<\/li>\n<\/ul>\n<\/li>\n<li>Troubleshooting\u00a0Plan Problems Related to Statistics (not Caching)\n<ul>\n<li>Statement selectivity<\/li>\n<li>What kinds of statistics exist<\/li>\n<li>How does SQL Server use statistics<\/li>\n<li>Creating additional statistics<\/li>\n<li>Updating statistics<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><strong>The price of the class is US$699 (or US$599 for prior live, online attendees) and there&#8217;s also a combo price for all three new classes announced today.<\/strong><\/p>\n<p style=\"text-align: justify;\"><strong>You can get all the details\u00a0<a href=\"https:\/\/www.sqlskills.com\/sql-server-training\/live-online-ietlb-20181009\/\" target=\"_blank\" rel=\"noopener noreferrer\">here<\/a>.<\/strong><\/p>\n<p style=\"text-align: justify;\">The class was also announced in our\u00a0<a href=\"https:\/\/www.sqlskills.com\/join-the-sqlskills-insider-community\/\" target=\"_blank\" rel=\"noopener noreferrer\">newsletter<\/a>\u00a0today, with a US$100 discount for those people who received that newsletter, valid\u00a0through the end of June. All future live, online classes will always feature a\u00a0discount for newsletter subscribers.<\/p>\n<p style=\"text-align: justify;\">We decided to start teaching some live, online classes as we recognize that not everyone can travel to our in-person classes, or take that time away from work or family, or simply have travel budget as well as training budget. People also have different ways they learn, some preferring in-person training, some preferring recorded, online training, and some preferring live, online training.<\/p>\n<p style=\"text-align: justify;\">We\u2019ll be doing more of these\u00a0so stay tuned for updates (and discounts through the newsletter).<\/p>\n<p style=\"text-align: justify;\">We hope\u00a0you can join us!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Continuing our series of live, online classes, Erin, Jonathan, and\u00a0Kimberly\u00a0will be delivering their new\u00a0IEQUERY: Immersion Event on Fixing Slow Queries, Inefficient Code, and Caching\/Statistics Problems\u00a0in October!\u00a0The class will be delivered live via WebEx\u00a0on\u00a0October\u00a023-25 (roughly 12-13 hours of content including Q&amp;As; about the same as two full workshop days!) and the attendees\u00a0will have lifetime access to [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[24,66,73,90,97],"tags":[],"class_list":["post-4897","post","type-post","status-publish","format-standard","hentry","category-classes","category-performance-tuning","category-query-tuning","category-statistics","category-training"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>New live online training class in October: Fixing Slow Queries, Inefficient Code, and Caching\/Statistics Problems - Paul S. Randal<\/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\/paul\/new-live-online-training-class-in-october-fixing-slow-queries-inefficient-code-and-cachingstatistics-problems\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"New live online training class in October: Fixing Slow Queries, Inefficient Code, and Caching\/Statistics Problems - Paul S. Randal\" \/>\n<meta property=\"og:description\" content=\"Continuing our series of live, online classes, Erin, Jonathan, and\u00a0Kimberly\u00a0will be delivering their new\u00a0IEQUERY: Immersion Event on Fixing Slow Queries, Inefficient Code, and Caching\/Statistics Problems\u00a0in October!\u00a0The class will be delivered live via WebEx\u00a0on\u00a0October\u00a023-25 (roughly 12-13 hours of content including Q&amp;As; about the same as two full workshop days!) and the attendees\u00a0will have lifetime access to [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/paul\/new-live-online-training-class-in-october-fixing-slow-queries-inefficient-code-and-cachingstatistics-problems\/\" \/>\n<meta property=\"og:site_name\" content=\"Paul S. Randal\" \/>\n<meta property=\"article:published_time\" content=\"2018-06-11T16:19:32+00:00\" \/>\n<meta name=\"author\" content=\"Paul Randal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Paul Randal\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/new-live-online-training-class-in-october-fixing-slow-queries-inefficient-code-and-cachingstatistics-problems\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/new-live-online-training-class-in-october-fixing-slow-queries-inefficient-code-and-cachingstatistics-problems\/\",\"name\":\"New live online training class in October: Fixing Slow Queries, Inefficient Code, and Caching\/Statistics Problems - Paul S. Randal\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#website\"},\"datePublished\":\"2018-06-11T16:19:32+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/new-live-online-training-class-in-october-fixing-slow-queries-inefficient-code-and-cachingstatistics-problems\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/paul\/new-live-online-training-class-in-october-fixing-slow-queries-inefficient-code-and-cachingstatistics-problems\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/new-live-online-training-class-in-october-fixing-slow-queries-inefficient-code-and-cachingstatistics-problems\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"New live online training class in October: Fixing Slow Queries, Inefficient Code, and Caching\/Statistics Problems\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#website\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/\",\"name\":\"Paul S. Randal\",\"description\":\"In Recovery...\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce\",\"name\":\"Paul Randal\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g\",\"caption\":\"Paul Randal\"},\"sameAs\":[\"http:\/\/3.209.169.194\/blogs\/paul\"],\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/author\/paul\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"New live online training class in October: Fixing Slow Queries, Inefficient Code, and Caching\/Statistics Problems - Paul S. Randal","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\/paul\/new-live-online-training-class-in-october-fixing-slow-queries-inefficient-code-and-cachingstatistics-problems\/","og_locale":"en_US","og_type":"article","og_title":"New live online training class in October: Fixing Slow Queries, Inefficient Code, and Caching\/Statistics Problems - Paul S. Randal","og_description":"Continuing our series of live, online classes, Erin, Jonathan, and\u00a0Kimberly\u00a0will be delivering their new\u00a0IEQUERY: Immersion Event on Fixing Slow Queries, Inefficient Code, and Caching\/Statistics Problems\u00a0in October!\u00a0The class will be delivered live via WebEx\u00a0on\u00a0October\u00a023-25 (roughly 12-13 hours of content including Q&amp;As; about the same as two full workshop days!) and the attendees\u00a0will have lifetime access to [&hellip;]","og_url":"https:\/\/www.sqlskills.com\/blogs\/paul\/new-live-online-training-class-in-october-fixing-slow-queries-inefficient-code-and-cachingstatistics-problems\/","og_site_name":"Paul S. Randal","article_published_time":"2018-06-11T16:19:32+00:00","author":"Paul Randal","twitter_misc":{"Written by":"Paul Randal","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/new-live-online-training-class-in-october-fixing-slow-queries-inefficient-code-and-cachingstatistics-problems\/","url":"https:\/\/www.sqlskills.com\/blogs\/paul\/new-live-online-training-class-in-october-fixing-slow-queries-inefficient-code-and-cachingstatistics-problems\/","name":"New live online training class in October: Fixing Slow Queries, Inefficient Code, and Caching\/Statistics Problems - Paul S. Randal","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#website"},"datePublished":"2018-06-11T16:19:32+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/new-live-online-training-class-in-october-fixing-slow-queries-inefficient-code-and-cachingstatistics-problems\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/paul\/new-live-online-training-class-in-october-fixing-slow-queries-inefficient-code-and-cachingstatistics-problems\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/new-live-online-training-class-in-october-fixing-slow-queries-inefficient-code-and-cachingstatistics-problems\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/paul\/"},{"@type":"ListItem","position":2,"name":"New live online training class in October: Fixing Slow Queries, Inefficient Code, and Caching\/Statistics Problems"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#website","url":"https:\/\/www.sqlskills.com\/blogs\/paul\/","name":"Paul S. Randal","description":"In Recovery...","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlskills.com\/blogs\/paul\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce","name":"Paul Randal","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g","caption":"Paul Randal"},"sameAs":["http:\/\/3.209.169.194\/blogs\/paul"],"url":"https:\/\/www.sqlskills.com\/blogs\/paul\/author\/paul\/"}]}},"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/posts\/4897","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/comments?post=4897"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/posts\/4897\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/media?parent=4897"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/categories?post=4897"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/tags?post=4897"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}