Performance Tuning Multiple Table Queries in SQL Server – UNION, EXCEPT, INTERSECT, Subqueries, and Joins
Performance Tuning SQL Server 2014 Performance – Resource Governor Enhancements and Buffer Pool Extension