we've always been forced to include this additional IS NULL or IS NOT NULL syntax. This not only clutters T-SQL code, but forces the execution plan to use an index scan. In SQL Server 2022, we have a ...