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