SQL-Challenges - Improve your SQL Server Skills
  • Home
  • SQL Challenges
    • Level 200
    • Level 300
    • Level 400
  • Contact us
  • FAQ
Select Page
SQL Challenge #2 – Aggregations in Partitioned Tables

SQL Challenge #2 – Aggregations in Partitioned Tables

by Uwe Ricken | Jan 27, 2025 | Level 400, SQL Challenges

Problem Description / Requirement The customer operates a 45 TB data warehouse that is updated 24/7 with a frequence of 5 minutes. Partitioning is used on the biggest table to increase efficiency in loading processes. Before the loading starts the loading process must...

SQL Challenges

  • SQL Challenge #11 – inlined user defined functions 2026-03-14
  • SQL Challenge #10 – when Database Settings impact performance 2025-11-03
  • SQL Challenge #9 – When Estimates are wrong 2025-10-22
  • SQL Challenge #8 – Overlapping Time Series 2025-07-07
  • SQL Challenge #7 – Dynamically added attributes 2025-04-07
  • Imprint
  • Data Protection
  • RSS

db Berater GmbH | | Büchenweg 4 | 64390 Erzhausen | Phone: +49 (0) 6150 5082955 | E-Mail: info@db-berater.de |    Umsetzung