SentryOne Team Blog (blogs.sentryone.com)

Tag : execution plan

Paul White : Rewriting Queries to Improve Performance

Paul White (@SQL_Kiwi) looks at a couple of cases where – even though T-SQL is supposed to be a declarative language, and any query that uses the same logic and same semantics should ultimately lead to the same plan and comparable performance – rewriting queries can change the plan in dramatic ways.