I am working with T-SQL and read that CTE is better than subqeries when working with Trees. I am not familiar with the term Tree with regards to T-SQL. Any ideas on what this is and how it is used in T-SQL ? Thanks for any feedback.
To simplify the things over here, the SQL Tree is nothing different from a family tree, that we all are most familiar with.... A parent will have children.. grand children.. grand grand childrens......
Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.