What's wrong with this SQL NULL filter?

What's wrong with this SQL NULL filter in a cleanup job. The SQL code uses = NULL instead of IS NULL, so the filter never matches. In SQL maintenance this leaves stale rows forever.

#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldataintegrity #sqlengineering #sqlnullfilter #sqlisnull #sqlcleanup #sqlmaintenance

https://www.youtube.com/watch?v=ZHHKIl9G2Uo

How to Repair SQL Database using DBCC CHECKDB Command?

THE DBCC CHECKDB command can help you check and repair the logical and physical integrity of the pages, indexes, and other objects in the selected database.

https://www.startupeditor.com/how-to-repair-sql-database-using-dbcc-checkdb-command/

#SQLServer #DBCCCHECKDB #SQLDatabase #DatabaseRepair
#SQLCorruption #MSSQLServer
#DatabaseRecovery #SQLAdmin
#SQLMaintenance #SQLCommands

https://www.startupeditor.com