Query Parameterization and Plan Forcing

If you like what you see here, you'll love my advanced performance tuning training:
learn.erikdarling.com/
In this video, we're going to look at how Query Store treats queries that use literal values vs queries that use parameters, and how it can mess with forcing the right execution plan for a query.

[@minnrick7986]

Thanks Erik, extremely informative as always. Question: Are there any special syntactical rules that apply when trying to use parameterized SQL (the proper kind) and one of the variables is an OUTPUT? I'm doing some tuning and have run into some plan reuse headaches when OUTPUT variables are involved.

[@ErikDarlingData]

I haven't run into that. Can you share a repro using a GitHub gist or something?

[@dinsharma1409]

where do I get those script plz?

[@ErikDarlingData]

Sorry, I never published them anywhere.

[@dinsharma1409]

:(