What is Parameter Sniffing in SQL Server?

The bundled content focuses on internals, troubleshooting, query tuning, performance optimization, tips, tricks, and loads of content from the real world.

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

[shinychristian]

Well explained to easily understand Parameter Sniffing. Thank You!

[Rageshshah]

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

[igorpaixao]

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

[ahmad-murery]

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

[akbarmandozai]

Wow, excellent explanation and thank you for sharing😊

[tauseefakram]

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)

[xPooch]

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

[ganeshsonawane]

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!

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

[syedfarhan-qxhi]

Video is very blur hard to see any thing.