Different ways to SQL delete duplicate rows from a SQL Table

Avoid using NOLOCK on SQL Server UPDATE and DELETE statements

SQL Server MERGE to insert, update and delete at the same time

SQL DELETE Statement (Transact SQL) - Essential SQL

Overview of the SQL Delete statement

SQL DELETE Statement Examples and Best Practices

Working with SQL NULL values

SQL: IS NULL Condition

Join SQL Server tables where columns include NULL values