Please help me reach 1M subscribers.
Welcome to my channel.
Hope you glad with my videos.
Like and subscribe to support me.
Thanks.
"Unparameterize" should be "Unparameterized"
Parameter Sniffing
OPTIMIZE FOR UNKNOWN
00:00 Issue with "Parameter Sniffing" in SQL Server
00:21 Brief definition of "Parameter Sniffing"
01:10 Common ways fix "Parameter Sniffing" issue
01:19 "RECOMPILE" hint
01:42 Unparameterized query
01:54 "OPTIMIZE FOR" hint with specific parameters
02:04 Force the use of a specific index
02:14 Use a plan guide
02:25 "OPTIMIZE FOR UNKNOWN" hint
02:49 Recap
03:01 Next video plan
03:08 Feedback and subscribe
#sqlserver
#parametersniffing
#parameter
#performance
#tunning
#query
