I got this question/claim again this week, so I’ll write a blog post on it while I wait for my build to complete: It usually goes something like “When I rewrite my query, SQL Server gives me a different plan.  Therefore, I should rewrite all my queries...