by Uwe Ricken | Jul 7, 2025 | Level 400, SQL Challenges
Problem Description / Requirement This example comes from a customer from the automtive sector. Whenever a vehicle is built, EVERY single step must be precisely recorded. So-called “telegrams” are used for this purpose. These telegrams can convey simple...
by Uwe Ricken | Mar 3, 2025 | Level 400, SQL Challenges
Problem Description / Requirement Your customer is using new software in the company. This software uses its own logic for protocol measures and locks because – presumably – the concept of intelligent locking is not known. Before each query is called, the...
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...
