IF Branching In SQL Server Stored Procedures: Fixing Parameters, Recompiling, And A Good Enough Plan

[@FlaggedStar]

9:12 Oh boy. I've been waiting a long time to find a one-stop shop for Erik talking about IS NULL tricks. I love this!

[@ErikDarlingData]

Stop early, stop often!

[@markallisonparamotor]

That's cool, the difference between WITH RECOMPILE and OPTION RECOMPILE. Nice. 👍

[@ErikDarlingData]

Yeah, it's a tricky little thing there.

[@GroterRonald]

Thanks Erik, just bought the Video collection👍

[@ErikDarlingData]

Hurray! Thanks for your support!

[@ЕвгенийЕжов-ц3к]

Great topic, great explanations! Thank you very much, Erik :)

[@ErikDarlingData]

Thank you! Happy to hear they’re useful to you.

[@romainferraton9529]

Really excellents explanations, crystal clear ! thanks

[@ErikDarlingData]

Thank you!

[@douglascoats7081]

im eagerly awaiting for the special guest sp_executesql to show up in this series of videos lol

[@ErikDarlingData]

Did you forget some letters there

[@douglascoats7081]

@@ErikDarlingData oh shit i didnt realize i left out the last 3 LOL