[dba-SQLServer] SQL 2016 Community Preview

[Jim Lawrence]

Hi Arthur:

It looks like a great set of features. Oracle had memory table support back as far as version 10 (2004) and it was fully featured by version 11 and 12.

Ms looks like it has pulled ahead a bit. Are there beta version available yet?

Jim
 
----- Original Message ----- 

From: "Arthur Fuller" <fuller.artful at gmail.com> 
To: "Discussion concerning MS SQL Server" <dba-sqlserver at databaseadvisors.com> 
Sent: Wednesday, March 30, 2016 3:00:26 AM 
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