First step, create a copy of the problematic database file and try your initial recovery efforts on the copy - work with the original file only as a last resort,...
I wiould urge DBA's to be mindful of places where CTEs get used, but views would provide either better performance or a resource that could be used in several places.