I think we found the issue. The select statement was wrapped in an IF that was behaving erraticly. We corrected the IF statement and it runs sub-second times...

Forgive me if this sounds silly, but there is a "conditional split" operation in the data flow transformations. Have you tried that?

It can fit on a mirror set.

Since the data is reloaded and retransformed daily, backing it up is kind of moot.

I am most interested in the stripe to increase write...