Most Recent4.0 Useful Queries on DMV’s to understand Plan Cache Behavior2.0 Diagnosing Plan Cache Related Performance Problems and Suggested SolutionsIndex Build strategy in SQL Server - Part 3: Offline Serial/Parallel Partitioning (Aligned partitioned parallel index build)12.0 Plan Cache Trace Events and Performance Counters11.0 Temporary Tables, Table Variables and RecompilesFixing damaged pages using page restore or manual inserts10.0 Plan Cache FlushIndex Build strategy in SQL Server - Part 3: Offline Serial/Parallel Partitioning9.0 Memory Pressure Limits8.0 Factors that Affect Batch Cache-ability
