• In my experience this sort of pattern has some sort of blocking issue to deal with.  What about using synonyms instead of a schema swap / lock?  We have had to remove this pattern from our DW load (introduced by a previous BI developer) as it was causing severe locking issues.  Yes our DW loads are certainly not best practice but I still think synonyms are a much better solution.