{"id":3505,"date":"2013-12-13T04:56:00","date_gmt":"2013-12-13T03:56:00","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-new-features-xvelocity-memory-optimized-columnstore-index\/"},"modified":"2013-12-13T04:56:00","modified_gmt":"2013-12-13T03:56:00","slug":"sql-server-2014-new-features-xvelocity-memory-optimized-columnstore-index","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-new-features-xvelocity-memory-optimized-columnstore-index\/","title":{"rendered":"SQL Server 2014 &#8211; New Features: xVelocity memory optimized columnstore index"},"content":{"rendered":"<p><img decoding=\"async\" class=\"blog-image aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/01\/2e1ax_default_entry_sqlserver2014.jpg\" alt=\"\" \/><\/p>\n<p>Some customers or colleagues recently asked me about the SQL Server concept xVelocity and in particular the SQL Server 2014 feature new xVelocity memory optimized columnstore index. So I decided to write a few words on the dbi services blog.<\/p>\n<h3><\/h3>\n<h3>What is xVelocity?<\/h3>\n<p>Introduced in SQL Server 2012, xVelocity is composed of two features:<\/p>\n<ul>\n<li>\u00a0<strong>xVelocity in-memory analytics engine<\/strong><\/li>\n<li><strong>\u00a0xVelocity memory-optimized columnstore index<\/strong><\/li>\n<\/ul>\n<h3>xVelocity in-memory analytics engine<\/h3>\n<p>The xVelocity in-memory analytics engine is an update of VertiPaq &#8211; introduced in SQL Server 2008 R2.<br \/>\nVertiPaq is composed of PowerPivot for Excel 2010 and PowerPivot for SharePoint 2010.<br \/>\nThe main goal is to achieve breakthrough performances in analytic queries.<br \/>\nTo achieve this aim, the engine uses columnar storage, state-of-the-art compression, in-memory caching, and highly parallel data scanning and aggregation algorithms.<\/p>\n<p>Since SQL server 2012, this feature supports Business Intelligence (BI) &#8211; self-service (PowerPivot) and corporate (tabular mode in SSAS).<br \/>\nIn the first case with BI self-service, an employee in a company can directly use PowerPivot for Excel to integrate data from different data sources.<br \/>\nIn the second case with BI corporate, BI developers or\/and IT Pros can use SSDT (SQL Server Data Tools) to create Analysis Services Tabular projects and deploy them on a server so that users can interact with the consolidated Data via Excel and Power View.<\/p>\n<h3>XVelocity memory-optimized columnstore index<\/h3>\n<p>xVelocity memory-optimized columnstore index is a feature which enables high performance query processing especially in Data Warehouses and Data Marts.<\/p>\n<p>Unlike &#8220;Standard&#8221; indexes, columnstore indexes store data in memory (as the name memory-optimized columnstore index suggests) and the storage organization is not row-oriented.<\/p>\n<p>The characteristic is that data is stored column-wise in compressed form. In SQL Server 2012, the first step was very limited and the main problema is that we cannot UPDATE or INSERT in a table with Columnstore Index.<\/p>\n<p>For example, to update a table with columnstore index, the way is to drop the columnstore index, perform the update operation and then rebuild the index &#8230; which is not fun at all!<img decoding=\"async\" title=\"Cry\" src=\":cry:\" alt=\"Cry\" border=\"0\" \/><\/p>\n<p>Now, in SQL Server 2014, this is possible without dropping the index.:-D<\/p>\n<h3>How is it possible?<\/h3>\n<p>A new concept \/ term is introduce in SQL Server 2014 for columnstore: The deltastore.<\/p>\n<p>Deltafile is introduced with the In-Memory OLTP feature and deltastore with the columnstore index.<br \/>\nYes, SQL Server 2014 is a real delta force!:-D<\/p>\n<p>The best way to define it is to give you the MSDN definition:<br \/>\n&#8220;A deltastore is a row-store table that holds rows until the number of rows is large enough to be moved into the columnstore.&#8221;<br \/>\nThey are other similitudes with the in-memory OLTP feature &#8211; let&#8217;s explain this.<\/p>\n<h3>Insert process<\/h3>\n<p>SQL Server inserts rows into the deltastore.<br \/>\nRows accumulated in the deltastore are stored in rowgroups. Each rowgroup holds from 102,400 to 1,048,576 rows.<br \/>\nWhen the maximum number of rows in the rowgroup is reached, this rowgroup is marked as &#8220;CLOSED&#8221;.<br \/>\nThe &#8220;tuple-mover&#8221;, a background process finds the closed rowgroup and moves it into the columnstore.<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"InsertProcess_ColumnstoreIndex.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/88\/InsertProcess_ColumnstoreIndex.jpg\"><img decoding=\"async\" style=\"display: block; margin-left: auto; margin-right: auto;\" title=\"b2ap3_thumbnail_InsertProcess_ColumnstoreIndex.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_InsertProcess_ColumnstoreIndex.jpg\" alt=\"b2ap3_thumbnail_InsertProcess_ColumnstoreIndex.jpg\" \/><\/a><\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"tips.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/tips.png\"><img loading=\"lazy\" decoding=\"async\" title=\"tips.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/tips.png\" alt=\"tips.png\" width=\"20\" height=\"20\" \/><\/a> <em>A SELECT query is an addition between non-closed\u00a0rowgroups in the deltastore and the columnstore.<\/em><\/p>\n<h3>Delete process<\/h3>\n<p>To delete a row, there are 2 cases:<\/p>\n<ul>\n<li>In the columnstore, the row is marked logically as deleted, but not physically deleted. A rebuild is necessary to definitively\u00a0delete the row.<\/li>\n<li>In the deltastore, the row is really deleted logically and physically.<\/li>\n<\/ul>\n<h3>Update process<\/h3>\n<p>To update a row, we have 2 cases &#8211; just like for the delete process:<\/p>\n<ul>\n<li>In the columnstore, the process is a delete process and an insert process like for the In-Memory OLTP process&#8230;<\/li>\n<li>In the deltastore, the row is just updated<\/li>\n<\/ul>\n<p><a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/gg492088(v=sql.120).aspx\">Here<\/a>\u00a0is the MSDN reference for more information.<\/p>\n<h3>Type of Columnstore Index<\/h3>\n<p>The SQL Server 2014 xVelocity memory optimized columnstore index is composed of two index types:<\/p>\n<ul>\n<li><strong>Clustered columnstore index<\/strong><\/li>\n<li><strong>Non-Clustered columnstore index<\/strong><\/li>\n<\/ul>\n<h3>Clustered Columnstore index<\/h3>\n<p>Clustered Columnstore index is used for query performance and data compression.<\/p>\n<p>Be careful, a table with a clustered columnstore index cannot have another index. You have two ways to create an index:<\/p>\n<ul>\n<li>using a GUI<\/li>\n<\/ul>\n<p>Select the database, go to the index menu, right-click and select create index and create Clustered Columnstore index:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"Untitled.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Untitled.png\"><img decoding=\"async\" title=\"Untitled.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Untitled.png\" alt=\"Untitled.png\" \/><\/a><\/p>\n<p>You can see if you can create the index or not:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"ColumnstoreIndexCreation01.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/88\/ColumnstoreIndexCreation01.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_ColumnstoreIndexCreation01.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_ColumnstoreIndexCreation01.jpg\" alt=\"b2ap3_thumbnail_ColumnstoreIndexCreation01.jpg\" \/><\/a><\/p>\n<p>Before the creation of the index, you must delete the others:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"ColumnstoreIndexCreation02.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/88\/ColumnstoreIndexCreation02.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_ColumnstoreIndexCreation02.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_ColumnstoreIndexCreation02.jpg\" alt=\"b2ap3_thumbnail_ColumnstoreIndexCreation02.jpg\" \/><\/a><\/p>\n<p>Now, you can create the index:<\/p>\n<ul>\n<li>using script<\/li>\n<\/ul>\n<p><a class=\"easyblog-thumb-preview\" title=\"ColumnstoreIndexCreationScript04.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/88\/ColumnstoreIndexCreationScript04.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_ColumnstoreIndexCreationScript04.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_ColumnstoreIndexCreationScript04.jpg\" alt=\"b2ap3_thumbnail_ColumnstoreIndexCreationScript04.jpg\" \/><\/a><\/p>\n<h3>Non-Clustered Columnstore index<\/h3>\n<p>This is the &#8220;old&#8221; columnstore index introduced in SQL server 2012.<\/p>\n<p>Like for the clustered columnstore index, you have two ways to create the index:<\/p>\n<ul>\n<li>using GUI<\/li>\n<\/ul>\n<p>Select the database, go to index menu, right-click and select Create index and create Non-Clustered Columnstore index.<br \/>\nYou can see if you can create the index or not:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"ColumnstoreIndexCreationNonClustered01.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/88\/ColumnstoreIndexCreationNonClustered01.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_ColumnstoreIndexCreationNonClustered01.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_ColumnstoreIndexCreationNonClustered01.jpg\" alt=\"b2ap3_thumbnail_ColumnstoreIndexCreationNonClustered01.jpg\" \/><\/a><\/p>\n<p>Prior to the creation of the index, you must select columns.<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"ColumnstoreIndexCreationNonClustered02.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/88\/ColumnstoreIndexCreationNonClustered02.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_ColumnstoreIndexCreationNonClustered02.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_ColumnstoreIndexCreationNonClustered02.jpg\" alt=\"b2ap3_thumbnail_ColumnstoreIndexCreationNonClustered02.jpg\" \/><\/a><\/p>\n<p>And you must delete your previous Clustered Columnstore index:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"ColumnstoreIndexCreationNonClustered03.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/88\/ColumnstoreIndexCreationNonClustered03.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_ColumnstoreIndexCreationNonClustered03.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_ColumnstoreIndexCreationNonClustered03.jpg\" alt=\"b2ap3_thumbnail_ColumnstoreIndexCreationNonClustered03.jpg\" \/><\/a><\/p>\n<p>Now, you can create the index:<\/p>\n<ul>\n<li>using script<\/li>\n<\/ul>\n<p><a class=\"easyblog-thumb-preview\" title=\"ColumnstoreIndexCreationScriptNonClustered01.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/88\/ColumnstoreIndexCreationScriptNonClustered01.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_ColumnstoreIndexCreationScriptNonClustered01.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_ColumnstoreIndexCreationScriptNonClustered01.jpg\" alt=\"b2ap3_thumbnail_ColumnstoreIndexCreationScriptNonClustered01.jpg\" \/><\/a><\/p>\n<h3>What are benefits of this new xVelocity memory optimized columnstore index?<\/h3>\n<p>Making the columnstore index more functional, we can say that the main benefit is this new clustered columnstore index with the ability to continue queries during the updating process without the need to drop and recreate the index.<\/p>\n<p>In my opinion, xVelocity is a very interesting technologies for my customers!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Some customers or colleagues recently asked me about the SQL Server concept xVelocity and in particular the SQL Server 2014 feature new xVelocity memory optimized columnstore index. So I decided to write a few words on the dbi services blog. What is xVelocity? Introduced in SQL Server 2012, xVelocity is composed of two features: \u00a0xVelocity [&hellip;]<\/p>\n","protected":false},"author":15,"featured_media":24,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[197],"tags":[222,49,51,54,52],"type_dbi":[],"class_list":["post-3505","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-application-integration-middleware","tag-in-memory","tag-microsoft","tag-sql-server","tag-sql-server-2012","tag-sql-server-2014"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.5) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>SQL Server 2014 - New Features: xVelocity memory optimized columnstore index - dbi Blog<\/title>\n<meta name=\"description\" content=\"Some customers or colleagues recently asked me about the SQL Server concept xVelocity and in particular the SQL Server 2014 feature new xVelocity memory optimized columnstore index. So I decided to write a few words on the dbi services blog.\" \/>\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.dbi-services.com\/blog\/sql-server-2014-new-features-xvelocity-memory-optimized-columnstore-index\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server 2014 - New Features: xVelocity memory optimized columnstore index\" \/>\n<meta property=\"og:description\" content=\"Some customers or colleagues recently asked me about the SQL Server concept xVelocity and in particular the SQL Server 2014 feature new xVelocity memory optimized columnstore index. So I decided to write a few words on the dbi services blog.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-new-features-xvelocity-memory-optimized-columnstore-index\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2013-12-13T03:56:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/01\/2e1ax_default_entry_sqlserver2014.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"245\" \/>\n\t<meta property=\"og:image:height\" content=\"149\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"St\u00e9phane Haby\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"St\u00e9phane Haby\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2014-new-features-xvelocity-memory-optimized-columnstore-index\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2014-new-features-xvelocity-memory-optimized-columnstore-index\\\/\"},\"author\":{\"name\":\"St\u00e9phane Haby\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/d0bfb7484ae81c8980fc2b11334f803b\"},\"headline\":\"SQL Server 2014 &#8211; New Features: xVelocity memory optimized columnstore index\",\"datePublished\":\"2013-12-13T03:56:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2014-new-features-xvelocity-memory-optimized-columnstore-index\\\/\"},\"wordCount\":861,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2014-new-features-xvelocity-memory-optimized-columnstore-index\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/01\\\/2e1ax_default_entry_sqlserver2014.jpg\",\"keywords\":[\"In-memory\",\"Microsoft\",\"SQL Server\",\"SQL Server 2012\",\"SQL Server 2014\"],\"articleSection\":[\"Application integration &amp; Middleware\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2014-new-features-xvelocity-memory-optimized-columnstore-index\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2014-new-features-xvelocity-memory-optimized-columnstore-index\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2014-new-features-xvelocity-memory-optimized-columnstore-index\\\/\",\"name\":\"SQL Server 2014 - New Features: xVelocity memory optimized columnstore index - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2014-new-features-xvelocity-memory-optimized-columnstore-index\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2014-new-features-xvelocity-memory-optimized-columnstore-index\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/01\\\/2e1ax_default_entry_sqlserver2014.jpg\",\"datePublished\":\"2013-12-13T03:56:00+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/d0bfb7484ae81c8980fc2b11334f803b\"},\"description\":\"Some customers or colleagues recently asked me about the SQL Server concept xVelocity and in particular the SQL Server 2014 feature new xVelocity memory optimized columnstore index. So I decided to write a few words on the dbi services blog.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2014-new-features-xvelocity-memory-optimized-columnstore-index\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2014-new-features-xvelocity-memory-optimized-columnstore-index\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2014-new-features-xvelocity-memory-optimized-columnstore-index\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/01\\\/2e1ax_default_entry_sqlserver2014.jpg\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/01\\\/2e1ax_default_entry_sqlserver2014.jpg\",\"width\":245,\"height\":149},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2014-new-features-xvelocity-memory-optimized-columnstore-index\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server 2014 &#8211; New Features: xVelocity memory optimized columnstore index\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/d0bfb7484ae81c8980fc2b11334f803b\",\"name\":\"St\u00e9phane Haby\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"caption\":\"St\u00e9phane Haby\"},\"description\":\"St\u00e9phane Haby has more than ten years of experience in Microsoft solutions. He is specialized in SQL Server technologies such as installation, migration, best practices, and performance analysis etc. He is also an expert in Microsoft Business Intelligence solutions such as SharePoint, SQL Server and Office. Futhermore, he has many years of .NET development experience in the banking sector and other industries. In France, he was one of the first people to have worked with Microsoft Team System. He has written several technical articles on this subject. St\u00e9phane Haby is Microsoft Most Valuable Professional (MVP) as well as Microsoft Certified Solutions Associate (MCSA) and\u00a0Microsoft Certified Solutions Expert (MCSE) for SQL Server 2012. He is also Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) for SQL Server 2008 as well as ITIL Foundation V3 certified. He holds a Engineer diploma in industrial computing and automation from France. His branch-related experience covers Chemicals &amp; Pharmaceuticals, Banking \\\/ Financial Services, and many other industries.\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/stephane-haby\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL Server 2014 - New Features: xVelocity memory optimized columnstore index - dbi Blog","description":"Some customers or colleagues recently asked me about the SQL Server concept xVelocity and in particular the SQL Server 2014 feature new xVelocity memory optimized columnstore index. So I decided to write a few words on the dbi services 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.dbi-services.com\/blog\/sql-server-2014-new-features-xvelocity-memory-optimized-columnstore-index\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server 2014 - New Features: xVelocity memory optimized columnstore index","og_description":"Some customers or colleagues recently asked me about the SQL Server concept xVelocity and in particular the SQL Server 2014 feature new xVelocity memory optimized columnstore index. So I decided to write a few words on the dbi services blog.","og_url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-new-features-xvelocity-memory-optimized-columnstore-index\/","og_site_name":"dbi Blog","article_published_time":"2013-12-13T03:56:00+00:00","og_image":[{"width":245,"height":149,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/01\/2e1ax_default_entry_sqlserver2014.jpg","type":"image\/jpeg"}],"author":"St\u00e9phane Haby","twitter_card":"summary_large_image","twitter_misc":{"Written by":"St\u00e9phane Haby","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-new-features-xvelocity-memory-optimized-columnstore-index\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-new-features-xvelocity-memory-optimized-columnstore-index\/"},"author":{"name":"St\u00e9phane Haby","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"headline":"SQL Server 2014 &#8211; New Features: xVelocity memory optimized columnstore index","datePublished":"2013-12-13T03:56:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-new-features-xvelocity-memory-optimized-columnstore-index\/"},"wordCount":861,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-new-features-xvelocity-memory-optimized-columnstore-index\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/01\/2e1ax_default_entry_sqlserver2014.jpg","keywords":["In-memory","Microsoft","SQL Server","SQL Server 2012","SQL Server 2014"],"articleSection":["Application integration &amp; Middleware"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2014-new-features-xvelocity-memory-optimized-columnstore-index\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-new-features-xvelocity-memory-optimized-columnstore-index\/","url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-new-features-xvelocity-memory-optimized-columnstore-index\/","name":"SQL Server 2014 - New Features: xVelocity memory optimized columnstore index - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-new-features-xvelocity-memory-optimized-columnstore-index\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-new-features-xvelocity-memory-optimized-columnstore-index\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/01\/2e1ax_default_entry_sqlserver2014.jpg","datePublished":"2013-12-13T03:56:00+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"description":"Some customers or colleagues recently asked me about the SQL Server concept xVelocity and in particular the SQL Server 2014 feature new xVelocity memory optimized columnstore index. So I decided to write a few words on the dbi services blog.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-new-features-xvelocity-memory-optimized-columnstore-index\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2014-new-features-xvelocity-memory-optimized-columnstore-index\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-new-features-xvelocity-memory-optimized-columnstore-index\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/01\/2e1ax_default_entry_sqlserver2014.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/01\/2e1ax_default_entry_sqlserver2014.jpg","width":245,"height":149},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-new-features-xvelocity-memory-optimized-columnstore-index\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server 2014 &#8211; New Features: xVelocity memory optimized columnstore index"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b","name":"St\u00e9phane Haby","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","caption":"St\u00e9phane Haby"},"description":"St\u00e9phane Haby has more than ten years of experience in Microsoft solutions. He is specialized in SQL Server technologies such as installation, migration, best practices, and performance analysis etc. He is also an expert in Microsoft Business Intelligence solutions such as SharePoint, SQL Server and Office. Futhermore, he has many years of .NET development experience in the banking sector and other industries. In France, he was one of the first people to have worked with Microsoft Team System. He has written several technical articles on this subject. St\u00e9phane Haby is Microsoft Most Valuable Professional (MVP) as well as Microsoft Certified Solutions Associate (MCSA) and\u00a0Microsoft Certified Solutions Expert (MCSE) for SQL Server 2012. He is also Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) for SQL Server 2008 as well as ITIL Foundation V3 certified. He holds a Engineer diploma in industrial computing and automation from France. His branch-related experience covers Chemicals &amp; Pharmaceuticals, Banking \/ Financial Services, and many other industries.","url":"https:\/\/www.dbi-services.com\/blog\/author\/stephane-haby\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/3505","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/15"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=3505"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/3505\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/24"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=3505"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=3505"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=3505"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=3505"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}