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

Overview of the SQL Delete statement

SQL DELETE Statement Examples and Best Practices

Delete vs Truncate SQL Server Quick Reference Guide

Working with SQL NULL values

How to Use SQL Server Coalesce to Work with NULL Values