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.
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.
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.
Aaron Bertrand (@AaronBertrand) of SQL Sentry gives some quick advice about SQL Server 2014 CTP1: Plan to install it in its own virtual machine, because at this point it doesn't play well with others.
I had a great time at the MVP Summit last week. Caught up with a lot of friends, tried some new foods (including Tempura Fried Kurobuta Bacon), and took in some great technical sessions.