{"id":967,"date":"2013-04-19T06:28:28","date_gmt":"2013-04-19T13:28:28","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/joe\/?p=967"},"modified":"2013-12-29T19:16:42","modified_gmt":"2013-12-30T03:16:42","slug":"sqlperformance-com-the-case-of-the-cardinality-estimate-red-herring","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/joe\/sqlperformance-com-the-case-of-the-cardinality-estimate-red-herring\/","title":{"rendered":"SQLPerformance.com &ldquo;The Case of the Cardinality Estimate Red Herring&rdquo;"},"content":{"rendered":"<p>My fourth guest blog post was published today on SQLPerformance.com:<\/p>\n<p><a href=\"http:\/\/www.sqlperformance.com\/2013\/04\/t-sql-queries\/the-case-of-the-cardinality-estimate-red-herring\" target=\"_blank\">The Case of the Cardinality Estimate Red Herring<\/a><\/p>\n<p>This was inspired by a case that <a href=\"https:\/\/www.sqlskills.com\/about\/erin-stellato\/\" target=\"_blank\">Erin Stellato<\/a> and I worked together on a few months ago. While I\u2019ve talked quite a bit this year about the importance of investigating bad cardinality estimates, this blog post points to a scenario where the estimate issue isn\u2019t always the full query performance troubleshooting story.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>My fourth guest blog post was published today on SQLPerformance.com: The Case of the Cardinality Estimate Red Herring This was inspired by a case that Erin Stellato and I worked together on a few months ago. While I\u2019ve talked quite a bit this year about the importance of investigating bad cardinality estimates, this blog post [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[42,28],"tags":[],"class_list":["post-967","post","type-post","status-publish","format-standard","hentry","category-cardinality-estimation","category-performance"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.9.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SQLPerformance.com &ldquo;The Case of the Cardinality Estimate Red Herring&rdquo; - 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\/sqlperformance-com-the-case-of-the-cardinality-estimate-red-herring\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQLPerformance.com &ldquo;The Case of the Cardinality Estimate Red Herring&rdquo; - Joe Sack\" \/>\n<meta property=\"og:description\" content=\"My fourth guest blog post was published today on SQLPerformance.com: The Case of the Cardinality Estimate Red Herring This was inspired by a case that Erin Stellato and I worked together on a few months ago. While I\u2019ve talked quite a bit this year about the importance of investigating bad cardinality estimates, this blog post [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/joe\/sqlperformance-com-the-case-of-the-cardinality-estimate-red-herring\/\" \/>\n<meta property=\"og:site_name\" content=\"Joe Sack\" \/>\n<meta property=\"article:published_time\" content=\"2013-04-19T13:28:28+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2013-12-30T03:16: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<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/sqlperformance-com-the-case-of-the-cardinality-estimate-red-herring\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/sqlperformance-com-the-case-of-the-cardinality-estimate-red-herring\/\",\"name\":\"SQLPerformance.com &ldquo;The Case of the Cardinality Estimate Red Herring&rdquo; - Joe Sack\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/#website\"},\"datePublished\":\"2013-04-19T13:28:28+00:00\",\"dateModified\":\"2013-12-30T03:16:42+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/#\/schema\/person\/533eb0113a15fb5a6e8067a49e4ae648\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/sqlperformance-com-the-case-of-the-cardinality-estimate-red-herring\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/joe\/sqlperformance-com-the-case-of-the-cardinality-estimate-red-herring\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/sqlperformance-com-the-case-of-the-cardinality-estimate-red-herring\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cardinality Estimation\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/category\/cardinality-estimation\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"SQLPerformance.com &ldquo;The Case of the Cardinality Estimate Red Herring&rdquo;\"}]},{\"@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":"SQLPerformance.com &ldquo;The Case of the Cardinality Estimate Red Herring&rdquo; - 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\/sqlperformance-com-the-case-of-the-cardinality-estimate-red-herring\/","og_locale":"en_US","og_type":"article","og_title":"SQLPerformance.com &ldquo;The Case of the Cardinality Estimate Red Herring&rdquo; - Joe Sack","og_description":"My fourth guest blog post was published today on SQLPerformance.com: The Case of the Cardinality Estimate Red Herring This was inspired by a case that Erin Stellato and I worked together on a few months ago. While I\u2019ve talked quite a bit this year about the importance of investigating bad cardinality estimates, this blog post [&hellip;]","og_url":"https:\/\/www.sqlskills.com\/blogs\/joe\/sqlperformance-com-the-case-of-the-cardinality-estimate-red-herring\/","og_site_name":"Joe Sack","article_published_time":"2013-04-19T13:28:28+00:00","article_modified_time":"2013-12-30T03:16:42+00:00","author":"Joseph Sack","twitter_misc":{"Written by":"Joseph Sack"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/joe\/sqlperformance-com-the-case-of-the-cardinality-estimate-red-herring\/","url":"https:\/\/www.sqlskills.com\/blogs\/joe\/sqlperformance-com-the-case-of-the-cardinality-estimate-red-herring\/","name":"SQLPerformance.com &ldquo;The Case of the Cardinality Estimate Red Herring&rdquo; - Joe Sack","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/joe\/#website"},"datePublished":"2013-04-19T13:28:28+00:00","dateModified":"2013-12-30T03:16:42+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/joe\/#\/schema\/person\/533eb0113a15fb5a6e8067a49e4ae648"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/joe\/sqlperformance-com-the-case-of-the-cardinality-estimate-red-herring\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/joe\/sqlperformance-com-the-case-of-the-cardinality-estimate-red-herring\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/joe\/sqlperformance-com-the-case-of-the-cardinality-estimate-red-herring\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/joe\/"},{"@type":"ListItem","position":2,"name":"Cardinality Estimation","item":"https:\/\/www.sqlskills.com\/blogs\/joe\/category\/cardinality-estimation\/"},{"@type":"ListItem","position":3,"name":"SQLPerformance.com &ldquo;The Case of the Cardinality Estimate Red Herring&rdquo;"}]},{"@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\/967","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=967"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-json\/wp\/v2\/posts\/967\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-json\/wp\/v2\/media?parent=967"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-json\/wp\/v2\/categories?post=967"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-json\/wp\/v2\/tags?post=967"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}