SQLBits 2015

The Data Loading Performance Presentation

Microsoft has a famous whitepaper called "The Data Loading Performance Guide". On this session, we will turn the whitepaper into a presentation and see a few advanced ways to boost your data loading processes.

Microsoft has a famous whitepaper called "The Data Loading Performance Guide".
The problem is that it's long and full of small details, and we're too lazy to read it.

On this session, we will turn the whitepaper into a presentation and see a few advanced ways to boost your data loading processes.

Among other topics, we will talk about:

Minimal Logging
Transaction Management
Bulk Loading Methods
Indexing Techniques for High Performance Data Loading
Properly Leveraging Parallelism and Partitioning
SQL Server 2014 Delayed Durability

Speaker

Matan Yungman is a Data Platform MVP, a senior consultant and the professional manager at Madeira Data Solutions. He's been working with SQL Server since 2002, and today he spends his time consulting, mentoring and speaking about SQL Server.

Matan Yungman's Sessions

The Data Loading Performance Presentation

Things You Can Find in the Plan Cache

Query Progress Tracking in SQL Server