Speaker: Ami Levin of SolidQ
Data loading is one of the most critical challenges for many systems. The increase in data volume and demand for availability make this task ever more challenging. In this session, Ami will cover both theoretical and practical aspects of the various means you have at your disposal to optimize your data loading performance.
- The truths and myths regarding minimally logged operations and bulk load mechanisms
- Internals, 'secret' trace flags, and simpler techniques that you may have overlooked
- The most common data loading scenarios
- Practical, proven tips for optimizing bulk data load performance which can make a difference in orders of magnitude
Ami Levin is a consultant with SolidQ. He recently moved to California from Israel, where he led the Israeli SQL Server User Group.Ami is a regular speaker at Microsoft Tech-Ed Israel, Dev Academy, and other SQL Server conferences and blogs at SQL Server Tuning Blog.