It appears that your browser does not support JavaScript, or you have it disabled. This site is best viewed with JavaScript enabled. If JavaScript is disabled in your browser, please turn it back on then reload this page. If your browser does not support JavaScript, click here for a page that doesn't require javascript.

Data loading at warp speeds

Data loading is one of the most critical challenges for many systems. The increase in data volumes and the increased demands for availability make this task ever more challenging.
In this session we will cover both theoretical and their counterpart practical aspects of the various means you have at your disposal to optimize your data loading performance.
We will unravel the truths and bust some myths regarding minimally logged operations and
bulk load mechanisms. We will look at internals, 'secret' trace flags but also review some simpler techniques that you may have overlooked.
We will analyze the most common data loading scenarios and provide practical, proven tips for optimizing bulk data load performance which can make a difference in orders of magnitude!

About

SQL Bits was started by a group of individuals that are passionate about the SQL Server product suite.
There is a breadth of knowledge in the SQL Community that will benefit everyone in the community.
We want to spread that knowledge.

We all work with the SQL community, some of us for many years. We have a range of skills and experiences from being given the MVP award by Microsoft, organising user groups and speaking at events around the world.