SQL Server 2008 R2 Cumulative Update 2, SQL Server 2008 SP1 Cumulative Update 7 and SQL Server 2005 SP3 Cumulative Update 9 introduce trace flag 4136 that can be used to disable the "parameter sniffing" process posted on Jan 11, 2011 von Frank Kalis in Links
Using the RECOMPILE Query Hint to Solve Parameter Sniffing Problems posted on Aug 13, 2010 von Frank Kalis in Links