Iulian -207023 (11/19/2010)
Did anyone used the SWITCH option in production?
It is used as part of the archiving of large tables in our data warehouse environment.
Using SWITCH has reduced the population time from approx 36 hours (750+ million records) to add approx 25 million records per month to less that 1 hour (99.9% of that time taken to populate the staging table from which the data is switched into the archive table, the actual switching operation takes on average 10 milliseconds)
Space, the final frontier? not any more...
All limits henceforth are self-imposed.“libera tute vulgaris ex”