{"id":3300,"date":"2013-11-10T23:28:00","date_gmt":"2013-11-10T22:28:00","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-ctp2-tables-and-stored-procedures-advisor\/"},"modified":"2013-11-10T23:28:00","modified_gmt":"2013-11-10T22:28:00","slug":"sql-server-2014-ctp2-tables-and-stored-procedures-advisor","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-ctp2-tables-and-stored-procedures-advisor\/","title":{"rendered":"SQL Server 2014 CTP2: In-Memory Advisor for Tables and Stored Procedures"},"content":{"rendered":"<p><img decoding=\"async\" class=\"blog-image aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_SQL2014CTP2.jpg\" alt=\"\" \/><\/p>\n<p>One of the best new functionalities of Microsoft SQL Server 2014 is the In-Memory part, which gives you the possibility to load tables and also Stored Procedures in-memory for a very fast response time. The Community Technology Preview 2 from Microsoft SQL Server 2014 went out some days ago with two new Advisors. These Advisors will help you manage the transformation of your disk tables to Memory Optimized Tables as well as your Stored Procedures to Natively Compiled Stored Procedures.<\/p>\n<p>Let see how this work!<\/p>\n<h3>Memory Optimization Advisor<\/h3>\n<p>Go to Management Studio and select a table you would like to migrate. Right click this table and choose Memory Optimization Advisor.<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"MOA1.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/MOA1.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_MOA1.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_MOA1.jpg\" alt=\"b2ap3_thumbnail_MOA1.jpg\" \/><\/a><\/p>\n<p>The Advisor tool will be launched with an explain page that you can skip.<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"MOA2.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/MOA2.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_MOA2.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_MOA2.jpg\" alt=\"b2ap3_thumbnail_MOA2.jpg\" \/><\/a><\/p>\n<p>Click Next to begin the script generation process. It will check if your table is able to be migrated as a Memory Optimized Table.<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"MOA3.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/MOA3.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_MOA3.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_MOA3.jpg\" alt=\"b2ap3_thumbnail_MOA3.jpg\" \/><\/a><\/p>\n<p>Here, all is green, it means that your table has no blocking features which could avoid a migration process. You have the possibility to Generate a report for this analyze, for the time being it is just an HTML file.<\/p>\n<p>Click Next.<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"MOA4.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/MOA4.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_MOA4.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_MOA4.jpg\" alt=\"b2ap3_thumbnail_MOA4.jpg\" \/><\/a><\/p>\n<p>On this page a warning appears. In fact for memory optimized table, only BIN2 collation are available for indexes. My instance has French_CI_AS, I will need to change my index collation later in the migration process.<\/p>\n<p>Click Next to continue.<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"MOA5.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/MOA5.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_MOA5.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_MOA5.jpg\" alt=\"b2ap3_thumbnail_MOA5.jpg\" \/><\/a><\/p>\n<p>On this page we have important informations:<\/p>\n<ul>\n<li>Memory-Optimized Filegroup, you can have just one per instance<\/li>\n<li>Logical file name that you can enter<\/li>\n<li>Path where you will save your logical file can be changed<\/li>\n<li>The estimated current memory cost for this table(if you move the data from the disk table to the new table)<\/li>\n<li>You have the possibility to select, if you want, to copy Data from the disk table to the new memory optimized table during the migration process<\/li>\n<li>You are also able to change the durability of the table: by default Schema and Data(schema_and_data) but you could also choose just Schema(schema_only), in this case data will be lost after each SQL Server service restart.<\/li>\n<\/ul>\n<p>Click Next.<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"MOA6.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/MOA6.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_MOA6.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_MOA6.jpg\" alt=\"b2ap3_thumbnail_MOA6.jpg\" \/><\/a><\/p>\n<p>The primary key has to be converted, you can choose between:<\/p>\n<ul>\n<li>new nonclustered Hash index, which gives best performance for point lookups, needs also bucket_count which should be twice the expected number of rows<\/li>\n<li>nonclustered index, which gives best performance for range predicates<\/li>\n<\/ul>\n<p>Click Next.<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"MOA7.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/MOA7.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_MOA7.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_MOA7.jpg\" alt=\"b2ap3_thumbnail_MOA7.jpg\" \/><\/a><\/p>\n<p>You have the same choice as for the primary key.<\/p>\n<p>Click Next.<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"MOA8.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/MOA8.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_MOA8.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_MOA8.jpg\" alt=\"b2ap3_thumbnail_MOA8.jpg\" \/><\/a><\/p>\n<p>For an index with Char Data Type, we have to select a BIN2 collation because other collations are not accepted with memory optimized tables.<\/p>\n<p>Click Next.<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"MOA9.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/MOA9.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_MOA9.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_MOA9.jpg\" alt=\"b2ap3_thumbnail_MOA9.jpg\" \/><\/a><\/p>\n<p>Here you have a resume of all operations that will be performed to migrate your disk table to a new memory optimized table. You have the option to script those operations by clicking the Script button.<\/p>\n<p>Click Migrate to start the migration process.<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"MOA10.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/MOA10.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_MOA10.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_MOA10.jpg\" alt=\"b2ap3_thumbnail_MOA10.jpg\" \/><\/a><\/p>\n<p>The migration process succeeded. Now our table is In-Memory!<\/p>\n<p>We can check the new table&#8217;s properties.<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"MOA11.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/MOA11.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_MOA11.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_MOA11.jpg\" alt=\"b2ap3_thumbnail_MOA11.jpg\" \/><\/a><\/p>\n<p>The table is memory-optimized and the durability is schema and data. At this step, we have migrates our disk table to a memory-optimized table.<\/p>\n<p>Why not also move the Stored Procedure which fills this table to a new natively compiled Stored Procedure. Let&#8217;s also try this!<\/p>\n<h3>Native Compilation Advisor<\/h3>\n<p>In Management Studio, navigate through your database&#8217;s objects and select the Stored Procedure you would like to migrate to Natively Compiled Stored Procedure. Right click it and select Native Compilation Advisor.<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"NCA1.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/NCA1.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_NCA1.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_NCA1.jpg\" alt=\"b2ap3_thumbnail_NCA1.jpg\" \/><\/a><\/p>\n<p>A welcome screen appears.<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"NCA2.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/NCA2.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_NCA2.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_NCA2.jpg\" alt=\"b2ap3_thumbnail_NCA2.jpg\" \/><\/a><\/p>\n<p>This screen explains that this advisor will help us to discover and evaluate Transact-SQL elements in the Stored Procedure that are not supported in Native Compilation&#8230;<\/p>\n<p>Click Next.<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"NCA3.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/NCA3.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_NCA3.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_NCA3.jpg\" alt=\"b2ap3_thumbnail_NCA3.jpg\" \/><\/a><\/p>\n<p>Here, the Stored Procedure is valid and can become a native one without modification.<\/p>\n<p>My first idea was to click Next to let the advisor migrate my Stored Procedure as for a table, but the Next button is disabled&#8230;<\/p>\n<p>In fact, this Advisor just helps you to discover problems that could make your migration impossible, but doesn&#8217;t do anything else&#8230; You have to migrate your Stored Procedure on your own.<\/p>\n<p>On the other hand, when a part of your Transact-SQL is not cimpliant for Natively Compiled Stored Procedures, this tool advises you:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"NCA4.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/NCA4.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_NCA4.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_NCA4.jpg\" alt=\"b2ap3_thumbnail_NCA4.jpg\" \/><\/a><\/p>\n<p>And when you click the Next button:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"NCA5.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/NCA5.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_NCA5.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_NCA5.jpg\" alt=\"b2ap3_thumbnail_NCA5.jpg\" \/><\/a><\/p>\n<p>Now, you have a list of elements which are not supported for Natively Compiled Stored Procedures.<\/p>\n<p>You also have the possibility to create a report for these unsupported elements.<\/p>\n<h3>Conclusion<\/h3>\n<p>As we have seen, the Advisor for tables is more interesting than the Advisor for native compilation stored procedures. In both case, it is definitively a good help to improve codes prior to a migration.<\/p>\n<p>To evaluate if In-Memory OLTP will improve you database application&#8217;s performance you can use the AMR (Analysis, Migrate and Report) tool. This tool will be covered in a future blog.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>One of the best new functionalities of Microsoft SQL Server 2014 is the In-Memory part, which gives you the possibility to load tables and also Stored Procedures in-memory for a very fast response time. The Community Technology Preview 2 from Microsoft SQL Server 2014 went out some days ago with two new Advisors. These Advisors [&hellip;]<\/p>\n","protected":false},"author":21,"featured_media":3301,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[48],"tags":[222,49,51,52],"type_dbi":[],"class_list":["post-3300","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology-survey","tag-in-memory","tag-microsoft","tag-sql-server","tag-sql-server-2014"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.4) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>SQL Server 2014 CTP2: In-Memory Advisor for Tables and Stored Procedures - dbi Blog<\/title>\n<meta name=\"description\" content=\"One of the best new functionalities of Microsoft SQL Server 2014 is the In-Memory part, which gives you the possibility to load tables and also Stored Procedures in-memory for a very fast response time. The Community Technology Preview 2 from Microsoft SQL Server 2014 went out some days ago with two new Advisors. These Advisors will help you manage the transformation of your disk tables to Memory Optimized Tables as well as your Stored Procedures to Natively Compiled Stored Procedures.\" \/>\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-ctp2-tables-and-stored-procedures-advisor\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server 2014 CTP2: In-Memory Advisor for Tables and Stored Procedures\" \/>\n<meta property=\"og:description\" content=\"One of the best new functionalities of Microsoft SQL Server 2014 is the In-Memory part, which gives you the possibility to load tables and also Stored Procedures in-memory for a very fast response time. The Community Technology Preview 2 from Microsoft SQL Server 2014 went out some days ago with two new Advisors. These Advisors will help you manage the transformation of your disk tables to Memory Optimized Tables as well as your Stored Procedures to Natively Compiled Stored Procedures.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-ctp2-tables-and-stored-procedures-advisor\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2013-11-10T22:28:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_SQL2014CTP2.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"414\" \/>\n\t<meta property=\"og:image:height\" content=\"129\" \/>\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=\"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-ctp2-tables-and-stored-procedures-advisor\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2014-ctp2-tables-and-stored-procedures-advisor\\\/\"},\"author\":{\"name\":\"St\u00e9phane Savorgnano\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/b6bce7d75118b35bdb3b439ad6a9ca3c\"},\"headline\":\"SQL Server 2014 CTP2: In-Memory Advisor for Tables and Stored Procedures\",\"datePublished\":\"2013-11-10T22:28:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2014-ctp2-tables-and-stored-procedures-advisor\\\/\"},\"wordCount\":817,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2014-ctp2-tables-and-stored-procedures-advisor\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/2e1ax_default_entry_SQL2014CTP2.jpg\",\"keywords\":[\"In-memory\",\"Microsoft\",\"SQL Server\",\"SQL Server 2014\"],\"articleSection\":[\"Technology Survey\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2014-ctp2-tables-and-stored-procedures-advisor\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2014-ctp2-tables-and-stored-procedures-advisor\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2014-ctp2-tables-and-stored-procedures-advisor\\\/\",\"name\":\"SQL Server 2014 CTP2: In-Memory Advisor for Tables and Stored Procedures - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2014-ctp2-tables-and-stored-procedures-advisor\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2014-ctp2-tables-and-stored-procedures-advisor\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/2e1ax_default_entry_SQL2014CTP2.jpg\",\"datePublished\":\"2013-11-10T22:28:00+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/b6bce7d75118b35bdb3b439ad6a9ca3c\"},\"description\":\"One of the best new functionalities of Microsoft SQL Server 2014 is the In-Memory part, which gives you the possibility to load tables and also Stored Procedures in-memory for a very fast response time. The Community Technology Preview 2 from Microsoft SQL Server 2014 went out some days ago with two new Advisors. These Advisors will help you manage the transformation of your disk tables to Memory Optimized Tables as well as your Stored Procedures to Natively Compiled Stored Procedures.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2014-ctp2-tables-and-stored-procedures-advisor\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2014-ctp2-tables-and-stored-procedures-advisor\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2014-ctp2-tables-and-stored-procedures-advisor\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/2e1ax_default_entry_SQL2014CTP2.jpg\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/2e1ax_default_entry_SQL2014CTP2.jpg\",\"width\":414,\"height\":129},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-2014-ctp2-tables-and-stored-procedures-advisor\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server 2014 CTP2: In-Memory Advisor for Tables and Stored Procedures\"}]},{\"@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 2014 CTP2: In-Memory Advisor for Tables and Stored Procedures - dbi Blog","description":"One of the best new functionalities of Microsoft SQL Server 2014 is the In-Memory part, which gives you the possibility to load tables and also Stored Procedures in-memory for a very fast response time. The Community Technology Preview 2 from Microsoft SQL Server 2014 went out some days ago with two new Advisors. These Advisors will help you manage the transformation of your disk tables to Memory Optimized Tables as well as your Stored Procedures to Natively Compiled Stored Procedures.","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-ctp2-tables-and-stored-procedures-advisor\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server 2014 CTP2: In-Memory Advisor for Tables and Stored Procedures","og_description":"One of the best new functionalities of Microsoft SQL Server 2014 is the In-Memory part, which gives you the possibility to load tables and also Stored Procedures in-memory for a very fast response time. The Community Technology Preview 2 from Microsoft SQL Server 2014 went out some days ago with two new Advisors. These Advisors will help you manage the transformation of your disk tables to Memory Optimized Tables as well as your Stored Procedures to Natively Compiled Stored Procedures.","og_url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-ctp2-tables-and-stored-procedures-advisor\/","og_site_name":"dbi Blog","article_published_time":"2013-11-10T22:28:00+00:00","og_image":[{"width":414,"height":129,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_SQL2014CTP2.jpg","type":"image\/jpeg"}],"author":"St\u00e9phane Savorgnano","twitter_card":"summary_large_image","twitter_misc":{"Written by":"St\u00e9phane Savorgnano","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-ctp2-tables-and-stored-procedures-advisor\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-ctp2-tables-and-stored-procedures-advisor\/"},"author":{"name":"St\u00e9phane Savorgnano","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/b6bce7d75118b35bdb3b439ad6a9ca3c"},"headline":"SQL Server 2014 CTP2: In-Memory Advisor for Tables and Stored Procedures","datePublished":"2013-11-10T22:28:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-ctp2-tables-and-stored-procedures-advisor\/"},"wordCount":817,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-ctp2-tables-and-stored-procedures-advisor\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_SQL2014CTP2.jpg","keywords":["In-memory","Microsoft","SQL Server","SQL Server 2014"],"articleSection":["Technology Survey"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2014-ctp2-tables-and-stored-procedures-advisor\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-ctp2-tables-and-stored-procedures-advisor\/","url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-ctp2-tables-and-stored-procedures-advisor\/","name":"SQL Server 2014 CTP2: In-Memory Advisor for Tables and Stored Procedures - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-ctp2-tables-and-stored-procedures-advisor\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-ctp2-tables-and-stored-procedures-advisor\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_SQL2014CTP2.jpg","datePublished":"2013-11-10T22:28:00+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/b6bce7d75118b35bdb3b439ad6a9ca3c"},"description":"One of the best new functionalities of Microsoft SQL Server 2014 is the In-Memory part, which gives you the possibility to load tables and also Stored Procedures in-memory for a very fast response time. The Community Technology Preview 2 from Microsoft SQL Server 2014 went out some days ago with two new Advisors. These Advisors will help you manage the transformation of your disk tables to Memory Optimized Tables as well as your Stored Procedures to Natively Compiled Stored Procedures.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-ctp2-tables-and-stored-procedures-advisor\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2014-ctp2-tables-and-stored-procedures-advisor\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-ctp2-tables-and-stored-procedures-advisor\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_SQL2014CTP2.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_SQL2014CTP2.jpg","width":414,"height":129},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-ctp2-tables-and-stored-procedures-advisor\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server 2014 CTP2: In-Memory Advisor for Tables and Stored Procedures"}]},{"@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\/3300","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=3300"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/3300\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/3301"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=3300"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=3300"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=3300"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=3300"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}