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.

Is...

The correct answer to the question, as written, is Yes.

To the defenders of the 'school' answer, I say "Man is not a rational animal, he is a rationalizing animal." (Robert...

I feel cheated - my thinking was "surely, they must know that the answer to the question as written is yes, and they are...