peter-757102 (6/7/2012)
In SQL Server 2008, there is a query hint that circumvents optimization for specific values:option( optimize for unknown )
This results in plans that are value agnostic and deliver more constant performance.
Peter, Thanks for the tip. That looks useful.