I was experimenting with these, In-Memory OLTP tables. 2014. Lots of disadvantages:
- no FKs
- can't alter table
- no varchar(max)
Made me wonder, has anyone used these? How was the experience?
In one scenario, I tried running 2 identical queries, one on an OLTP in-memory table and one using the regular table. In the execution plan, the cost was 99 to 1. But when I timed it with SET STATISTICS TIME ON, it's more like 60/40.