Parameter Sniffing in Stored Procedures in SQL Server 2008/2008 R2

Parameter Sniffing in Stored Procedures in SQL Server 2005/2008/2008 R2 Today let me cover one of a good topic on Parameter Sniffing in Stored Procedures: Paramater Sniffing is not a unexpected behaviour when passing parameters into Store Procedure. CREATE procedure [dbo].[Usp_Test_SP] @Category as [nvarchar](60)=null as select Category ,Description,WorkOrder,Date Added from TestTable where (sc.session_class_desc like @Category…