{"id":8094,"date":"2019-01-17T13:46:45","date_gmt":"2019-01-17T13:46:45","guid":{"rendered":"https:\/\/dbtut.com\/?p=8094"},"modified":"2019-01-17T13:46:45","modified_gmt":"2019-01-17T13:46:45","slug":"sql-2017-in-memory-table","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/sql-2017-in-memory-table\/","title":{"rendered":"SQL 2017 In-Memory Table"},"content":{"rendered":"<p>Hello there,<\/p>\n<p>In-Memory concept, which was first introduced into our lives with SQL 2014, was made more useful and compatible with SQL 2017.<br \/>\nIn this article I will describe how to convert existing tables into an in-memory table.<br \/>\nDatabase Compatibility Level control is done first and SQL 2017 (140) must be selected.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium\" src=\"https:\/\/i2.wp.com\/suleymankas.com\/wp-content\/uploads\/2018\/10\/1-3.png?w=671\" width=\"671\" height=\"593\" \/><\/p>\n<p>Then, to open the In-Memory feature on a database basis, we have to run the following script.<br \/>\nWe cannot open this setting from the SSMS interface, so we have to open it this way.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium\" src=\"https:\/\/i1.wp.com\/suleymankas.com\/wp-content\/uploads\/2018\/10\/2-2.png?w=603\" width=\"603\" height=\"21\" \/><\/p>\n<p>After making these adjustments, our database is ready to create the In-Memory table.<\/p>\n<p>When we click on any table and right click, we enter the Memory Optimization Advisor.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium\" src=\"https:\/\/i0.wp.com\/suleymankas.com\/wp-content\/uploads\/2018\/10\/1.png?w=414\" width=\"414\" height=\"681\" \/><\/p>\n<p>A wizard comes and we continue.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium\" src=\"https:\/\/i0.wp.com\/suleymankas.com\/wp-content\/uploads\/2018\/10\/2.png?resize=768%2C635\" width=\"768\" height=\"635\" \/><\/p>\n<p>Firstly, the In-Memory table should not be related to other tables.<br \/>\nFor this reason, the next step is the In-Memory compatibility of the table.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium\" src=\"https:\/\/i0.wp.com\/suleymankas.com\/wp-content\/uploads\/2018\/10\/3.png?resize=768%2C633\" width=\"768\" height=\"633\" \/><\/p>\n<p>This step specifies that we must consider these warnings before Memory optimization is performed.<\/p>\n<p>For example; The present procedure is as necessary to rebuild the functions.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium\" src=\"https:\/\/i0.wp.com\/suleymankas.com\/wp-content\/uploads\/2018\/10\/4.png?resize=768%2C642\" width=\"768\" height=\"642\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Then we come to the area where we will make basic In-Memory adjustments.<br \/>\nHere is a special file group for the in-memory table to create and save the disk space, file group name and a copy of the original state of the table are available.<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium\" src=\"https:\/\/i1.wp.com\/suleymankas.com\/wp-content\/uploads\/2018\/10\/5.png?resize=768%2C636\" width=\"768\" height=\"636\" \/><\/p>\n<p>Then the existing Primary Key or Index is converted to in-memory.<br \/>\nHash Index has also been added to the indexes created in the in-memory table to access the data faster.<br \/>\nAnother area determined here is the Bucket Count field. Currently, this field is specified by the number of records in the table and is usually specified to be twice the number of records in the table.<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium\" src=\"https:\/\/i0.wp.com\/suleymankas.com\/wp-content\/uploads\/2018\/10\/6.png?resize=768%2C634\" width=\"768\" height=\"634\" \/><\/p>\n<p>Finally, we say Migrate and start the In-Memory table conversion process.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium\" src=\"https:\/\/i0.wp.com\/suleymankas.com\/wp-content\/uploads\/2018\/10\/7.png?resize=768%2C634\" width=\"768\" height=\"634\" \/><\/p>\n<p>Here, the original table name is the name of the _old name and the new table is created with the current name as in-memory and the old table data is inserted into the new table.<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium\" src=\"https:\/\/i0.wp.com\/suleymankas.com\/wp-content\/uploads\/2018\/10\/8.png?resize=768%2C636\" width=\"768\" height=\"636\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/i2.wp.com\/suleymankas.com\/wp-content\/uploads\/2018\/10\/9.png?resize=313%2C147\" \/><\/p>\n<p id=\"QMvAIrS\">\n<p>You can do the same with T-SQL as below.<br \/>\nIt is also possible to set the Memory Optimization option to be open in both schema and data and to determine the number of Bucket Count of Hash Primary Key.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/i2.wp.com\/suleymankas.com\/wp-content\/uploads\/2018\/10\/10.png?resize=609%2C683\" \/><\/p>\n<p id=\"hXtBNHK\">We can follow the steps below to add a Columnstore Index and further improve our performance.<br \/>\nAt this point, I will give examples from different environments.<br \/>\nYou can add the Columnstore Index with the T-SQL code as follows and then add it through the original table and then use it in the In-Memory table.<\/p>\n<p>&nbsp;<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/i0.wp.com\/suleymankas.com\/wp-content\/uploads\/2018\/10\/11.png?resize=616%2C93\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/i1.wp.com\/suleymankas.com\/wp-content\/uploads\/2018\/10\/12.png?resize=549%2C288\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>In the index migration area, this time, we are questioning the usage status of the existing Columnstore Index.<\/p>\n<p>&nbsp;<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/i2.wp.com\/suleymankas.com\/wp-content\/uploads\/2018\/10\/14.png?resize=640%2C533\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>In the examples below, the effect of the same query on the system and the query result times are shared over the normal and In-Memory tables.<br \/>\nThe results show that especially the In-Memory table queries do not make any logical reads and the query result is 10 times faster.<br \/>\nI gave an example for a single query. When I get to experiment with various ad-hoc queries, I can say that the speed difference has really reached 10 times.<\/p>\n<p>&nbsp;<\/p>\n<p>In-Memory Table<\/p>\n<p>&nbsp;<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/i2.wp.com\/suleymankas.com\/wp-content\/uploads\/2018\/10\/555.png?resize=640%2C328\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Table<\/p>\n<p>&nbsp;<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/i0.wp.com\/suleymankas.com\/wp-content\/uploads\/2018\/10\/666.png?resize=640%2C323\" \/><\/p>\n<p id=\"YATIAQW\">\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_8094\" class=\"pvc_stats all  \" data-element-id=\"8094\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Hello there, In-Memory concept, which was first introduced into our lives with SQL 2014, was made more useful and compatible with SQL 2017. In this article I will describe how to convert existing tables into an in-memory table. Database Compatibility Level control is done first and SQL 2017 (140) must be selected. Then, to open &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_8094\" class=\"pvc_stats all  \" data-element-id=\"8094\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":398,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[3],"tags":[1684,1468,171,1550,1399,245,1683],"class_list":["post-8094","post","type-post","status-publish","format-standard","","category-mssql","tag-columnstoreindex","tag-in-memory","tag-index","tag-sql","tag-sql-server-2017","tag-sql-server-index","tag-sql2017"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":289,"today_views":0},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SQL 2017 In-Memory Table - Database Tutorials<\/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:\/\/dbtut.com\/index.php\/2019\/01\/17\/sql-2017-in-memory-table\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL 2017 In-Memory Table - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"Hello there, In-Memory concept, which was first introduced into our lives with SQL 2014, was made more useful and compatible with SQL 2017. In this article I will describe how to convert existing tables into an in-memory table. Database Compatibility Level control is done first and SQL 2017 (140) must be selected. Then, to open &hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/sql-2017-in-memory-table\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-01-17T13:46:45+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/i2.wp.com\/suleymankas.com\/wp-content\/uploads\/2018\/10\/1-3.png?w=671\" \/>\n<meta name=\"author\" content=\"S\u00fcleyman Ka\u015f\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"S\u00fcleyman Ka\u015f\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/sql-2017-in-memory-table\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/sql-2017-in-memory-table\/\"},\"author\":{\"name\":\"S\u00fcleyman Ka\u015f\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/590daafb086b3b7a2da2b24721b4c567\"},\"headline\":\"SQL 2017 In-Memory Table\",\"datePublished\":\"2019-01-17T13:46:45+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/sql-2017-in-memory-table\/\"},\"wordCount\":530,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/sql-2017-in-memory-table\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/i2.wp.com\/suleymankas.com\/wp-content\/uploads\/2018\/10\/1-3.png?w=671\",\"keywords\":[\"columnstoreindex\",\"In-Memory\",\"Index\",\"sql\",\"SQL SERVER 2017\",\"SQL Server Index\",\"sql2017\"],\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/sql-2017-in-memory-table\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/sql-2017-in-memory-table\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/sql-2017-in-memory-table\/\",\"name\":\"SQL 2017 In-Memory Table - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/sql-2017-in-memory-table\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/sql-2017-in-memory-table\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/i2.wp.com\/suleymankas.com\/wp-content\/uploads\/2018\/10\/1-3.png?w=671\",\"datePublished\":\"2019-01-17T13:46:45+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/sql-2017-in-memory-table\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/sql-2017-in-memory-table\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/sql-2017-in-memory-table\/#primaryimage\",\"url\":\"https:\/\/i2.wp.com\/suleymankas.com\/wp-content\/uploads\/2018\/10\/1-3.png?w=671\",\"contentUrl\":\"https:\/\/i2.wp.com\/suleymankas.com\/wp-content\/uploads\/2018\/10\/1-3.png?w=671\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/sql-2017-in-memory-table\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL 2017 In-Memory Table\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/590daafb086b3b7a2da2b24721b4c567\",\"name\":\"S\u00fcleyman Ka\u015f\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/0b09c3a506e893211d4d099ffc9a94bff3eebcac8bcad74c26ccdafe9f15df03?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/0b09c3a506e893211d4d099ffc9a94bff3eebcac8bcad74c26ccdafe9f15df03?s=96&d=mm&r=g\",\"caption\":\"S\u00fcleyman Ka\u015f\"},\"description\":\"I have been managing MS SQL database for 3 years. And I have been managing HANA DB for the last 1 years. I'm Microsoft Certified Professional. My competencies; - Database Administrator, - Database Management, - Database Technologies, - SAP BASIS, - System Management, - Data Analysis and Reporting\",\"sameAs\":[\"http:\/\/www.suleymankas.com\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/suleymankas\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL 2017 In-Memory Table - Database Tutorials","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:\/\/dbtut.com\/index.php\/2019\/01\/17\/sql-2017-in-memory-table\/","og_locale":"en_US","og_type":"article","og_title":"SQL 2017 In-Memory Table - Database Tutorials","og_description":"Hello there, In-Memory concept, which was first introduced into our lives with SQL 2014, was made more useful and compatible with SQL 2017. In this article I will describe how to convert existing tables into an in-memory table. Database Compatibility Level control is done first and SQL 2017 (140) must be selected. Then, to open &hellip;","og_url":"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/sql-2017-in-memory-table\/","og_site_name":"Database Tutorials","article_published_time":"2019-01-17T13:46:45+00:00","og_image":[{"url":"https:\/\/i2.wp.com\/suleymankas.com\/wp-content\/uploads\/2018\/10\/1-3.png?w=671","type":"","width":"","height":""}],"author":"S\u00fcleyman Ka\u015f","twitter_card":"summary_large_image","twitter_misc":{"Written by":"S\u00fcleyman Ka\u015f","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/sql-2017-in-memory-table\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/sql-2017-in-memory-table\/"},"author":{"name":"S\u00fcleyman Ka\u015f","@id":"https:\/\/dbtut.com\/#\/schema\/person\/590daafb086b3b7a2da2b24721b4c567"},"headline":"SQL 2017 In-Memory Table","datePublished":"2019-01-17T13:46:45+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/sql-2017-in-memory-table\/"},"wordCount":530,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/sql-2017-in-memory-table\/#primaryimage"},"thumbnailUrl":"https:\/\/i2.wp.com\/suleymankas.com\/wp-content\/uploads\/2018\/10\/1-3.png?w=671","keywords":["columnstoreindex","In-Memory","Index","sql","SQL SERVER 2017","SQL Server Index","sql2017"],"articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/01\/17\/sql-2017-in-memory-table\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/sql-2017-in-memory-table\/","url":"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/sql-2017-in-memory-table\/","name":"SQL 2017 In-Memory Table - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/sql-2017-in-memory-table\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/sql-2017-in-memory-table\/#primaryimage"},"thumbnailUrl":"https:\/\/i2.wp.com\/suleymankas.com\/wp-content\/uploads\/2018\/10\/1-3.png?w=671","datePublished":"2019-01-17T13:46:45+00:00","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/sql-2017-in-memory-table\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/01\/17\/sql-2017-in-memory-table\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/sql-2017-in-memory-table\/#primaryimage","url":"https:\/\/i2.wp.com\/suleymankas.com\/wp-content\/uploads\/2018\/10\/1-3.png?w=671","contentUrl":"https:\/\/i2.wp.com\/suleymankas.com\/wp-content\/uploads\/2018\/10\/1-3.png?w=671"},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/17\/sql-2017-in-memory-table\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"SQL 2017 In-Memory Table"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/590daafb086b3b7a2da2b24721b4c567","name":"S\u00fcleyman Ka\u015f","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/0b09c3a506e893211d4d099ffc9a94bff3eebcac8bcad74c26ccdafe9f15df03?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0b09c3a506e893211d4d099ffc9a94bff3eebcac8bcad74c26ccdafe9f15df03?s=96&d=mm&r=g","caption":"S\u00fcleyman Ka\u015f"},"description":"I have been managing MS SQL database for 3 years. And I have been managing HANA DB for the last 1 years. I'm Microsoft Certified Professional. My competencies; - Database Administrator, - Database Management, - Database Technologies, - SAP BASIS, - System Management, - Data Analysis and Reporting","sameAs":["http:\/\/www.suleymankas.com"],"url":"https:\/\/dbtut.com\/index.php\/author\/suleymankas\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/8094","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/398"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=8094"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/8094\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=8094"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=8094"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=8094"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}