Optimization & Troubleshooting Microsoft SQL Server 2014 includes new features to provide optimal performance for applications. Discover some of these features and see how to optimize both queries and overall security in SQL Server 2014.