What is Parameter Sniffing in SQL Server?

[@tauseefakram90]

Got a sample question on #ParameterSniffing in DP-300 exam and landed to this video. I would have loved to see the Optimize for hint fix as well. Nonetheless, the explanation is clear and informative. Thank You ! (y)

[@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.

[@akbarmandozai6258]

Wow, excellent explanation and thank you for sharing😊

[@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.

[@ahmad-murery]

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

[@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

[@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.

[@ganeshk5471]

very good! man

[@ashwanirajput953]

Well explained and demonstrated.

[@umakantkesgire7720]

Superb

[@syedfarhan-qx8hi]

Video is very blur hard to see any thing.

[@radheyshyambansal9056]

Manually choose high quality from settings