What is Parameter Sniffing in SQL Server?

Looking for comprehensive, deep-dive training on SQL Server Performance Tuning? Explore SQLMaestros All-In-One Performance Tuning Bundle. Five courses at a highly discounted price. sqlmaestros.co...
The bundled content focuses on internals, troubleshooting, query tuning, performance optimization, tips, tricks, and loads of content from the real world.
If you are a fan of live classes, you can explore the SQL Server Performance Tuning Master Class. 40 hours of deep-dive LIVE training. Attend LIVE & get the class recordings for a lifetime. sqlmaestros.co...

[@ArminEslami]

I had an interview half an hour before, and they asked me about parameter sniffing. The interview ended, I started to search for it, and here I am. You explain it well. Thanks a lot.

[@ahmad-murery]

Well explained and demonstrated. Knowing the ins and outs is a must to master SQL. More videos like this please. Thanks Amit!

[@igorpaixao5424]

Great content. For sure this class regarding parameter sniffing will be helpful im my next Tunning Analysis.

[@Rageshshah]

Well explained. Mr. Amit is good presenter. Keep sharing such knowledge to help people like us being more educated.

[@akbarmandozai6258]

Wow, excellent explanation and thank you for sharing😊

[@xp00ch]

What a great explanation, came across this today and hadn't heard of it before, now I know. Have my sub

[@ganeshsonawane9279]

Hi Amit , Thank you for all given videos that explained very well. Do you have any videos on Index Rebuild and Index Reorganize, and fragmentation. I would like to know more that is when, how, and purpose about it with some sort of example. Thank you!

[@Anilkumar-gr3mo]

Perfect example bro-thanks a lot

[@ashwanirajput953]

Well explained and demonstrated.

[@ganeshk5471]

very good! man

[@peadenl]

Nice statement of the problem. Why didn’t you show them how to fix it? I mean with conditional execution so the SP can go either way.

[@umakantkesgire7720]

Superb

[@syedfarhan-qx8hi]

Video is very blur hard to see any thing.

[@radheyshyambansal9056]

Manually choose high quality from settings