by Uwe Ricken | Nov 3, 2025 | Level 200, SQL Challenges
Problem Description / Requirement A customer is reporting a deterioration in the performance of all queries after the software vendor updated the database objects using a T-SQL script. After the vendor completed the updates, the customer discovered that the query row...
by Uwe Ricken | Oct 22, 2025 | Level 200, SQL Challenges
Problem Description / Requirement This example comes from a software application that has strictly implemented its relational model. The challenge uses two tables linked by referential integrity. The [dbo].[marketsegments] table serves as a reference table for the...
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 20, 2025 | Level 200, SQL Challenges
Problem Description / Requirement The marketing department of db Berater GmbH is planning a private event for its 10 TOP customers. The marketing department provides the following guidelines for selecting customers: Only customers with at least 3 orders in the last...
