gregdodd.me
Using OPTION (RECOMPILE)
This week, I was trying to improve the performance of a bit of SQL and noticed that it generated significantly different query plans depending on the parameters passed in. So I tried to work out ho…