Parameter Sniffing Problem with Stored Procedures

In this presentation it will be clarified when and why parameter sniffing is a problem in SQL Server stored procedures. Of course we will offer several solutions for this problem and discuss which solution is applicable in which scenario.
Tags (no tags)
  • Downloads
  • SpeakerBIO

    Milos Radivojevic is a database developer, consultant, speaker, and trainer located in Vienna, Austria. He has been working with SQL Server over 15 years. He is Microsoft SQL Server MVP and MCT and specializes in SQL Server for application developers and performance and query tuning. Currently he works as principal database consultant in (the largest regulated online gaming company in the world) where he works with some of the largest SQL Server databases. He is co-leader of the SQL Server PASS Austria. He is a speaker in international conferences (SQLBits, SQL Saturday, Sinergija, SQL Conference) and speaks regularly at SQL Server PASS Austria meetings. His Twitter handle is @MilosSQL.
  • Video