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-hierarchica...