SQLBits 2011

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.

Speaker

Milos Radivojevic is a database developer and consultant, speaker, and trainer located in Vienna, Austria. He is Microsoft SQL Server MVP and MCT and specializes in SQL Server for application developers. He is co-leader of the SQL Server PASS Austria

Milos Radivojevic's Sessions

Transact SQL Performance Tips

TSQL Performance Tips

Parameter Sniffing Problem with Stored Procedures

TSQL Performance Recommendations