TSQL rewrites that do NOT fix the problem (5 minutes)

This isn't as simple to fix as you might think.

From subqueries to CTEs, the TSQL rewrites shown here don't fix the problem.

Back to: Why Creating an Index Can Slow Down A Query (1 hour 30 minutes) > Rewriting the query