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:
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
Speakers
Matan Yungman's previous sessions
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.
Things You Can Find in the Plan Cache
The plan cache is one of SQL Server's fundamental components. Getting to know it can take you a few steps ahead in optimizing your system.
In this session we will demonstrate ways the Plan Cache can help us identify performance problems.
Query Progress Tracking in SQL Server
It's 18:00 o'clock on Friday. You execute a process that usually takes a few minutes and start packing in order to start the weekend. You are already with your bag on your back, but the process doesn't finish. What should you do now?