Use SQL Server to tackle problems that are easy to formulate but extremely difficult to solve ...

With over 20 years of programming experience, you formulate the complicated SQL statements every day, you know every trick with GROUP BY or exotic JOINs in the right place and then suddenly there is a typical head nut: very easy to formulate, the task can be grasped immediately ... but already when looking for an approach, your own brain threatens to become knotted ...

We look at a few of the most extreme examples of this genre and learn which tools Microsoft has integrated into SQL Server and T-SQL over the years to master such challenges. The questions are chosen so that everyone can follow them without any problems and no abstract scientific treatises are necessary. If you think outside the box in the right place, swap the previous standard view for a more unconventional variant and have mastered your tools, the solution is more or less obvious. And surprisingly, you can suddenly use the solution approach more and more successfully in everyday life as soon as you know it.