{"id":44077,"date":"2026-05-10T21:29:35","date_gmt":"2026-05-10T19:29:35","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=44077"},"modified":"2026-05-10T21:28:38","modified_gmt":"2026-05-10T19:28:38","slug":"in-memory-tables-in-sql-server-2025-and-sqlbits-2026","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/in-memory-tables-in-sql-server-2025-and-sqlbits-2026\/","title":{"rendered":"SQL Server 2025 In-Memory: New Cleanup Features &amp; SQLBits 2026 Insights"},"content":{"rendered":"\n<figure class=\"wp-block-image size-large is-style-rounded\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"384\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2026\/04\/image-18-1024x384.png\" alt=\"\" class=\"wp-image-44196\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2026\/04\/image-18-1024x384.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2026\/04\/image-18-300x113.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2026\/04\/image-18-768x288.png 768w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2026\/04\/image-18-1536x576.png 1536w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2026\/04\/image-18.png 1920w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Summer is already around the corner, but it&#8217;s not too late for some spring cleaning!<br>If you manage SQL Server databases with <a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/relational-databases\/in-memory-oltp\/introduction-to-memory-optimized-tables?view=sql-server-ver17\" id=\"https:\/\/learn.microsoft.com\/en-us\/sql\/relational-databases\/in-memory-oltp\/introduction-to-memory-optimized-tables?view=sql-server-ver17\">In-Memory tables<\/a>, you may have already tried to delete a <code>MEMORY_OPTIMIZED_DATA<\/code> file or <code>FILEGROUP<\/code>, only to find that SQL Server simply won&#8217;t let you. <br>This limitation has existed since the debut of In-Memory with SQL Server 2014, and the only workaround until now was to recreate the database from scratch.<br>It is with SQL Server 2025 that Microsoft finally lifts this restriction. In this article, we will analyze these behavioral differences before and after this version. <br>To conclude, we will draw on the key points presented by <a href=\"https:\/\/www.linkedin.com\/in\/thodoris-katsimanis-057a5711a\/\" id=\"https:\/\/www.linkedin.com\/in\/thodoris-katsimanis-057a5711a\/\">Thodoris Katsimanis<\/a>, DBA Team Technology Manager at Kaizen Gaming, during his session at <a href=\"https:\/\/sqlbits.com\/\" id=\"https:\/\/sqlbits.com\/\">SQLBits 2026<\/a> on In-Memory tables, in order to summarize the challenges and benefits this feature can bring to production.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-the-legacy-struggle-in-memory-limitations-from-2014-to-2022\">The Legacy Struggle: In-Memory Limitations from 2014 to 2022<\/h2>\n\n\n\n<p>To demonstrate this difference in behavior, we will create a database under SQL Server 2022 with an In-Memory table loaded with data, and then attempt to delete the associated files and FILEGROUP:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nDECLARE @DataPath NVARCHAR(512) = &#039;&lt;YOUR_DATA_FOLDER&gt;&#039;;\nDECLARE @LogPath  NVARCHAR(512) = &#039;&lt;YOUR_LOG_FOLDER&gt;&#039;;\nDECLARE @SQL      NVARCHAR(MAX);\n\nSET @SQL = N&#039;\nCREATE DATABASE TestInMemory\nON PRIMARY (\n    NAME = TestInMemory_data,\n    FILENAME = &#039;&#039;&#039; + @DataPath + N&#039;TestInMemory.mdf&#039;&#039;\n),\nFILEGROUP XTP_FG CONTAINS MEMORY_OPTIMIZED_DATA (\n    NAME = TestInMemory_XTP,\n    FILENAME = &#039;&#039;&#039; + @DataPath + N&#039;TestInMemory_XTP&#039;&#039;\n)\nLOG ON (\n    NAME = TestInMemory_log,\n    FILENAME = &#039;&#039;&#039; + @LogPath + N&#039;TestInMemory_log.ldf&#039;&#039;\n);&#039;;\n\nEXEC sp_executesql @SQL;\n\nUSE TestInMemory;\nGO\n\nCREATE TABLE dbo.TestTable\n(\n    ID    INT          NOT NULL,\n    Val   NVARCHAR(50) NOT NULL,\n    CONSTRAINT PK_TestTable PRIMARY KEY NONCLUSTERED HASH (ID)\n        WITH (BUCKET_COUNT = 1024)\n)\nWITH (MEMORY_OPTIMIZED = ON, DURABILITY = SCHEMA_AND_DATA);\nGO\n\nINSERT INTO dbo.TestTable VALUES (1, &#039;Hello&#039;), (2, &#039;World&#039;);\nGO\n<\/pre><\/div>\n\n\n<p>Once our table is loaded (to ensure the table exists and is not just metadata), we can then delete it:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nDROP TABLE dbo.TestTable;\nGO\n\nSELECT name, type_desc \nFROM sys.tables \nWHERE is_memory_optimized = 1;\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"491\" height=\"188\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2026\/04\/image-12.png\" alt=\"\" class=\"wp-image-44079\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2026\/04\/image-12.png 491w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2026\/04\/image-12-300x115.png 300w\" sizes=\"auto, (max-width: 491px) 100vw, 491px\" \/><\/figure>\n\n\n\n<p>The verification clearly shows that no more In-Memory objects exist. We can therefore proceed with the famous cleanup of the files linked to the table we deleted:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nALTER DATABASE TestInMemory \nREMOVE FILE TestInMemory_XTP;\nGO\n\nALTER DATABASE TestInMemory\nREMOVE FILEGROUP XTP_FG;\nGO\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"735\" height=\"355\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2026\/04\/image-11.png\" alt=\"\" class=\"wp-image-44078\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2026\/04\/image-11.png 735w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2026\/04\/image-11-300x145.png 300w\" sizes=\"auto, (max-width: 735px) 100vw, 735px\" \/><\/figure>\n\n\n\n<p>And here is the famous error, impossible to bypass it and sort things out.<br><strong>Note:<\/strong> This cleanup challenge specifically affects tables using DURABILITY = SCHEMA_AND_DATA, as they are the only ones where data persists within physical files on disk.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-sql-server-2025-breaking-the-in-memory-cleanup-barrier\">SQL Server 2025: Breaking the In-Memory Cleanup Barrier<\/h2>\n\n\n\n<p>SQL Server 2025 does not just lift the restriction: it also introduces a new DMV, <code><a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/relational-databases\/system-dynamic-management-views\/sys-dm-db-xtp-undeploy-status?view=sql-server-ver17\">sys.dm_db_xtp_undeploy_status<\/a><\/code>, which exposes the precise reason why the deletion is not yet possible. <br>By querying it at the same stage as our previous example, here is what it returns:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nUSE TestInMemory;\nGO\n\nSELECT\n    deployment_state,\n    deployment_state_desc,\n    undeploy_lsn,\n    start_of_log_lsn\nFROM sys.dm_db_xtp_undeploy_status;\nGO\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"285\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2026\/04\/image-13-1024x285.png\" alt=\"\" class=\"wp-image-44080\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2026\/04\/image-13-1024x285.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2026\/04\/image-13-300x84.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2026\/04\/image-13-768x214.png 768w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2026\/04\/image-13.png 1055w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Now we have a clear reason: the <code>start_of_log_lsn<\/code> is too old, which prevents SQL Server from releasing the FILEGROUP. To resolve this, the LSNs must be advanced. A FULL backup is first required to initialize the backup chain, followed by a LOG backup to effectively advance the position in the logs:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nCHECKPOINT;\nGO\n\nBACKUP DATABASE TestInMemory TO DISK = &#039;NUL&#039;;\nGO\n\nBACKUP LOG TestInMemory TO DISK = &#039;NUL&#039;;\nGO\n<\/pre><\/div>\n\n\n<p>Once the LOG backup is executed and the LSNs are sufficiently advanced, the files can finally be deleted. The <code>sys.dm_db_xtp_undeploy_status<\/code> view confirms that the XTP engine is no longer deployed and that the cleanup has been successfully performed.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"710\" height=\"98\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2026\/04\/image-14.png\" alt=\"\" class=\"wp-image-44081\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2026\/04\/image-14.png 710w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2026\/04\/image-14-300x41.png 300w\" sizes=\"auto, (max-width: 710px) 100vw, 710px\" \/><\/figure>\n\n\n\n<p>SQL Server 2025 not only introduces the ability to purge empty files that were linked to an In-Memory object but also the ability to troubleshoot their deletion!<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-from-milliseconds-to-microseconds-thodoris-katsimanis-at-sqlbits-2026\">From Milliseconds to Microseconds: Thodoris Katsimanis at SQLBits 2026<\/h2>\n\n\n\n<p>To conclude this article, let&#8217;s look back at the key points covered by Thodoris Katsimanis during his session at SQLBits 2026, entitled <em>&#8220;Revolutionizing Database Performance: Deep Dive into SQL InMemory Technology&#8221;<\/em>.<br>His context is particularly telling: at Kaizen Gaming, SQL Server databases handle thousands of transactions per second in real time, in an environment where every millisecond has a direct impact on the user experience. It is precisely in this type of workload that In-Memory tables reveal their full potential.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-eliminating-page-contention-with-latch-free-architecture\">Eliminating Page Contention with Latch-Free Architecture<\/h3>\n\n\n\n<p>The presentation exposed limitations of the SQL Server engine: in a high-performance system, latches on disk pages (<code><a href=\"https:\/\/www.sqlskills.com\/help\/waits\/pagelatch_ex\/\" id=\"https:\/\/www.sqlskills.com\/help\/waits\/pagelatch_ex\/\">PAGELATCH_EX<\/a><\/code>) create bottlenecks that can lead to Thread Pool exhaustion. The In-Memory architecture solves this problem at its root via a latch-free structure. By relying on optimistic concurrency control and multi-versioning (<a href=\"https:\/\/www.geeksforgeeks.org\/dbms\/what-is-multi-version-concurrency-control-mvcc-in-dbms\/\" id=\"https:\/\/www.geeksforgeeks.org\/dbms\/what-is-multi-version-concurrency-control-mvcc-in-dbms\/\">MVCC<\/a>), SQL Server no longer waits for locks. Each row has a Begin-Timestamp and an End-Timestamp, allowing transactions to read the valid version of the data without blocking writes.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-maximizing-performance-the-crucial-choice-between-hash-and-bw-tree\">Maximizing Performance: The Crucial Choice between Hash and BW-Tree<\/h3>\n\n\n\n<p>The choice between a Hash index and a Nonclustered index is crucial. The Hash index is perfectly suited for Point Lookups (searches on an exact value): it points directly to the memory address via a hash function. Conversely, the Nonclustered index relies on a BW-Tree structure, which is essential for range scans and sorting, where Hash is of little use. To learn more about indexes for In-Memory tables, check the <a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/relational-databases\/in-memory-oltp\/indexes-for-memory-optimized-tables?view=sql-server-ver17\" id=\"https:\/\/learn.microsoft.com\/en-us\/sql\/relational-databases\/in-memory-oltp\/indexes-for-memory-optimized-tables?view=sql-server-ver17\">Microsoft&#8217;s documentation<\/a>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-the-critical-impact-of-bucket-count-misconfiguration\">The Critical Impact of BUCKET_COUNT Misconfiguration<\/h3>\n\n\n\n<p>As Thodoris points out, the success of a Hash index relies on tuning the <code>BUCKET_COUNT<\/code>. This parameter defines the number of entry points in the index. If it is too low, the system generates collision chains: multiple values end up in the same bucket, forcing the engine to scan a linked list, which degrades performance. If it is too high, it consumes memory unnecessarily. Thodoris also highlights a crucial observation: using a Nonclustered index for an equality search can consume significantly more memory than a properly sized Hash index.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-final-thoughts-embracing-the-in-memory-revolution\">Final Thoughts: Embracing the In-Memory Revolution<\/h2>\n\n\n\n<p>SQL Server 2025 finally lifts a limitation that has hampered the lifecycle management of In-Memory databases for over ten years. Being able to cleanly delete associated files and FILEGROUPs, understanding why the engine blocks this operation thanks to <code>sys.dm_db_xtp_undeploy_status<\/code>, and having a clear procedure to remedy it: this is concrete progress for everyone operating this technology in production.<\/p>\n\n\n\n<p>Thodoris Katsimanis&#8217;s session at SQLBits 2026 reminds us that the care given to maintenance and monitoring matters just as much as the initial design. In-Memory tables are not a simple performance lever to be activated and forgotten: they require a mastery of their internal mechanisms, thread management to eliminate contention, and rigorous sizing of the <code>BUCKET_COUNT<\/code>. As he summarizes: the millisecond is no longer a sufficient unit of measurement. In-Memory OLTP aims for the microsecond and in hyper-transactional environments, that is precisely what makes the difference.<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>SQL Server 2025 finally allows dropping In-Memory filegroups, a breakthrough analyzed here alongside expert performance insights from SQLBits 2026.<\/p>\n","protected":false},"author":157,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[368,99],"tags":[4023,51,2514],"type_dbi":[],"class_list":["post-44077","post","type-post","status-publish","format-standard","hentry","category-development-performance","category-sql-server","tag-inmemory","tag-sql-server","tag-sqlbits"],"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 2025 In-Memory: New Cleanup Features &amp; SQLBits 2026 Insights - dbi Blog<\/title>\n<meta name=\"description\" content=\"SQL Server 2025 finally allows dropping In-Memory filegroups, a breakthrough analyzed here alongside expert performance insights from SQLBits 2026.\" \/>\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\/in-memory-tables-in-sql-server-2025-and-sqlbits-2026\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server 2025 In-Memory: New Cleanup Features &amp; SQLBits 2026 Insights\" \/>\n<meta property=\"og:description\" content=\"SQL Server 2025 finally allows dropping In-Memory filegroups, a breakthrough analyzed here alongside expert performance insights from SQLBits 2026.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/in-memory-tables-in-sql-server-2025-and-sqlbits-2026\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2026-05-10T19:29:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2026\/04\/image-18.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"720\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Louis Tochon\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Louis Tochon\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 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\\\/in-memory-tables-in-sql-server-2025-and-sqlbits-2026\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/in-memory-tables-in-sql-server-2025-and-sqlbits-2026\\\/\"},\"author\":{\"name\":\"Louis Tochon\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/e4195b0cb120295b3407a502c23e75b6\"},\"headline\":\"SQL Server 2025 In-Memory: New Cleanup Features &amp; SQLBits 2026 Insights\",\"datePublished\":\"2026-05-10T19:29:35+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/in-memory-tables-in-sql-server-2025-and-sqlbits-2026\\\/\"},\"wordCount\":928,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/in-memory-tables-in-sql-server-2025-and-sqlbits-2026\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2026\\\/04\\\/image-18-1024x384.png\",\"keywords\":[\"inmemory\",\"SQL Server\",\"SQLBits\"],\"articleSection\":[\"Development &amp; Performance\",\"SQL Server\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/in-memory-tables-in-sql-server-2025-and-sqlbits-2026\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/in-memory-tables-in-sql-server-2025-and-sqlbits-2026\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/in-memory-tables-in-sql-server-2025-and-sqlbits-2026\\\/\",\"name\":\"SQL Server 2025 In-Memory: New Cleanup Features &amp; SQLBits 2026 Insights - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/in-memory-tables-in-sql-server-2025-and-sqlbits-2026\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/in-memory-tables-in-sql-server-2025-and-sqlbits-2026\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2026\\\/04\\\/image-18-1024x384.png\",\"datePublished\":\"2026-05-10T19:29:35+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/e4195b0cb120295b3407a502c23e75b6\"},\"description\":\"SQL Server 2025 finally allows dropping In-Memory filegroups, a breakthrough analyzed here alongside expert performance insights from SQLBits 2026.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/in-memory-tables-in-sql-server-2025-and-sqlbits-2026\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/in-memory-tables-in-sql-server-2025-and-sqlbits-2026\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/in-memory-tables-in-sql-server-2025-and-sqlbits-2026\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2026\\\/04\\\/image-18.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2026\\\/04\\\/image-18.png\",\"width\":1920,\"height\":720},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/in-memory-tables-in-sql-server-2025-and-sqlbits-2026\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server 2025 In-Memory: New Cleanup Features &amp; SQLBits 2026 Insights\"}]},{\"@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\\\/e4195b0cb120295b3407a502c23e75b6\",\"name\":\"Louis Tochon\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ce0ee48c64e763e6c4076e21c80729d15bc4493288aeb8695125c69082100e10?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ce0ee48c64e763e6c4076e21c80729d15bc4493288aeb8695125c69082100e10?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ce0ee48c64e763e6c4076e21c80729d15bc4493288aeb8695125c69082100e10?s=96&d=mm&r=g\",\"caption\":\"Louis Tochon\"},\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/louistochon\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL Server 2025 In-Memory: New Cleanup Features &amp; SQLBits 2026 Insights - dbi Blog","description":"SQL Server 2025 finally allows dropping In-Memory filegroups, a breakthrough analyzed here alongside expert performance insights from SQLBits 2026.","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\/in-memory-tables-in-sql-server-2025-and-sqlbits-2026\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server 2025 In-Memory: New Cleanup Features &amp; SQLBits 2026 Insights","og_description":"SQL Server 2025 finally allows dropping In-Memory filegroups, a breakthrough analyzed here alongside expert performance insights from SQLBits 2026.","og_url":"https:\/\/www.dbi-services.com\/blog\/in-memory-tables-in-sql-server-2025-and-sqlbits-2026\/","og_site_name":"dbi Blog","article_published_time":"2026-05-10T19:29:35+00:00","og_image":[{"width":1920,"height":720,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2026\/04\/image-18.png","type":"image\/png"}],"author":"Louis Tochon","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Louis Tochon","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/in-memory-tables-in-sql-server-2025-and-sqlbits-2026\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/in-memory-tables-in-sql-server-2025-and-sqlbits-2026\/"},"author":{"name":"Louis Tochon","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/e4195b0cb120295b3407a502c23e75b6"},"headline":"SQL Server 2025 In-Memory: New Cleanup Features &amp; SQLBits 2026 Insights","datePublished":"2026-05-10T19:29:35+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/in-memory-tables-in-sql-server-2025-and-sqlbits-2026\/"},"wordCount":928,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/in-memory-tables-in-sql-server-2025-and-sqlbits-2026\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2026\/04\/image-18-1024x384.png","keywords":["inmemory","SQL Server","SQLBits"],"articleSection":["Development &amp; Performance","SQL Server"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/in-memory-tables-in-sql-server-2025-and-sqlbits-2026\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/in-memory-tables-in-sql-server-2025-and-sqlbits-2026\/","url":"https:\/\/www.dbi-services.com\/blog\/in-memory-tables-in-sql-server-2025-and-sqlbits-2026\/","name":"SQL Server 2025 In-Memory: New Cleanup Features &amp; SQLBits 2026 Insights - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/in-memory-tables-in-sql-server-2025-and-sqlbits-2026\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/in-memory-tables-in-sql-server-2025-and-sqlbits-2026\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2026\/04\/image-18-1024x384.png","datePublished":"2026-05-10T19:29:35+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/e4195b0cb120295b3407a502c23e75b6"},"description":"SQL Server 2025 finally allows dropping In-Memory filegroups, a breakthrough analyzed here alongside expert performance insights from SQLBits 2026.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/in-memory-tables-in-sql-server-2025-and-sqlbits-2026\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/in-memory-tables-in-sql-server-2025-and-sqlbits-2026\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/in-memory-tables-in-sql-server-2025-and-sqlbits-2026\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2026\/04\/image-18.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2026\/04\/image-18.png","width":1920,"height":720},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/in-memory-tables-in-sql-server-2025-and-sqlbits-2026\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server 2025 In-Memory: New Cleanup Features &amp; SQLBits 2026 Insights"}]},{"@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\/e4195b0cb120295b3407a502c23e75b6","name":"Louis Tochon","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/ce0ee48c64e763e6c4076e21c80729d15bc4493288aeb8695125c69082100e10?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/ce0ee48c64e763e6c4076e21c80729d15bc4493288aeb8695125c69082100e10?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ce0ee48c64e763e6c4076e21c80729d15bc4493288aeb8695125c69082100e10?s=96&d=mm&r=g","caption":"Louis Tochon"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/louistochon\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/44077","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\/157"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=44077"}],"version-history":[{"count":31,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/44077\/revisions"}],"predecessor-version":[{"id":44339,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/44077\/revisions\/44339"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=44077"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=44077"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=44077"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=44077"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}