db-berater-server

SQL Challenges

Troubleshoot real word scenarios with Microsoft SQL Server

SQL Challenge #8 – Overlapping Time Series

SQL Challenge #8 – Overlapping Time Series

by Uwe Ricken | 07/07/2525

SQL Challenge #7 – Dynamically added attributes

SQL Challenge #7 – Dynamically added attributes

by Uwe Ricken | 04/07/2525

SQL Challenge #6 – Locking locks your SQL Server

SQL Challenge #6 – Locking locks your SQL Server

by Uwe Ricken | 03/03/2525

SQL Challenge #5 – When Constraints not work

SQL Challenge #5 – When Constraints not work

by Uwe Ricken | 02/17/2525

SQL Challenge #4 – Nightmares with User Defined Functions

SQL Challenge #4 – Nightmares with User Defined Functions

by Uwe Ricken | 02/09/2525

SQL Challenge #3 – Case Sensitive Searches

SQL Challenge #3 – Case Sensitive Searches

by Uwe Ricken | 02/02/2525

SQL Challenge #2 – Aggregations in Partitioned Tables

SQL Challenge #2 – Aggregations in Partitioned Tables

by Uwe Ricken | 01/27/2525

SQL Challenge #1 – When the marketing department calls

SQL Challenge #1 – When the marketing department calls

by Uwe Ricken | 01/20/2525

SQL Challenges

SQL Challenge #8 – Overlapping Time Series 2025-07-07
SQL Challenge #7 – Dynamically added attributes 2025-04-07
SQL Challenge #6 – Locking locks your SQL Server 2025-03-03
SQL Challenge #5 – When Constraints not work 2025-02-17
SQL Challenge #4 – Nightmares with User Defined Functions 2025-02-09