Adam Machanic : ISNULL, Optimizationhttp://www2.sqlblog.com/blogs/adam_machanic/archive/tags/ISNULL/Optimization/default.aspxTags: ISNULL, OptimizationenCommunityServer 2.1 SP2 (Build: 61129.1)Revisiting ISNULL, COALESCE, and the Perils of Micro-Optimizationhttp://www2.sqlblog.com/blogs/adam_machanic/archive/2010/06/30/isnull-coalesce-and-micro-optimization.aspxWed, 30 Jun 2010 17:12:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:25637Adam Machanic9http://www2.sqlblog.com/blogs/adam_machanic/comments/25637.aspxhttp://www2.sqlblog.com/blogs/adam_machanic/commentrss.aspx?PostID=25637Almost six years ago--in November of 2004--I posted what would turn out to be one of my most popular blog posts in terms of number of reads, " Performance: ISNULL vs. COALESCE ." (If you're curious, the post is dated July 2006 because I was too lazy it...(<a href="http://www2.sqlblog.com/blogs/adam_machanic/archive/2010/06/30/isnull-coalesce-and-micro-optimization.aspx">read more</a>)<img src="http://www2.sqlblog.com/aggbug.aspx?PostID=25637" width="1" height="1">PerformanceOptimizationISNULLCOALESCEnullability