Optimizing Scalar User-Defined Functions and Co-Related Subqueries in SQL Server

Understanding Left Outer Joins: How to Fix a Join That Isn't Returning Expected Results

Duplicating Rows in SQL Server Based on Column Values