Recursive query optimization in mssql

Hi, I am fairly new to using MSSQL in general and am currently having trouble optimizing my recursive query. Here is a list of approaches I have tried: Parallel Execution: Since it is recursive ...