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 ...

Get Microsoft SQL Server 2014 Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.