As being the guest author on Itzik Ben Gan’s Inside MS SQL Server 2005: T-SQL Querying book, this blog might seem boasting to you. However, I did not write anything in the chapter 9 – Graphs, Trees, Hierarchies and Recursive Queries, and I am talking about this chapter. In a single day, I used the following solutions from the chapter:

          a tree;

          a directed acyclic graph;

          a undirected cyclic weighted graph;

          path enumerations;

          materialized path;

          transitive closure of the undirected cyclic weighted graph;

          all kinds of queries from the chapter.


I never used so much code and examples from a book directly in a project. This saved me days of work. Thanks, Yatz!

Dejan Sarka

Independent Consultant at Dejan Sarka S.P.
I am a trainer and consultant that focus on development of database & business intelligence applications.

Besides projects, I spend about half of the time on training and mentoring. I am the founder of the Slovenian SQL Server and .NET Users Group. and the main author or coauthor of eleven books about databases and SQL Server. I also developed many courses and seminars for SolidQ.
Dejan Sarka