Hi Steve. Are you still looking for articles on this?
I've got an issue from a few years ago when someone used a lot of scalar functions in completely the wrong way for a system "upgrade". The system ground to a halt within a few days even though it was only new data being added. I fixed it within a couple of days with a variety of different solutions, including doing some of the hard work in instead of insert triggers to manipulate the data on the way in rather than always having to transform it at query time.
Anyway, if you are after something I can write that up.