Great thanks very much!

I've just come across this post, whilst investigating a similar situation (though legacy).

Can anyone explain what potential issues there are (if any) in changing a production database from TORN_PAGE_DETECTION to...

I'd echo the above point: would be very interesting to see some analysis of each technique performs.

That solution has the advantage of allowing you to return as many columns as needed. But I don't think you can execute dynamic sql statements in a udf, which is...