Sometimes, getting source data to load fast into SQL Server requires a good look at the whole process. Certainly, if you can take full of advantage of all available processor cores and attempt to parallelize the load, you could shorten load times—as we saw in Chapter 13 . Yet here are other aspects of ETL loads that also need to be taken into consideration if you are trying to optimize a load and ensure that the entire time taken by a job (and not just the data load) is reduced to fit into an acceptable timeframe.