Old catalog views still answer, but their page counts can be far too small. A short demo shows the gap and how to replace them.
SQL SERVER – Parallelism for Heap Scan
Two DBAs asked me if their table needed a clustered index. Our conversation during a Health Check turned into a lesson on parallelism for Heap Scan.
SQL Authroity News – Optimizing Lazy Spool – PASS Blog
A sneak preview of my SQLPASS sessions: I wrote about optimizing Lazy Spool on the PASS blog, and here are the first two paragraphs with a link to the rest.
Asynchronous Statistics Updates: When They Help and When They Hurt
Evaluate asynchronous statistics updates against compile latency, data-change timing, and low-priority metadata locking in SQL Server.
Intelligent Query Processing: Checking What Is On per Database
Check intelligent query processing by database compatibility level, scoped switches, and actual plan evidence before comparing servers.
Inline Table-Valued Functions: Parameterized Views That Stay Fast
Compare inline table-valued functions with scalar functions, preserve customer results, and inspect plans before claiming performance gains.







