[dba-SQLServer] SQL 2016 Community Preview

[Arthur Fuller]

Anyone who's played with SQL 2014's in-memory tables was no doubt
frustrated by the option's rather severe limitations. Good news. SQL 2016
has removed almost all the limitations, replacing them with a couple of
design-time settings. But all in all, it's a huge win, and makes it
possible, given enough RAM, to make an entire OLTP database live in RAM.
Needless to say, the performance gain would be significant. Obviously, one
would have to schedule the writes back to disk, or risk losing the
in-memory transactions in the event of system failure or accidental
shutdown. But those are merely planning issues. For a little more
information, click here
<http://www.vertabelo.com/blog/technical-articles/exploring-sql-server-2016-powerful-new-features>
.

-- 
Arthur