Session Title: Defeating Parameter Sniffing With Dynamic SQL
Speaker: Erik Darling
Abstract: Parameter sniffing can be a huge performance problem, and fixing it can feel like an exercise in futility. If you’re ready to go beyond recompiles and unknowns and solve problems for real, come to this session. I’ll teach you techniques to fix parameter sniffing problems for good.
#SQLServer #Performance #Query #Index #Query-Plan #Tuning
300+ sessions are now available on-demand from Data Platform Summit 2021 & 2020 at no cost. Browse all sessions.
Stay tuned, more learning coming your way.