{"id":5088,"date":"2015-07-17T11:19:17","date_gmt":"2015-07-17T09:19:17","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-in-memory-oltp-enhancement\/"},"modified":"2015-07-17T11:19:17","modified_gmt":"2015-07-17T09:19:17","slug":"sql-server-2016-in-memory-oltp-enhancement","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-in-memory-oltp-enhancement\/","title":{"rendered":"SQL Server 2016: In-Memory OLTP enhancement"},"content":{"rendered":"<p>The CTP2.1 has been released for some weeks and it is time to check which interesting enhancements have been already deployed for the In-Memory OLTP feature.<br \/>\nI will first have a look to the memory optimized table.<\/p>\n<h4>Memory Optimized table<\/h4>\n<p>I have a Memory Optimized table named command_queue_HK and I will add a column to this table. This table is saved on my disk in a XPT folder with its corresponding files:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"In-memory1.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/SQL2016\/In-memory1.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_In-memory1.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_In-memory1.jpg\" alt=\"b2ap3_thumbnail_In-memory1.jpg\" \/><\/a><\/p>\n<p>I execute the following command:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"In-memory2.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/SQL2016\/In-memory2.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_In-memory2.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_In-memory2.jpg\" alt=\"b2ap3_thumbnail_In-memory2.jpg\" \/><\/a><\/p>\n<p>If I have a look to my XTP folder I see that I have six new files:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"In-memory3.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/SQL2016\/In-memory3.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_In-memory3.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_In-memory3.jpg\" alt=\"b2ap3_thumbnail_In-memory3.jpg\" \/><\/a><\/p>\n<p>Does it mean that each time I make an alter table I have 6 new files? Let\u2019s try another alter table:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"In-memory4.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/SQL2016\/In-memory4.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_In-memory4.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_In-memory4.jpg\" alt=\"b2ap3_thumbnail_In-memory4.jpg\" \/><\/a><\/p>\n<p>Go back to my XTP container:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"In-memory5.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/SQL2016\/In-memory5.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_In-memory5.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_In-memory5.jpg\" alt=\"b2ap3_thumbnail_In-memory5.jpg\" \/><\/a><\/p>\n<p>I have six new files for my last alter. Each time you run an alter table you create six new files corresponding to the new structure of your table\u2026 could by really disk consuming if you update a lot your tables\u2026 which hopefully could not arrive too often.<br \/>\nFor the time being I cannot find a process which cleans obsoletes files, but when you restart you SQL Server Engine this process runs and deletes all files corresponding to your tables and recreates just six for the current structure:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"In-memory6.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/SQL2016\/In-memory6.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_In-memory6.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_In-memory6.jpg\" alt=\"b2ap3_thumbnail_In-memory6.jpg\" \/><\/a><\/p>\n<p>This alter table is an offline process and need twice the size of the table in memory\u2026 don\u2019t forget it.<\/p>\n<p>It is also possible now to use Non-BIN2 collations in index key columns:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"In-memory7.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/SQL2016\/In-memory7.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_In-memory7.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_In-memory7.jpg\" alt=\"b2ap3_thumbnail_In-memory7.jpg\" \/><\/a><\/p>\n<p>Some functionalities are not yet available (no exhaustive list).<\/p>\n<p>Foreign Keys for Memory Optimized table:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"In-memory8.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/SQL2016\/In-memory8.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_In-memory8.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_In-memory8.jpg\" alt=\"b2ap3_thumbnail_In-memory8.jpg\" \/><\/a><\/p>\n<p>Check constraint:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"In-memory9.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/SQL2016\/In-memory9.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_In-memory9.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_In-memory9.jpg\" alt=\"b2ap3_thumbnail_In-memory9.jpg\" \/><\/a><\/p>\n<h4>Natively Compiled Stored Procedure<\/h4>\n<p>For Natively Compiled Stored Procedures, we also have some enhancements and as for Memory Optimized table the first one is the possibility to alter them.<br \/>\nIf I check on my container folder I see the six files for my Natively Compiled Stored Procedure:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"In-memory10.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/SQL2016\/In-memory10.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_In-memory10.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_In-memory10.jpg\" alt=\"b2ap3_thumbnail_In-memory10.jpg\" \/><\/a><\/p>\n<p>If I right click on my SP in Management Studio I see that I have two possibility to update my SP:<\/p>\n<ul>\n<li>select Modify<\/li>\n<li>go through \u201cScript Stored Procedure as\u201d, \u201cALTER to\u2026\u201d, select where to script it<\/li>\n<\/ul>\n<p>Once my Stored Procedure is scripted, I can make the modifications I need and execute the code:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"In-memory11.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/SQL2016\/In-memory11.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_In-memory11.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_In-memory11.jpg\" alt=\"b2ap3_thumbnail_In-memory11.jpg\" \/><\/a><\/p>\n<p>Once the code is executed, I don\u2019t have like for table six files more but directly six new files and just six:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"In-memory12.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/SQL2016\/In-memory12.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_In-memory12.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_In-memory12.jpg\" alt=\"b2ap3_thumbnail_In-memory12.jpg\" \/><\/a><\/p>\n<p>Execute function in Natively Compiled Stored Procedure is also available but just with natively compiled modules:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"In-memory13.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/SQL2016\/In-memory13.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_In-memory13.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_In-memory13.jpg\" alt=\"b2ap3_thumbnail_In-memory13.jpg\" \/><\/a><\/p>\n<p>It is not working if we try to call a nested Stored Procedure.<\/p>\n<p>Like for Memory Optimized table some functionalities are not already available in this Technology Preview 2.1.<\/p>\n<p>Subqueries are also not available for the time being:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"In-memory14.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/SQL2016\/In-memory14.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_In-memory14.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_In-memory14.jpg\" alt=\"b2ap3_thumbnail_In-memory14.jpg\" \/><\/a><\/p>\n<p>There are interesting enhancements for In-Memory OLTP already available with this CTP 2.1 like Alter Table or Alter Natively Compiled Procedure but some important ones are not yet getting out like Foreign keys or Constraints for In-Memory tables. We will have to wait the RTM version to be fixed on remaining caveats.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The CTP2.1 has been released for some weeks and it is time to check which interesting enhancements have been already deployed for the In-Memory OLTP feature. I will first have a look to the memory optimized table. Memory Optimized table I have a Memory Optimized table named command_queue_HK and I will add a column to [&hellip;]<\/p>\n","protected":false},"author":21,"featured_media":5089,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[198],"tags":[],"type_dbi":[],"class_list":["post-5088","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-management"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>SQL Server 2016: In-Memory OLTP enhancement - dbi Blog<\/title>\n<meta name=\"description\" content=\"New SQL server 2016 enhancements: Alter table for memory optimized table and alter for natively compiled stored procedure.\" \/>\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-2016-in-memory-oltp-enhancement\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server 2016: In-Memory OLTP enhancement\" \/>\n<meta property=\"og:description\" content=\"New SQL server 2016 enhancements: Alter table for memory optimized table and alter for natively compiled stored procedure.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-in-memory-oltp-enhancement\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2015-07-17T09:19:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_In-memory1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"500\" \/>\n\t<meta property=\"og:image:height\" content=\"153\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"St\u00e9phane Savorgnano\" \/>\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 Savorgnano\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 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-2016-in-memory-oltp-enhancement\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-in-memory-oltp-enhancement\/\"},\"author\":{\"name\":\"St\u00e9phane Savorgnano\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/b6bce7d75118b35bdb3b439ad6a9ca3c\"},\"headline\":\"SQL Server 2016: In-Memory OLTP enhancement\",\"datePublished\":\"2015-07-17T09:19:17+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-in-memory-oltp-enhancement\/\"},\"wordCount\":494,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-in-memory-oltp-enhancement\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_In-memory1.jpg\",\"articleSection\":[\"Database management\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-in-memory-oltp-enhancement\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-in-memory-oltp-enhancement\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-in-memory-oltp-enhancement\/\",\"name\":\"SQL Server 2016: In-Memory OLTP enhancement - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-in-memory-oltp-enhancement\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-in-memory-oltp-enhancement\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_In-memory1.jpg\",\"datePublished\":\"2015-07-17T09:19:17+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/b6bce7d75118b35bdb3b439ad6a9ca3c\"},\"description\":\"New SQL server 2016 enhancements: Alter table for memory optimized table and alter for natively compiled stored procedure.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-in-memory-oltp-enhancement\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-in-memory-oltp-enhancement\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-in-memory-oltp-enhancement\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_In-memory1.jpg\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_In-memory1.jpg\",\"width\":500,\"height\":153},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-in-memory-oltp-enhancement\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server 2016: In-Memory OLTP enhancement\"}]},{\"@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\/b6bce7d75118b35bdb3b439ad6a9ca3c\",\"name\":\"St\u00e9phane Savorgnano\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/88d2a790f775c52c1012ec644d883431da758f2cbcfc16067ade04d2ef625ef5?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/88d2a790f775c52c1012ec644d883431da758f2cbcfc16067ade04d2ef625ef5?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/88d2a790f775c52c1012ec644d883431da758f2cbcfc16067ade04d2ef625ef5?s=96&d=mm&r=g\",\"caption\":\"St\u00e9phane Savorgnano\"},\"description\":\"St\u00e9phane Savorgnano has more than fifteen years of experience in Microsoft software development and in SQL Server database solutions. He is specialized in SQL Server installation, performance analysis, best practices, etc. St\u00e9phane Savorgnano is 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. Prior to joining dbi services, he was software engineer at Ciba Specialty Chemicals in Basel. St\u00e9phane Savorgnano holds a Master of Informatics from Mulhouse University (F). His branch-related experience covers Banking \/ Financial Services, Chemicals &amp; Pharmaceuticals, etc.\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/stephane-savorgnano\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL Server 2016: In-Memory OLTP enhancement - dbi Blog","description":"New SQL server 2016 enhancements: Alter table for memory optimized table and alter for natively compiled stored procedure.","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-2016-in-memory-oltp-enhancement\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server 2016: In-Memory OLTP enhancement","og_description":"New SQL server 2016 enhancements: Alter table for memory optimized table and alter for natively compiled stored procedure.","og_url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-in-memory-oltp-enhancement\/","og_site_name":"dbi Blog","article_published_time":"2015-07-17T09:19:17+00:00","og_image":[{"width":500,"height":153,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_In-memory1.jpg","type":"image\/jpeg"}],"author":"St\u00e9phane Savorgnano","twitter_card":"summary_large_image","twitter_misc":{"Written by":"St\u00e9phane Savorgnano","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-in-memory-oltp-enhancement\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-in-memory-oltp-enhancement\/"},"author":{"name":"St\u00e9phane Savorgnano","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/b6bce7d75118b35bdb3b439ad6a9ca3c"},"headline":"SQL Server 2016: In-Memory OLTP enhancement","datePublished":"2015-07-17T09:19:17+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-in-memory-oltp-enhancement\/"},"wordCount":494,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-in-memory-oltp-enhancement\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_In-memory1.jpg","articleSection":["Database management"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2016-in-memory-oltp-enhancement\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-in-memory-oltp-enhancement\/","url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-in-memory-oltp-enhancement\/","name":"SQL Server 2016: In-Memory OLTP enhancement - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-in-memory-oltp-enhancement\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-in-memory-oltp-enhancement\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_In-memory1.jpg","datePublished":"2015-07-17T09:19:17+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/b6bce7d75118b35bdb3b439ad6a9ca3c"},"description":"New SQL server 2016 enhancements: Alter table for memory optimized table and alter for natively compiled stored procedure.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-in-memory-oltp-enhancement\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2016-in-memory-oltp-enhancement\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-in-memory-oltp-enhancement\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_In-memory1.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_In-memory1.jpg","width":500,"height":153},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-in-memory-oltp-enhancement\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server 2016: In-Memory OLTP enhancement"}]},{"@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\/b6bce7d75118b35bdb3b439ad6a9ca3c","name":"St\u00e9phane Savorgnano","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/88d2a790f775c52c1012ec644d883431da758f2cbcfc16067ade04d2ef625ef5?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/88d2a790f775c52c1012ec644d883431da758f2cbcfc16067ade04d2ef625ef5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/88d2a790f775c52c1012ec644d883431da758f2cbcfc16067ade04d2ef625ef5?s=96&d=mm&r=g","caption":"St\u00e9phane Savorgnano"},"description":"St\u00e9phane Savorgnano has more than fifteen years of experience in Microsoft software development and in SQL Server database solutions. He is specialized in SQL Server installation, performance analysis, best practices, etc. St\u00e9phane Savorgnano is 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. Prior to joining dbi services, he was software engineer at Ciba Specialty Chemicals in Basel. St\u00e9phane Savorgnano holds a Master of Informatics from Mulhouse University (F). His branch-related experience covers Banking \/ Financial Services, Chemicals &amp; Pharmaceuticals, etc.","url":"https:\/\/www.dbi-services.com\/blog\/author\/stephane-savorgnano\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/5088","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\/21"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=5088"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/5088\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/5089"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=5088"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=5088"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=5088"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=5088"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}