Chad Callihan is distinguished:
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)
.