Can you recompile natively compiled InMemory stored procedures? I test recompiling InMemory OLTP objects in SQL Server 2016 with a step by step demo.
SQL SERVER – InMemory Tables on SQL Azure DB
Can you create InMemory tables on SQL Azure? From V12 you can. I check it with SERVERPROPERTY(‘IsXTPSupported’) and then create an InMemory table.
SQL SERVER – How to take InMemory – OLTP FileGroup Offline?
Can you take an InMemory OLTP filegroup offline, and what happens to the table data? I test it step by step using the database from my earlier post.
SQL SERVER – How to Identify InMemory Objects Can be Identified in SQL Server?
Is InMemory OLTP eating all my memory? Here is a step by step way to identify InMemory objects and see how much memory they use in SQL Server.
SQL SERVER – Using Buffer Pool Extension with In-Memory OLTP?
A reader who watched my Pluralsight course asked whether Buffer Pool Extension works with In-Memory OLTP in SQL Server 2014. Here is what I found.
SQL SERVER – Error: Msg 701, Level 17, State 103. There is insufficient system memory in resource
Fix SQL Server Msg 701, there is insufficient system memory in resource pool, when In-Memory OLTP tables run out of memory. With a script.
SQL SERVER – Identify and Filter In-Memory Optimized Tables – SQL in Sixty Seconds #079
How to identify and filter In-Memory Optimized Tables in SQL Server Management Studio, shown in a quick SQL in Sixty Seconds video.