{"id":749,"date":"2014-07-23T17:41:54","date_gmt":"2014-07-23T22:41:54","guid":{"rendered":"http:\/\/www.cognitiveinfo.com\/?p=749"},"modified":"2014-07-23T17:41:54","modified_gmt":"2014-07-23T22:41:54","slug":"sql-2014-columnstore-indexes","status":"publish","type":"post","link":"http:\/\/cognitiveinfo.com\/?p=749","title":{"rendered":"SQL 2014 ColumnStore Indexes"},"content":{"rendered":"<p><a href=\"http:\/\/www.cognitiveinfo.com\/wp-content\/uploads\/2014\/07\/2014-06-08TulsaSQL.jpg\"><img fetchpriority=\"high\" decoding=\"async\" class=\"alignleft size-medium wp-image-755\" style=\"margin: 5px 10px;\" alt=\"2014-06-08TulsaSQL\" src=\"http:\/\/www.cognitiveinfo.com\/wp-content\/uploads\/2014\/07\/2014-06-08TulsaSQL-300x225.jpg\" width=\"300\" height=\"225\" \/><\/a>Recently I was invited to speak at Oklahoma City SQL User Group and Tulsa SQL User Groups about the advancements available in SQL 2014 with Columnstore Indexes.<\/p>\n<p>ColumnStore indexes were first introduced as xVelocity with SQL 2012 as a way to improve query performance against large data sets by grouping and storing columns of data instead of rows.\u00a0 With SQL 2014, those ColumnStore indexes become\u00a0update-able.\u00a0\u00a0 In this session, we review the difference in ColumnStore indexes, implementing ColumnStore indexes\u00a0Clustered and Non-Clustered and monitor performance.<\/p>\n<div dir=\"ltr\" id=\"yui_3_13_0_1_1397054384740_15839\">\n<div id=\"yui_3_13_0_1_1397054384740_15929\">Allen is\u00a0a Microsoft Certified Technology Specialist with certification in Business Intelligence Development and Maintenance. His\u00a0IT specialties include database administration, business intelligence and medical imaging services. \u00a0He has designed and developed business solutions with the IBM Cognos and Microsoft SQL Server Business Intelligence platforms since 1999.<\/div>\n<\/div>\n<p><strong>Subscribe to Download Presentation and Sample Files:<\/strong><\/p>\n<p>[email-download download_id=&#8221;750&#8243; contact_form_id=&#8221;739&#8243;]<\/p>\n<p><em>Privacy Policy:\u00a0 I will never sell or share your data.\u00a0 When you sign up, I&#8217;ll send you a note when there is a new blog article about BI.\u00a0 Unsubscribe any time.<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"<p> In this session, we review the difference in ColumnStore indexes, implementing ColumnStore indexes Clustered and Non-Clustered and monitor performance.<\/p>\n","protected":false},"author":2,"featured_media":755,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[49,73,91],"class_list":["post-749","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-microsoftsql","tag-download","tag-presentation","tag-sql"],"_links":{"self":[{"href":"http:\/\/cognitiveinfo.com\/index.php?rest_route=\/wp\/v2\/posts\/749","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/cognitiveinfo.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/cognitiveinfo.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/cognitiveinfo.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/cognitiveinfo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=749"}],"version-history":[{"count":0,"href":"http:\/\/cognitiveinfo.com\/index.php?rest_route=\/wp\/v2\/posts\/749\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/cognitiveinfo.com\/index.php?rest_route=\/"}],"wp:attachment":[{"href":"http:\/\/cognitiveinfo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=749"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/cognitiveinfo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=749"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/cognitiveinfo.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=749"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}