Let SQL Server be able to process data as effective as possible and do not confuse the optimizer and query plan caching mechanisms with logic in your SQL code.
This Tony Davis editorial points it out once again. There are generally lack of knowledge regarding this amongst database developers. This is important because it is a common cause of performance problems and database servers becoming bottlenecks.
Read it here: Tony Davis editorial on SQLServerCentral.com