SQL Server Internals: Plan Caching Pt. II – Recompiling Plans
SQL Server Internals: Plan Caching Pt. I – Reusing Plans
SQL Server Internals: Problematic Operators Pt. III – Sorts
SQL Server Internals: Problematic Operators Pt. II – Hashing
SQL Server Internals: Problematic Operators Pt. I – Scans