I would suggest picking up Bill Karwin's book on SQL Antipatterns. He goes through a few ideas. I found this slide show from him. It covers the same ideas: ht

I would suggest picking up Bill Karwin's book on SQL Antipatterns. He goes through a few ideas. I found this slide show from him. It covers the same ideas: https://www.slideshare.net/billkarwin/models-for-hierarchical-data https://www.slideshare.net/billkarwin/models-for-hierarchica...