by Uwe Ricken | Apr 7, 2025 | Level 300, SQL Challenges
Problem Description / Requirement This – simplified – problem arises from software that allows for individual customization to meet customer needs. A customer uses the software as a grading system for students at their university. A separate column has been...
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 | Feb 17, 2025 | Level 300, SQL Challenges
Problem Description / Requirement A new customer contacts you. Their developers have created a dashboard that contains five KPI components that visualize the importance of orders according to a given status. The status of an order can only have 3 states! high normal...
by Uwe Ricken | Feb 9, 2025 | Level 300, SQL Challenges, Uncategorized
Problem Description / Requirement The customer has developed an application that he himself has developed and swears by the use of user-defined functions. The developers argue that user-defined functions create reusable code that makes work easier. A calculated...
by Uwe Ricken | Feb 2, 2025 | Level 200, SQL Challenges
Problem Description / Requirement The software manufacturer’s database uses the [SQL_Latin1_General_CP1_CI_AS] collation for the application. The development team wrote a custom function that can be used to find customers based on an address search. 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...
