SQL Challenges
Troubleshoot real word scenarios with Microsoft SQL Server
SQL Challenge #10 – when Database Settings impact performance
SQL Challenge #9 – When Estimates are wrong
SQL Challenge #8 – Overlapping Time Series
SQL Challenge #7 – Dynamically added attributes
SQL Challenge #6 – Locking locks your SQL Server
SQL Challenge #5 – When Constraints not work
SQL Challenge #4 – Nightmares with User Defined Functions
SQL Challenge #3 – Case Sensitive Searches
SQL Challenge #2 – Aggregations in Partitioned Tables