{"id":151,"date":"2016-05-03T00:00:00","date_gmt":"2013-01-01T00:00:00","guid":{"rendered":"https:\/\/www.sqlhammer.com\/query-store-for-everyone"},"modified":"2026-03-18T21:52:31","modified_gmt":"2026-03-18T21:52:31","slug":"query-store-for-everyone","status":"publish","type":"post","link":"https:\/\/sqlhammer.com\/index.php\/2016\/05\/03\/query-store-for-everyone\/","title":{"rendered":"Query Store for Everyone"},"content":{"rendered":"<p>SQL Server 2016\u2019s <a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/dn817826.aspx\">Query Store<\/a> feature is, without a doubt, one of the most exciting new features for this version. The Query Store\u00a0will keep track of current and past query execution plans which grants you deeper insights into the performance of your queries and allows you to pin a plan in-place, forcing the optimizer to continue to re-use that plan.<\/p>\n<p>Brent Ozar has a great run down of the feature <a href=\"https:\/\/www.brentozar.com\/archive\/2014\/11\/sql-server-query-store\/\">here<\/a>.<\/p>\n<h2>Query Store, available in all editions<\/h2>\n<p>What is even more exciting than the feature itself is that it will be available in all editions. You may not believe me and I understand why. May 2nd has been a Monday ride on the emotional roller coaster of announcement\u00a0<em>oops\u2019<\/em>.<\/p>\n<p>It all started when we thought <a href=\"https:\/\/twitter.com\/bobwardms\/\">Bob Ward<\/a>\u00a0implied Query Store would be in all editions.<\/p>\n<p><a href=\"http:\/\/www.sqlhammer.com\/?attachment_id=3002\"><img decoding=\"async\" src=\"\/wp-content\/uploads\/brent-announcement.png\" alt=\"\" \/><\/a><\/p>\n<p>Then Bob put us in our place.<\/p>\n<p><a href=\"http:\/\/www.sqlhammer.com\/?attachment_id=3003\"><img decoding=\"async\" src=\"\/wp-content\/uploads\/bob-wards-announcement.png\" alt=\"\" \/><\/a><\/p>\n<p>Today the version release date (June 1st, 2016) was announced and the <a href=\"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2016\/05\/02\/get-ready-sql-server-2016-coming-on-june-1st\/\">announcement<\/a> had a link to the edition <a href=\"\/wp-content\/uploads\/SQL_Server_2016_Everything_Built-In_Datasheet_EN_US.pdf\">data sheet<\/a>. The data sheet showed Query Store as only an Enterprise edition feature.<\/p>\n<p><a href=\"http:\/\/www.sqlhammer.com\/?attachment_id=3004\"><img decoding=\"async\" src=\"\/wp-content\/uploads\/crying.gif\" alt=\"\" \/><\/a><\/p>\n<p>As we all cried into our pillows under our desks, Bob returned to point out the facts. Apparently the data sheet on the general availability announcement was out-of-date.<\/p>\n<p><a href=\"http:\/\/www.sqlhammer.com\/?attachment_id=3005\"><img decoding=\"async\" src=\"\/wp-content\/uploads\/bob-wards-announcement2.png\" alt=\"\" \/><\/a><\/p>\n<p>That\u2019s right fellow data nerds, <a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/cc645993.aspx\">books online<\/a> confirms Query Store in all editions.<\/p>\n<p><a href=\"http:\/\/www.sqlhammer.com\/?attachment_id=3006\"><img decoding=\"async\" src=\"\/wp-content\/uploads\/querystoreeditions.png\" alt=\"\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>SQL Server 2016\u2019s Query Store feature is, without a doubt, one of the most exciting new features for this version. The Query Store\u00a0will keep track of current and past query execution plans which grants you deeper insights into the performance of your queries and allows you to pin a plan in-place, forcing the optimizer to [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":549,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,6,7,9,11,13,14],"tags":[],"class_list":["post-151","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-administration","category-career","category-community","category-development","category-general","category-microsoft-sql-server","category-performance"],"_links":{"self":[{"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/posts\/151","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/comments?post=151"}],"version-history":[{"count":1,"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/posts\/151\/revisions"}],"predecessor-version":[{"id":413,"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/posts\/151\/revisions\/413"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/media\/549"}],"wp:attachment":[{"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/media?parent=151"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/categories?post=151"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/tags?post=151"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}