trees in sql – no more nested sets?

I looked for sql trees on the net, and it seems there is another method called ‘nested intervals with farey fractions’. This is really heavy math stuff, but looks interesting. Obviously it gets around the problem that on average half of the total nodes of an SQL nested set table must be updated if you [...]

SQL Design Patterns

Oh man, I desperatly need this book:
http://www.rampant-books.com/book_2006_1_sql_coding_styles.htm
Too bad it will be published first in October 2007… *grr* It’s so hard to get valuable information on professional SQL usage.