How to Track Performance of Queries That Use RECOMPILE Hints
Say we have a stored procedure that has two queries in it - the second query uses a recompile hint, and you might recognize it from my parameter sniffing session:
[crayon-6a42713385bfe683299346/]
The first query will always get the same plan, but the second query will get different plans and return different numbers of rows depending on which reputation we pass in.