{"id":3403,"date":"2012-06-14T06:00:00","date_gmt":"2012-06-14T13:00:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2012\/06\/14\/hy-vee-boosts-performance-by-up-to-100x-increases-competitiveness-with-parallel-data-warehouse-deployment\/"},"modified":"2024-01-22T22:49:40","modified_gmt":"2024-01-23T06:49:40","slug":"hy-vee-boosts-performance-by-up-to-100x-increases-competitiveness-with-parallel-data-warehouse-deployment","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/06\/14\/hy-vee-boosts-performance-by-up-to-100x-increases-competitiveness-with-parallel-data-warehouse-deployment\/","title":{"rendered":"Hy-Vee boosts performance by up to 100X, increases competitiveness with Parallel Data Warehouse deployment"},"content":{"rendered":"

We\u2019ve recently been talking about what goes on behind the scenes with SQL Server. While we love to share stories about the nuts and bolts of what we do, our favorite stories are those showing how customers are using our technology to tackle business challenges and achieve their goals. A great example is <\/font>Hy-Vee<\/font><\/a>, one of our newest Parallel Data Warehouse (PDW) customers. <\/font><\/p>\n

Hy-Vee is a Top-25 grocery retail chain listed among the 50 largest private companies in the US. To get an edge on its competitors, Hy-Vee analyzes all of its shopper purchase data every morning to pick the most effective in-store specials for that day. <\/font><\/p>\n

Unfortunately, the amount of data Hy-Vee was handling — two years\u2019 worth, with 800,000 rows being added daily \u2013 couldn\u2019t always be analyzed in time for employees to review the results when creating new promotions. And, Hy-Vee realized it could get better insight on customers (and therefore design more effective promotions) if employees were looking at trends from seven years of customer data, instead of just two years\u2019 worth. Since processing data on time was already an issue, the company recognized it needed a data warehouse solution with more capacity. <\/font><\/p>\n

To meet the challenge, Hy-Vee turned to SQL Server 2008 R2 PDW on HP Hardware. Hy-Vee developed a solution that scales up to hundreds of terabytes of data, and increases query performance by up to 100X. Hy-Vee can now consistently deliver reports each morning early enough to inform the decisions that each store makes about the specials for the day. The increased reporting speed also means employees can run new queries against data captured just the day before, providing an even deeper level of analysis on shoppers and store-specific items. In addition, Hy-Vee was able to take advantage of Premier Mission Critical Support from Microsoft Support, with HP and Microsoft working together to ensure Hy-Vee had around-the-clock problem resolution and a single number to call for questions about HP and Microsoft Solutions. <\/font><\/p>\n

According to the assistant vice president of Hy-Vee, their PDW solution helps them recognize changes in customers\u2019 buying habits, giving them a competitive edge and a huge business advantage to boot. <\/font><\/p>\n

In addition, with PDW, Hy-Vee can make data-driven decisions more quickly, providing the company with the agility it needs to stay ahead of the competition. That\u2019s the kind of success story we\u2019re proud to be a part of!<\/font><\/p>\n

For more information about Hy-Vee\u2019s solution, check out the <\/font>case study<\/font><\/a>.<\/font><\/p>\n","protected":false},"excerpt":{"rendered":"

We\u2019ve recently been talking about what goes on behind the scenes with SQL Server. While we love to share stories about the nuts and bolts of what we do, our favorite stories are those showing how customers are using our technology to tackle business challenges and achieve their goals.<\/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":[2445],"topic":[],"coauthors":[2487],"class_list":["post-3403","post","type-post","status-publish","format-standard","hentry","content-type-thought-leadership"],"yoast_head":"\nHy-Vee boosts performance by up to 100X, increases competitiveness with Parallel Data Warehouse deployment - 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\/2012\/06\/14\/hy-vee-boosts-performance-by-up-to-100x-increases-competitiveness-with-parallel-data-warehouse-deployment\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Hy-Vee boosts performance by up to 100X, increases competitiveness with Parallel Data Warehouse deployment - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"We\u2019ve recently been talking about what goes on behind the scenes with SQL Server. While we love to share stories about the nuts and bolts of what we do, our favorite stories are those showing how customers are using our technology to tackle business challenges and achieve their goals.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/06\/14\/hy-vee-boosts-performance-by-up-to-100x-increases-competitiveness-with-parallel-data-warehouse-deployment\/\" \/>\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=\"2012-06-14T13:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-23T06:49:40+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/08\/cropped-microsoft_logo_element.png\" \/>\n\t<meta property=\"og:image:width\" content=\"512\" \/>\n\t<meta property=\"og:image:height\" content=\"512\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\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=\"2 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\/2012\/06\/14\/hy-vee-boosts-performance-by-up-to-100x-increases-competitiveness-with-parallel-data-warehouse-deployment\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/06\/14\/hy-vee-boosts-performance-by-up-to-100x-increases-competitiveness-with-parallel-data-warehouse-deployment\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/\",\"@type\":\"Person\",\"@name\":\"SQL Server Team\"}],\"headline\":\"Hy-Vee boosts performance by up to 100X, increases competitiveness with Parallel Data Warehouse deployment\",\"datePublished\":\"2012-06-14T13:00:00+00:00\",\"dateModified\":\"2024-01-23T06:49:40+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/06\/14\/hy-vee-boosts-performance-by-up-to-100x-increases-competitiveness-with-parallel-data-warehouse-deployment\/\"},\"wordCount\":424,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/06\/14\/hy-vee-boosts-performance-by-up-to-100x-increases-competitiveness-with-parallel-data-warehouse-deployment\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/06\/14\/hy-vee-boosts-performance-by-up-to-100x-increases-competitiveness-with-parallel-data-warehouse-deployment\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/06\/14\/hy-vee-boosts-performance-by-up-to-100x-increases-competitiveness-with-parallel-data-warehouse-deployment\/\",\"name\":\"Hy-Vee boosts performance by up to 100X, increases competitiveness with Parallel Data Warehouse deployment - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\"},\"datePublished\":\"2012-06-14T13:00:00+00:00\",\"dateModified\":\"2024-01-23T06:49:40+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/06\/14\/hy-vee-boosts-performance-by-up-to-100x-increases-competitiveness-with-parallel-data-warehouse-deployment\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/06\/14\/hy-vee-boosts-performance-by-up-to-100x-increases-competitiveness-with-parallel-data-warehouse-deployment\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/06\/14\/hy-vee-boosts-performance-by-up-to-100x-increases-competitiveness-with-parallel-data-warehouse-deployment\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hy-Vee boosts performance by up to 100X, increases competitiveness with Parallel Data Warehouse deployment\"}]},{\"@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":"Hy-Vee boosts performance by up to 100X, increases competitiveness with Parallel Data Warehouse deployment - 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\/2012\/06\/14\/hy-vee-boosts-performance-by-up-to-100x-increases-competitiveness-with-parallel-data-warehouse-deployment\/","og_locale":"en_US","og_type":"article","og_title":"Hy-Vee boosts performance by up to 100X, increases competitiveness with Parallel Data Warehouse deployment - Microsoft SQL Server Blog","og_description":"We\u2019ve recently been talking about what goes on behind the scenes with SQL Server. While we love to share stories about the nuts and bolts of what we do, our favorite stories are those showing how customers are using our technology to tackle business challenges and achieve their goals.","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/06\/14\/hy-vee-boosts-performance-by-up-to-100x-increases-competitiveness-with-parallel-data-warehouse-deployment\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2012-06-14T13:00:00+00:00","article_modified_time":"2024-01-23T06:49:40+00:00","og_image":[{"width":512,"height":512,"url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/08\/cropped-microsoft_logo_element.png","type":"image\/png"}],"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":"2 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/06\/14\/hy-vee-boosts-performance-by-up-to-100x-increases-competitiveness-with-parallel-data-warehouse-deployment\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/06\/14\/hy-vee-boosts-performance-by-up-to-100x-increases-competitiveness-with-parallel-data-warehouse-deployment\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/","@type":"Person","@name":"SQL Server Team"}],"headline":"Hy-Vee boosts performance by up to 100X, increases competitiveness with Parallel Data Warehouse deployment","datePublished":"2012-06-14T13:00:00+00:00","dateModified":"2024-01-23T06:49:40+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/06\/14\/hy-vee-boosts-performance-by-up-to-100x-increases-competitiveness-with-parallel-data-warehouse-deployment\/"},"wordCount":424,"commentCount":0,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/06\/14\/hy-vee-boosts-performance-by-up-to-100x-increases-competitiveness-with-parallel-data-warehouse-deployment\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/06\/14\/hy-vee-boosts-performance-by-up-to-100x-increases-competitiveness-with-parallel-data-warehouse-deployment\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/06\/14\/hy-vee-boosts-performance-by-up-to-100x-increases-competitiveness-with-parallel-data-warehouse-deployment\/","name":"Hy-Vee boosts performance by up to 100X, increases competitiveness with Parallel Data Warehouse deployment - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"datePublished":"2012-06-14T13:00:00+00:00","dateModified":"2024-01-23T06:49:40+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/06\/14\/hy-vee-boosts-performance-by-up-to-100x-increases-competitiveness-with-parallel-data-warehouse-deployment\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/06\/14\/hy-vee-boosts-performance-by-up-to-100x-increases-competitiveness-with-parallel-data-warehouse-deployment\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/06\/14\/hy-vee-boosts-performance-by-up-to-100x-increases-competitiveness-with-parallel-data-warehouse-deployment\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"Hy-Vee boosts performance by up to 100X, increases competitiveness with Parallel Data Warehouse deployment"}]},{"@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\/3403","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=3403"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/3403\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=3403"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=3403"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=3403"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=3403"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=3403"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=3403"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}