How to Dramatically Decrease Data Warehouse Load Times with Memory-Optimized Tables

http://ift.tt/1K9IKjp

Tyler C.

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

read more

from SQL Server Pro http://ift.tt/1kCjeYg