There are already a couple of questions on finding cycles, but I did not find a solution in SQL (MSSQL preferred).
The tables would be Node (NodeID INT) and Edge (EdgeID INT, NodeID1 INT, NodeID2 INT)
What would be a well-performing solution to find cycles in a directed graph?