Different ways to SQL delete duplicate rows from a SQL Table

DELETE CASCADE and UPDATE CASCADE in SQL Server foreign key

Avoid using NOLOCK on SQL Server UPDATE and DELETE statements

SQL DELETE Statement (Transact SQL) - Essential SQL

SQL DELETE Statement Examples and Best Practices

Overview of the SQL Delete statement

Working with SQL NULL values

Join SQL Server tables where columns include NULL values

How to Use SQL Server Coalesce to Work with NULL Values