We have found no need to impliment clr, For us, SQL is about returning SETS and although it takes a mind flip to stop thinking procedurally and start with set based solutions only, it usually results in a substantial increase in performance. Materialised views are far more beneficial.