scarydba.com
When Simple Parameterization...Isn't - Grant Fritchey
Nothing in SQL Server is easy and there's always more to learn. This blog post talks about issues with simple parameterization that are not readily apparent by simply looking at the execution plan.