[dba-SQLServer] SQL 2016 Community Preview

[Darryl Collins]

Thanks Arthur, that looks interesting.  Any word if the 'in memory tables' are going to be available in the Express version of SQL 2016?
In my situation, the risk of data loss wouldn't  be an issue as SQL Server is merely used as a way of converting a large txt file into a series of outputs.  If it all failed nothing would be lost, so the performance gain is attractive and desirable.

Cheers
Darryl.

-----Original Message-----
From: dba-SQLServer [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: 30 March, 2016 9:00 PM
To: Discussion concerning MS SQL Server
Subject: [dba-SQLServer] SQL 2016 Community Preview

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
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com