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...
