{"id":6123,"date":"2008-10-06T17:05:00","date_gmt":"2008-10-07T00:05:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2008\/10\/06\/sql-server-2008-performs-1-trillion-row-query-in-seconds-at-bi-conference\/"},"modified":"2024-01-22T22:51:42","modified_gmt":"2024-01-23T06:51:42","slug":"sql-server-2008-performs-1-trillion-row-query-in-seconds-at-bi-conference","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2008\/10\/06\/sql-server-2008-performs-1-trillion-row-query-in-seconds-at-bi-conference\/","title":{"rendered":"SQL Server 2008 performs 1 trillion row query in seconds at BI Conference"},"content":{"rendered":"<p>The Washington State Convention &amp; Trade Center in Seattle is buzzing today as Microsoft kicks off its second annual Business Intelligence Conference. Microsoft Business Division president Stephen Elop took the stage to speak to more than 2,500 customers and partners about end-user empowerment, self-service BI, and people-ready BI, followed by Ted Kummert, corporate vice president of the Data and Platform Storage Division at Microsoft, announced some exciting new developments for SQL Server.<\/p>\n<table cellspacing=\"0\" cellpadding=\"2\" border=\"0\" style=\"width:547px;\">\n<tbody>\n<tr>\n<td valign=\"top\" width=\"21\"><a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/Madison_thumb.jpg\" original-url=\"http:\/\/blogs.technet.com\/blogfiles\/dataplatforminsider\/WindowsLiveWriter\/SQLServer2008performs1trillionrowqueryin_C222\/Madison.jpg\"><img loading=\"lazy\" decoding=\"async\" style=\"border:0px;\" height=\"139\" alt=\"Madison\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/Madison_thumb.jpg\" original-url=\"http:\/\/blogs.technet.com\/blogfiles\/dataplatforminsider\/WindowsLiveWriter\/SQLServer2008performs1trillionrowqueryin_C222\/Madison_thumb.jpg\" width=\"184\" border=\"0\" srcset=\"\"><\/a><\/td>\n<td valign=\"top\" width=\"524\">\n<strong>Project &#8220;Madison&#8221; runs 1 trillion row query in seconds <br \/><\/strong>Project &#8220;Madison&#8221; was announced as the release of SQL Server that will be integrated with the recent DATAllegro acquisition. Project &#8220;Madison&#8221; will be capable of handling the most challenging data warehouse workloads which is key since the data warehouse is the hub of any BI solution. Today at the BI Conference, SQL Server demonstrated how capable this technology really is by using current reporting tools to perform a 1 trillion row query on a 100 TB data warehouse with results returning in seconds. <\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"21\"><a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/Kilimanjaro_thumb.jpg\" original-url=\"http:\/\/blogs.technet.com\/blogfiles\/dataplatforminsider\/WindowsLiveWriter\/SQLServer2008performs1trillionrowqueryin_C222\/Kilimanjaro.jpg\"><img loading=\"lazy\" decoding=\"async\" style=\"border:0px;\" height=\"139\" alt=\"Kilimanjaro\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/Kilimanjaro_thumb.jpg\" original-url=\"http:\/\/blogs.technet.com\/blogfiles\/dataplatforminsider\/WindowsLiveWriter\/SQLServer2008performs1trillionrowqueryin_C222\/Kilimanjaro_thumb.jpg\" width=\"184\" border=\"0\" srcset=\"\"><\/a><\/td>\n<td valign=\"top\" width=\"524\">\n<strong>SQL Server code-name &#8220;Kilimanjaro&#8221; announced <br \/><\/strong>The next release of SQL Server code-name &#8220;Kilimanjaro&#8221; will focus on BI and end-user empowerment. As part of Kilimanjaro, project code-name &#8220;Gemini&#8221; will enable users to perform self-service analysis and intuitively build their own BI solutions by easily sharing and collaborating on personal BI results. The new capabilities will enable end users to directly access, analyze, personalize, and share data using the Excel and SharePoint with minimal dependence on IT. <\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"21\"><a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/Acosta_SQL_Server_thumb.jpg\" original-url=\"http:\/\/blogs.technet.com\/blogfiles\/dataplatforminsider\/WindowsLiveWriter\/SQLServer2008performs1trillionrowqueryin_C222\/Acosta_SQL_Server.jpg\"><img loading=\"lazy\" decoding=\"async\" style=\"border:0px;\" height=\"139\" alt=\"Acosta_SQL_Server\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/Acosta_SQL_Server_thumb.jpg\" original-url=\"http:\/\/blogs.technet.com\/blogfiles\/dataplatforminsider\/WindowsLiveWriter\/SQLServer2008performs1trillionrowqueryin_C222\/Acosta_SQL_Server_thumb.jpg\" width=\"184\" border=\"0\" srcset=\"\"><\/a><\/td>\n<td valign=\"top\" width=\"524\">\n<strong>Acosta achieves 70% improvement with SQL Server 2008 <br \/><\/strong>Mike Chaffin, CIO of Acosta, joined Ted Kummert on stage to discuss Acosta\u2019s efforts in upgrading its BI solutions to <a>SQL Server<\/a> 2008. Acosta provides retail sales and category management services to more than 1,000 manufacturers, including giants such as Clorox, Heinz, and Nestle. Now its clients get better data views, easier data management with table partitioning, enhanced performance with dynamic management views, and 70 percent faster aggregations.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong>Additional Resources<\/strong><\/p>\n<ul>\n<li>Read the <a href=\"http:\/\/www.microsoft.com\/Presspass\/press\/2008\/oct08\/10-06BI08PR.mspx\">official press release here<\/a>.<\/li>\n<li>Read more about the <a href=\"http:\/\/www.microsoft.com\/casestudies\/casestudy.aspx?casestudyid=4000000128\">Acosta case study<\/a>.<\/li>\n<li>The Microsoft BI Conference is currently being held through October 8<sup>th<\/sup> in Seattle, WA. To learn more about the BI Conference, click here: <a href=\"http:\/\/www.microsoft.com\/bi\/conference\/\">www.microsoft.com\/bi\/conference\/<\/a>.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>The Washington State Convention &amp; Trade Center in Seattle is buzzing today as Microsoft kicks off its second annual Business Intelligence Conference.<\/p>\n","protected":false},"author":1457,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","footnotes":""},"post_tag":[],"product":[],"content-type":[2433],"topic":[],"coauthors":[],"class_list":["post-6123","post","type-post","status-publish","format-standard","hentry","content-type-events"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SQL Server 2008 performs 1 trillion row query in seconds at BI Conference - Microsoft SQL Server Blog<\/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.microsoft.com\/en-us\/sql-server\/blog\/2008\/10\/06\/sql-server-2008-performs-1-trillion-row-query-in-seconds-at-bi-conference\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server 2008 performs 1 trillion row query in seconds at BI Conference - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"The Washington State Convention &amp; Trade Center in Seattle is buzzing today as Microsoft kicks off its second annual Business Intelligence Conference.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2008\/10\/06\/sql-server-2008-performs-1-trillion-row-query-in-seconds-at-bi-conference\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft SQL Server Blog\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/sqlserver\" \/>\n<meta property=\"article:published_time\" content=\"2008-10-07T00:05:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-23T06:51:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/Madison_thumb.jpg\" \/>\n<meta name=\"author\" content=\"SQL Server Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:site\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"SQL Server Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 min read\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2008\/10\/06\/sql-server-2008-performs-1-trillion-row-query-in-seconds-at-bi-conference\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2008\/10\/06\/sql-server-2008-performs-1-trillion-row-query-in-seconds-at-bi-conference\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/\",\"@type\":\"Person\",\"@name\":\"SQL Server Team\"}],\"headline\":\"SQL Server 2008 performs 1 trillion row query in seconds at BI Conference\",\"datePublished\":\"2008-10-07T00:05:00+00:00\",\"dateModified\":\"2024-01-23T06:51:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2008\/10\/06\/sql-server-2008-performs-1-trillion-row-query-in-seconds-at-bi-conference\/\"},\"wordCount\":361,\"commentCount\":5,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2008\/10\/06\/sql-server-2008-performs-1-trillion-row-query-in-seconds-at-bi-conference\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/Madison_thumb.jpg\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2008\/10\/06\/sql-server-2008-performs-1-trillion-row-query-in-seconds-at-bi-conference\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2008\/10\/06\/sql-server-2008-performs-1-trillion-row-query-in-seconds-at-bi-conference\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2008\/10\/06\/sql-server-2008-performs-1-trillion-row-query-in-seconds-at-bi-conference\/\",\"name\":\"SQL Server 2008 performs 1 trillion row query in seconds at BI Conference - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2008\/10\/06\/sql-server-2008-performs-1-trillion-row-query-in-seconds-at-bi-conference\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2008\/10\/06\/sql-server-2008-performs-1-trillion-row-query-in-seconds-at-bi-conference\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/Madison_thumb.jpg\",\"datePublished\":\"2008-10-07T00:05:00+00:00\",\"dateModified\":\"2024-01-23T06:51:42+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2008\/10\/06\/sql-server-2008-performs-1-trillion-row-query-in-seconds-at-bi-conference\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2008\/10\/06\/sql-server-2008-performs-1-trillion-row-query-in-seconds-at-bi-conference\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2008\/10\/06\/sql-server-2008-performs-1-trillion-row-query-in-seconds-at-bi-conference\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/Madison_thumb.jpg\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/Madison_thumb.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2008\/10\/06\/sql-server-2008-performs-1-trillion-row-query-in-seconds-at-bi-conference\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server 2008 performs 1 trillion row query in seconds at BI Conference\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"name\":\"Microsoft SQL Server Blog\",\"description\":\"Official News from Microsoft\u2019s Information Platform\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\",\"name\":\"Microsoft SQL Server Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"width\":259,\"height\":194,\"caption\":\"Microsoft SQL Server Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"http:\/\/www.facebook.com\/sqlserver\",\"https:\/\/x.com\/SQLServer\",\"https:\/\/www.youtube.com\/user\/MSCloudOS\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Server 2008 performs 1 trillion row query in seconds at BI Conference - Microsoft SQL Server Blog","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.microsoft.com\/en-us\/sql-server\/blog\/2008\/10\/06\/sql-server-2008-performs-1-trillion-row-query-in-seconds-at-bi-conference\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server 2008 performs 1 trillion row query in seconds at BI Conference - Microsoft SQL Server Blog","og_description":"The Washington State Convention &amp; Trade Center in Seattle is buzzing today as Microsoft kicks off its second annual Business Intelligence Conference.","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2008\/10\/06\/sql-server-2008-performs-1-trillion-row-query-in-seconds-at-bi-conference\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2008-10-07T00:05:00+00:00","article_modified_time":"2024-01-23T06:51:42+00:00","og_image":[{"url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/Madison_thumb.jpg","type":"","width":"","height":""}],"author":"SQL Server Team","twitter_card":"summary_large_image","twitter_creator":"@SQLServer","twitter_site":"@SQLServer","twitter_misc":{"Written by":"SQL Server Team","Est. reading time":"1 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2008\/10\/06\/sql-server-2008-performs-1-trillion-row-query-in-seconds-at-bi-conference\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2008\/10\/06\/sql-server-2008-performs-1-trillion-row-query-in-seconds-at-bi-conference\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/","@type":"Person","@name":"SQL Server Team"}],"headline":"SQL Server 2008 performs 1 trillion row query in seconds at BI Conference","datePublished":"2008-10-07T00:05:00+00:00","dateModified":"2024-01-23T06:51:42+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2008\/10\/06\/sql-server-2008-performs-1-trillion-row-query-in-seconds-at-bi-conference\/"},"wordCount":361,"commentCount":5,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2008\/10\/06\/sql-server-2008-performs-1-trillion-row-query-in-seconds-at-bi-conference\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/Madison_thumb.jpg","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2008\/10\/06\/sql-server-2008-performs-1-trillion-row-query-in-seconds-at-bi-conference\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2008\/10\/06\/sql-server-2008-performs-1-trillion-row-query-in-seconds-at-bi-conference\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2008\/10\/06\/sql-server-2008-performs-1-trillion-row-query-in-seconds-at-bi-conference\/","name":"SQL Server 2008 performs 1 trillion row query in seconds at BI Conference - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2008\/10\/06\/sql-server-2008-performs-1-trillion-row-query-in-seconds-at-bi-conference\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2008\/10\/06\/sql-server-2008-performs-1-trillion-row-query-in-seconds-at-bi-conference\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/Madison_thumb.jpg","datePublished":"2008-10-07T00:05:00+00:00","dateModified":"2024-01-23T06:51:42+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2008\/10\/06\/sql-server-2008-performs-1-trillion-row-query-in-seconds-at-bi-conference\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2008\/10\/06\/sql-server-2008-performs-1-trillion-row-query-in-seconds-at-bi-conference\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2008\/10\/06\/sql-server-2008-performs-1-trillion-row-query-in-seconds-at-bi-conference\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/Madison_thumb.jpg","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/Madison_thumb.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2008\/10\/06\/sql-server-2008-performs-1-trillion-row-query-in-seconds-at-bi-conference\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server 2008 performs 1 trillion row query in seconds at BI Conference"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","name":"Microsoft SQL Server Blog","description":"Official News from Microsoft\u2019s Information Platform","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization","name":"Microsoft SQL Server Blog","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","width":259,"height":194,"caption":"Microsoft SQL Server Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/"},"sameAs":["http:\/\/www.facebook.com\/sqlserver","https:\/\/x.com\/SQLServer","https:\/\/www.youtube.com\/user\/MSCloudOS"]}]}},"msxcm_display_generated_audio":false,"msxcm_animated_featured_image":null,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/6123","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/users\/1457"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/comments?post=6123"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/6123\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=6123"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=6123"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=6123"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=6123"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=6123"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=6123"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}