UNION vs. UNION ALL in SQL Server

UNION vs. UNION ALL in SQL Server