3 ms·
> I thought (although I could easily be mistaken) that one of the big features about SQL Server 2014 was its lock free tables [1]. Same feature, just a differe
by BrentOzar 13y ago
> I thought (although I could easily be mistaken) that one of the big features about SQL Server 2014 was its lock free tables [1].
Same feature, just a different benefit. Hekaton's tables are pinned to memory, use a different storage structure, can have their T-SQL statements compiled to native code, and avoid locking.