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 | Jul 7, 2025 | Level 400, SQL Challenges
Problem Description / Requirement This example comes from a customer from the automtive sector. Whenever a vehicle is built, EVERY single step must be precisely recorded. So-called “telegrams” are used for this purpose. These telegrams can convey simple...
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...
