Microsoft SQL Server 2014 Unleashed
by Ray Rankins, Paul Bertucci, Chris Gallelli, Alex T. Silverstein
What’s New in SQL Server 2014
The good news is that overall, the management of tables and their related columns has remained relatively unchanged in SQL Server 2014. You will find that the facilities available in the SQL Server Management Studio are as familiar and as easy to use as they were in SQL Server 2012. However, SQL Server 2014 does introduce the new concept of memory optimized tables as part of the new In-Memory OLTP features. Memory-optimized tables reside entirely in memory with a second copy of the table data maintained on disk, but only for durability purposes. Because memory-optimized tables are so tightly integrated with the other In-Memory OLTP features, creation, altering, and maintaining memory optimized tables is discussed ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access