If you want to learn more about SQL Server or other Microsoft products, you should…
An interesting aspect of the new in-memory tables (Hekato) in the upcomming SQL server 2014, is the intirely lock free writes! You can read more about it at:
http://www.infoq.com/news/2013/09/Lock-Free-Writes
and download the Hekaton White paper from:
Håkan Winther:
Twitter: https://twitter.com/h_winther