SQL - Hierarchical data in RDBMS

[fish-404]

Troels' links: Relational database systems https://learn.microsoft.com/en-us/sql/t-sql/data-types/hierarchyid-data-type-method-reference?view=sql-server-ver16&source=docs https://learn.microsoft.com/en-us/sql/t-sql/queries/with-common-table-expression-transact-sql?view=sql-server-ver16#guidelines-for-creating-and-using-common-table-expressions https://stackoverflow.com/questions/51176971/how-do-recursive-ctes-work-in-sql-server Tutorial: Using the hierarchyid Data Type - SQL Server | Microsoft Learn

[fish-404]

Performance:

• The Performance of Traversing of Traversing a SQL Hierarchy
  • Identify Subsequence in Sqeuence
  • Divide and Conquer Halloween

Related:

• The Halloween Problem