Summary

In this chapter, we have discussed some of the new performance features of SQL Server 2014 that can help improve your database performance. We looked at partition switching and indexing, discussed some of the improvements in columnstore indexing, and looked at the enhancements in the Resource Governor and how changes to the cardinality estimator work. Hopefully, there is something that you can make use of from these improvements in your databases to improve their performance. As you can see, SQL Server 2014 has some great new features for the DBA. These new features will allow the DBA to implement a more robust and highly available production environment. The enhancements and changes to some of the SQL Server performance features, namely In-Memory Optimized tables and Delayed Durability, provide the DBA with an additional set of tools to get their databases performing at an optimal level.