ITPro Today logo
SQL ServerDramatically Decrease Data Warehouse load times update from May 2015Dramatically Decrease Data Warehouse load times update from May 2015
Introduction Recently, I needed to optimize a nightly batch process for a SQL Server data warehouse that involved loading over 250,000 flat files. With a bit of experimentation and research, I was able to decrease the overall load time from 14 hours to under 15 minutes. To do so, I used: something old - the T-SQL BULK INSERT command, something new - Memory-Optimized tables in SQL Server 2014, and
Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.