Erin Stellato uses a simple example to demonstrate the performance benefits you might expect from enabling memory-optimized tempdb metadata in SQL Server 2019.
Erin Stellato (@erinstellato) takes a thorough look at the way DML statements might benefit from In-Memory OLTP, especially with natively compiled stored procedures.
With additional tests comparing splitting techniques to TVPs, Aaron Bertrand (@AaronBertrand) rounds out his series on STRING_SPLIT() in SQL Server 2016.
Aaron Bertrand (@AaronBertrand) takes a quick look at a couple of things you should be careful about when calling natively-compiled Hekaton stored procedures in SQL Server 2014.
Paul White (@SQL_Kiwi) concludes his two-part series on SQL Server sort internals, including two new classes specific to In-Memory OLTP in SQL Server 2014.
SQL Sentry's Aaron Bertrand (@AaronBertrand) talks a little more about in-memory table-valued parameters, and explains why some scenarios you test may not demonstrate the power of this technology.
SQL Sentry's Aaron Bertrand (@AaronBertrand) highlights a couple of potential problems discovered in various AdventureWorks-based In-Memory OLTP samples out there, and how to work around them.
SQL Sentry's Aaron Bertrand (@AaronBertrand) investigates a new possibility in SQL Server 2014: creating and using memory-optimized table-valued parameters.