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]. [1] http://sqlserverrider.word
by chacham15 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].
[1] http://sqlserverrider.wordpress.com/2012/12/31/hekaton-recap-sql-server-in-memory-technology/ http://sqlserverrider.wordpress.com/2012/12/31/hekaton-recap...
- 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.