The Data Loading Performance Presentation
Discover techniques for optimizing massive data loading processes in SQL Server during this hour-long presentation from PASS Data Community Summit. Explore the key concepts from Microsoft's "Data Loading Performance Guide" and learn about advanced methods developed since its publication. Delve into topics such as minimal logging, bulk loading, indexing strategies, effective use of parallelism and partitioning, and SQL Server 2014 Delayed Durability. Gain insights on identifying and overcoming performance bottlenecks, selecting appropriate clustered index keys, leveraging in-memory OLTP, and utilizing various data loading components. Master the art of efficient data loading through discussions on minimal logging, backlog management, bulk APIs, and loading techniques for partitioned tables. Enhance your understanding of hardware considerations, including ECC utilization, jumbo frames, and instant file initialization, to maximize SQL Server data loading performance.