Improving Query Performance with Composite Primary Keys in T-SQL

Handling Moving Averages and NULL Values in TSQL: Best Practices for Resilient Data Analysis

Using a Common Table Expression (CTE) to Dynamically Generate Column Headings in Stored Procedures

Merging Overlapping Date Ranges in SQL Server 2014

Subtracting Values from One Column Based on Conditions in Another Using TSQL Techniques