Question: is isnull faster than coalesce?
Answer: 8) Speed. ISNULL is faster than COALESCE in SQL Server because of its a built-in function implemented in the Database engine, while COALESCE translates to CASE statements.