The problem arises when the hierarchy level increases as SQL Server is limited to 32 levels of recursion. We need a better way to implement recursive queries in SQL Server 2005. How do we do it?  Read more...

Two useful functions for dealing with hierarchical data.  Read more...

A discussion on using CTEs to speed the development and maintenance of reports and enhance readability.  Read more...

They are new to SQL Server in 2005, but they are not necessarily in common use for many people. New author Kirk Kuykendall brings us a basic look on what a CTE is and how you can use it.  Read more...

SQL Server 2005 brings a new feature to T-SQL with Common Table Expressions, which make it possible for more complex subquery expressions than in previous versions. Recursion is a common use and Peter He takes a look at how well these new structures perform.   Read more...

Some new interresting points about trees and CTE in SQL Server : transforming a tree from auto reference to interval model (nested sets), calculating levels in interval model, creating a view of auto ref from an interval model, hierarchical numbering of items, and more. This article includes more examples based on his previous work.   Read more...

SQL Server 2005 brings a new feature to T-SQL with Common Table Expressions, which make it possible for more complex subquery expressions than in previous versions. Recursion is a common use and Peter He takes a look at how well these new structures perform.   Read more...