{"id":1364,"date":"2018-04-11T10:43:40","date_gmt":"2018-04-11T17:43:40","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/glenn\/?p=1364"},"modified":"2018-12-20T11:43:13","modified_gmt":"2018-12-20T19:43:13","slug":"pass-summit-2018-pre-confixing-query-performance-problems-from-estimates-statistics-heuristics-and-cardinality","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/glenn\/pass-summit-2018-pre-confixing-query-performance-problems-from-estimates-statistics-heuristics-and-cardinality\/","title":{"rendered":"PASS Summit 2018 Pre-con:Fixing Query Performance Problems from Estimates, Statistics, Heuristics, and Cardinality"},"content":{"rendered":"

PASS has publicly announced their Pre-conference Sessions<\/a> for the PASS Summit 2018 in Seattle, WA. There are seven sessions on Monday, November 5, 2018<\/a>, and nine sessions on Tuesday, November 6, 2018<\/a>. There are good sessions on both days, from many well-known speakers.<\/font><\/p>\n

In my honest opinion, the most valuable session for most database professionals who care about query performance is Kimberly Tripp\u2019s Fixing Query Performance Problems from Estimates, Statistics, Heuristics, and Cardinality<\/a> on Tuesday. Kimberly<\/a> is the world-class master on this subject, as evidenced by her many blog posts<\/a>, presentations<\/a>, and Pluralsight courses<\/a>.<\/font><\/p>\n

Kimberly is a very talented and passionate presenter and teacher. Long before I worked for SQLskills (way back in 2006 when I was working at NewsGator), I had the chance to take the week-long predecessor class to the current IEPTO1: Immersion Event on Performance Tuning and Optimization \u2013 Part 1<\/a>. That class was a life-changer for me, and it had a huge effect on my career.<\/font><\/p>\n

Since then, I have seen how Kimberly presents and teaches many times over the years. I have learned so much from both her content and from her presentation and teaching style by watching her. Unlike some well-known presenters, she doesn\u2019t use cute pictures or silly marketing gimmicks in her presentation content. She is not there to just \u201cput on a show\u201d for entertainment purposes.<\/font><\/p>\n

She prepares very detailed, content-dense slides that are a very useful resource to keep and review long after the session is over. She also has the depth of knowledge and experience to actually improvise and modify her demonstrations in response to questions during a session. As any experienced presenter knows, that is a pretty big deal.<\/font><\/p>\n

She actually understands what she is teaching at a very deep level, and she has the many years of teaching experience to explain it clearly to people with any level of experience. Despite the lack of cute pictures or costumes, she does her presentations in a very engaging manner because of her real passion for the subject.<\/font><\/p>\n

Here are her relevant Pluralsight courses that I would recommend watching to prepare for this pre-conference session:<\/font><\/font><\/p>\n

\n

SQL Server: Optimizing Stored Procedure Performance<\/a><\/font><\/p>\n

SQL Server: Optimizing Stored Procedure Performance – Part 2<\/a><\/font><\/p>\n

SQL Server: Optimizing Ad Hoc Statement Performance<\/a><\/font><\/p>\n

SQL Server: Indexing for Performance<\/a><\/font><\/p>\n

SQL Server: Why Physical Database Design Matters<\/a><\/font><\/p>\n<\/blockquote>\n

BTW, Kimberly did not put me up to writing this post. In fact, she might be a little embarrassed by all of this praise. She might even mock fire me on Twitter once she sees it. I just felt I needed to spread the word about this pre-conference session.<\/font><\/p>\n","protected":false},"excerpt":{"rendered":"

PASS has publicly announced their Pre-conference Sessions for the PASS Summit 2018 in Seattle, WA. There are seven sessions on Monday, November 5, 2018, and nine sessions on Tuesday, November 6, 2018. There are good sessions on both days, from many well-known speakers. In my honest opinion, the most valuable session for most database professionals […]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[23,36],"tags":[381],"class_list":["post-1364","post","type-post","status-publish","format-standard","hentry","category-sql-server-pass","category-teaching","tag-pass-summit-2018"],"yoast_head":"\nPASS Summit 2018 Pre-con:Fixing Query Performance Problems from Estimates, Statistics, Heuristics, and Cardinality - Glenn Berry<\/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\/glenn\/pass-summit-2018-pre-confixing-query-performance-problems-from-estimates-statistics-heuristics-and-cardinality\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PASS Summit 2018 Pre-con:Fixing Query Performance Problems from Estimates, Statistics, Heuristics, and Cardinality - Glenn Berry\" \/>\n<meta property=\"og:description\" content=\"PASS has publicly announced their Pre-conference Sessions for the PASS Summit 2018 in Seattle, WA. There are seven sessions on Monday, November 5, 2018, and nine sessions on Tuesday, November 6, 2018. There are good sessions on both days, from many well-known speakers. In my honest opinion, the most valuable session for most database professionals […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/pass-summit-2018-pre-confixing-query-performance-problems-from-estimates-statistics-heuristics-and-cardinality\/\" \/>\n<meta property=\"og:site_name\" content=\"Glenn Berry\" \/>\n<meta property=\"article:published_time\" content=\"2018-04-11T17:43:40+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-12-20T19:43:13+00:00\" \/>\n<meta name=\"author\" content=\"Glenn Berry\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Glenn Berry\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/pass-summit-2018-pre-confixing-query-performance-problems-from-estimates-statistics-heuristics-and-cardinality\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/pass-summit-2018-pre-confixing-query-performance-problems-from-estimates-statistics-heuristics-and-cardinality\/\",\"name\":\"PASS Summit 2018 Pre-con:Fixing Query Performance Problems from Estimates, Statistics, Heuristics, and Cardinality - Glenn Berry\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website\"},\"datePublished\":\"2018-04-11T17:43:40+00:00\",\"dateModified\":\"2018-12-20T19:43:13+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/pass-summit-2018-pre-confixing-query-performance-problems-from-estimates-statistics-heuristics-and-cardinality\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/glenn\/pass-summit-2018-pre-confixing-query-performance-problems-from-estimates-statistics-heuristics-and-cardinality\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/pass-summit-2018-pre-confixing-query-performance-problems-from-estimates-statistics-heuristics-and-cardinality\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PASS Summit 2018 Pre-con:Fixing Query Performance Problems from Estimates, Statistics, Heuristics, and Cardinality\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/\",\"name\":\"Glenn Berry\",\"description\":\"Semi-random musings about SQL Server performance\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/?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\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7\",\"name\":\"Glenn Berry\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/64bdac8830f25f2f8cc780f8a1286c66ff1182218009271e7a953639596f7e25?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/64bdac8830f25f2f8cc780f8a1286c66ff1182218009271e7a953639596f7e25?s=96&d=mm&r=g\",\"caption\":\"Glenn Berry\"},\"sameAs\":[\"https:\/\/www.sqlskills.com\/blogs\/glenn\/\"],\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/author\/glenn\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"PASS Summit 2018 Pre-con:Fixing Query Performance Problems from Estimates, Statistics, Heuristics, and Cardinality - Glenn Berry","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\/glenn\/pass-summit-2018-pre-confixing-query-performance-problems-from-estimates-statistics-heuristics-and-cardinality\/","og_locale":"en_US","og_type":"article","og_title":"PASS Summit 2018 Pre-con:Fixing Query Performance Problems from Estimates, Statistics, Heuristics, and Cardinality - Glenn Berry","og_description":"PASS has publicly announced their Pre-conference Sessions for the PASS Summit 2018 in Seattle, WA. There are seven sessions on Monday, November 5, 2018, and nine sessions on Tuesday, November 6, 2018. There are good sessions on both days, from many well-known speakers. In my honest opinion, the most valuable session for most database professionals […]","og_url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/pass-summit-2018-pre-confixing-query-performance-problems-from-estimates-statistics-heuristics-and-cardinality\/","og_site_name":"Glenn Berry","article_published_time":"2018-04-11T17:43:40+00:00","article_modified_time":"2018-12-20T19:43:13+00:00","author":"Glenn Berry","twitter_misc":{"Written by":"Glenn Berry","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/pass-summit-2018-pre-confixing-query-performance-problems-from-estimates-statistics-heuristics-and-cardinality\/","url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/pass-summit-2018-pre-confixing-query-performance-problems-from-estimates-statistics-heuristics-and-cardinality\/","name":"PASS Summit 2018 Pre-con:Fixing Query Performance Problems from Estimates, Statistics, Heuristics, and Cardinality - Glenn Berry","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website"},"datePublished":"2018-04-11T17:43:40+00:00","dateModified":"2018-12-20T19:43:13+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/pass-summit-2018-pre-confixing-query-performance-problems-from-estimates-statistics-heuristics-and-cardinality\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/glenn\/pass-summit-2018-pre-confixing-query-performance-problems-from-estimates-statistics-heuristics-and-cardinality\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/pass-summit-2018-pre-confixing-query-performance-problems-from-estimates-statistics-heuristics-and-cardinality\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/glenn\/"},{"@type":"ListItem","position":2,"name":"PASS Summit 2018 Pre-con:Fixing Query Performance Problems from Estimates, Statistics, Heuristics, and Cardinality"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website","url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/","name":"Glenn Berry","description":"Semi-random musings about SQL Server performance","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlskills.com\/blogs\/glenn\/?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\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7","name":"Glenn Berry","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/64bdac8830f25f2f8cc780f8a1286c66ff1182218009271e7a953639596f7e25?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/64bdac8830f25f2f8cc780f8a1286c66ff1182218009271e7a953639596f7e25?s=96&d=mm&r=g","caption":"Glenn Berry"},"sameAs":["https:\/\/www.sqlskills.com\/blogs\/glenn\/"],"url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/author\/glenn\/"}]}},"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/posts\/1364","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/comments?post=1364"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/posts\/1364\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/media?parent=1364"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/categories?post=1364"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/tags?post=1364"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}