New posts in Hierarchical Data

How can I break referential integrity briefly, within a transaction, without disabling the foreign key constraint?

SQL Server 2005 database design - many-to-many relationships with hierarchy

Getting all parent rows in one SQL query

Simplest way to do a recursive self-join?

Hierarchical Data Models: Adjacency List vs. Nested Sets

Move node in nested set

What is the most efficient/elegant way to parse a flat table into a tree?