Daily Archives: Sep 10, 2014


New features in SQL Server 2014 (In Database Engine)

New features added in SQL 2014 (Headings only)

Below are the enhancement points list :

Database Engine Feature Enhancements
o    Memory-Optimized Tables
o    SQL Server Data Files in Windows Azure
o    Host a SQL Server Database in a Windows Azure Virtual Machine
o    Backup and Restore Enhancements
o    New Design for Cardinality Estimation
o    Delayed Durability
o    AlwaysOn Enhancements
o    Partition Switching and Indexing
o    Managing the Lock Priority of Online Operations
o    Columnstore Indexes
o    Buffer Pool Extension
o    Incremental Statistics
o    Resource Governor Enhancements for Physical IO Control
o    Online Index Operation Event Class
o    Database Compatibility Level
·         Transact-SQL Enhancements
·         System View Enhancements
·         Security Enhancements
·         Deployment Enhancements

Visit below link for details;

http://msdn.microsoft.com/en-in/library/bb510411.aspxMore