SQL SERVER 2014
THE 4 NE FEATURES
YOU NEED TO KNOW
□�-------�□ QHEKATON
An enterprise feature, Hekaton is a big plus for businesses concerned with large-scale transaction processing.
0 ENCRYPTED BACKUPS A tremendous asset for organizations concerned with security. (Hint: This should be ALL organizations.)
�CLUSTERED � COLUMNSTORE INDEXES Building on the columnstore indexes introduced in SQL Server 2012, clustered columnstore indexes provide query execution performance that will benefit data warehouse administrators and business analysts, although it may not be as advantageous in the day-to-day conduct of the business.
0 ESTIMATION IMPROVED CARDINALITY While it may sound a bit academic, "cardinality estimation" is an important part of creating well optimized query execution plans. Improvements in cardinality estimation result in better execution plans; this will be an important advantage to the analysts and business intelligence architects concerned with the performance of large, complex queries.
#SQL2014 LearningTree.com/SQL