Using Case Expressions to Simplify Aggregate Functions in SQL

Understanding SSRS Performance: Filter Property vs WHERE Condition

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