http://blogs.msdn.com/cbiyikoglu/archive/2005/11/03/488920.aspxAs the optimizer gets more and more sophisticated, cost of optimization naturally increases. When that is the case; simple and forced parameterization comes to the rescue (much like you neighborhood plumber). These features simply allow the reuse of executionen-USCommunityServer 2.1 SP1 (Build: 61025.2)http://blogs.msdn.com/cbiyikoglu/archive/2005/11/03/488920.aspx#587298Mon, 01 May 2006 04:16:15 GMT91d46819-8472-40ad-a661-2c78acb4018c:587298Real Life Microsoft ITIs it my imagination or is&amp;amp;nbsp;2005 running slower?My first impresson&amp;amp;nbsp;with SQL Server 2005 came...http://blogs.msdn.com/cbiyikoglu/archive/2005/11/03/488920.aspx#587300Mon, 01 May 2006 04:27:46 GMT91d46819-8472-40ad-a661-2c78acb4018c:587300Real Life Microsoft ITIs it my imagination or is&amp;amp;nbsp;2005 running slower?My first impresson&amp;amp;nbsp;with SQL Server 2005 came...http://blogs.msdn.com/cbiyikoglu/archive/2005/11/03/488920.aspx#4026055Tue, 24 Jul 2007 13:02:27 GMT91d46819-8472-40ad-a661-2c78acb4018c:4026055SQL Server Transact-SQL (SSQA.net)<p>You may be aware using SP_WHO or SP_WHO2 statements you can get information about a session id and statement</p>