Your stored procedure is slow in the application, but works perfect in SSMS! In this presentation it will be clarified why this happens 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.
(no tags)
Presented by Milos Radivojevic at SQLBits XIV
MP4 Video HD 685 MB