What are the new features in SQL Server 2014?
This feature helps SQL Server Buffer pool to store
larger worksets in the pool, hence make
SQL Server 2014 more efficient in its operations.
Resource Governor helps to control your resources such as CPU, IO etc. In SQL Server 2014 you can assign physical I/O resource of a particular resource pool, depending upon priority and urgency of the operation, this value can be set to manipulate the resources in SQL Server 2014
This feature will allow you to create or update statistics of a particular partition if your table is partitioned. Before that, you had to update statistics of the whole table
Online index operation progress can be monitored real time as partitionID and PartitionNumber column is added in SQL Server 2014 and you can query the progress in order to get real time status of online index rebuild Job
Compatibility 90 (SQL Server 2005) is not valid in SQL Server 2014