SQL Essentials: GROUP BY vs. PARTITION BY explained- READ POST

SQL Performance Tuning tips for newbies - READ POST