SQLServerCentral » Latest topics
How to handle business hour loads?
So we have a situation where we have to load data to a DW during business hours at times. How does one do this with minimal impact?
I was thinking of something like load to temp DB, then rename old DB to archive it, then rename new temp DB
I was thinking of something like load to temp DB, then rename old DB to archive it, then rename new temp DB
No comments:
Post a Comment