Query Optimization: Filtering Rows with Common Values Across Columns

Unioning and Grouping Rows with SQL Window Functions, Common Table Expressions, and Subqueries for Data Analysis

Using UNION with Common Table Expressions in SQL Server 2014 Developer: Workarounds and Best Practices