Cheers for your insights Chris and Jeff. We'll consider transforming some of these LINQ queries into SP. You have a strong argument of having that capability to optimize queries without...

Thanks Jeff for taking a look at this.
You are right we will have to revisit the actual implementation of this now.