vk-kirov (9/6/2012)
For each table name: if we already have such a table in the database, drop it ...
... and say goodbye to a concurrent process (if any) 🙂
Not so good, I would say.
An improvement might be to limit the target tables to temporary tables. That's the scenario I would expect this sort of idea to be used with. On the other hand, we also have MARS...but I guess that's another story.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi