One feature introduced with SQL Server 2022 that I’ve recently been playing around with is IS [NOT] DISTINCT FROM. This new feature can help when it comes to dealing with NULL value comparisons.
Read on for examples. Do note that
x IS NOT DISTINCT FROM y does not provide a performance benefit over its equivalent of
x=y OR (x IS NULL AND y IS NULL).