by Uwe Ricken | Mar 14, 2026 | Level 200, SQL Challenges
Problem Description / Requirement A developer has heard from the new feature “Scalar UDF Inlining” and he wanted to improve a stored procedure [dbo].[get_last_order_months].This stored procedure is called 10 to 100 times per hour by the marketing...
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...
