Author: Basit Farooq
Understanding SQL Server Query Optimization – Part 3
SQL Server Hardware Optimization
Multiple Table Queries in SQL Server – UNION, EXCEPT, INTERSECT, Subqueries, and Joins
Tips For Minimizing Deadlocks in SQL Server
Capture SQL Server Deadlocks using Extended Events
SQL Server 2014 Performance Tuning – Columnstore Indexes
SQL Server 2014 Performance – Resource Governor Enhancements and Buffer Pool Extension
Four Key New Performance Features SQL Server 2014 – Part 1
SQL Server 2014: Encryption for Backups