embed embed share link link comment comment

Embed This Video close
Share This Video close
bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark
embed test
Rate This Video embed
1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading ... Loading ...
Tags For This Video tags
rate rate tags tags related related lights lights

Create a Data Loading Strategy


Ryan Casey


Loading large amounts of data into SQL Server can be challenging. Many factors may challenge your goal for tuned performance. To make the decision making process more difficult, many of the choices listed below have both Pros and Cons to their implementation. For this reason, loading large amounts of data requires a strategy. Create a strategy to optimize your massive data loading processes: 1) High Performance Data Loading (SCD Type II and Type I using checksums) 2) Minimal Logging and Bulk Loading 3) Indexing Considerations 4) Delayed Durability 5) Eager Write. This session uses a Virtual Sandbox to demonstrate “real” data loads using these techniques listed above. We will look at the T-SQL used in these data loads. We will briefly discuss how the different settings and configurations effect the data loads. Power Point slides and sample SQL will be provided.


@RyanCaseyMBA | AIM Report Writing | www.aimreportwriting.com | blog.aimreportwriting.com Hire the Intelligence Choice: Business intelligence architect seeking corporate-to-corporate contract opportunities. As a Friend of Redgate Member and a regular SQL Saturday Speaker, Ryan delivers: 13+ Fortune 500 Corporations Implementing Data Centers and Data Warehouses & 15+ years SQL Server and Oracle (T-SQL, PL-SQL), (Excel, Flat Files, XML) AIM Report Writing combines the collaborative and creative arts included in Technical Communication, the business acumen of a Harvard MBA program, and the technical discipline of object oriented programming and business intelligence (data warehouses).

Recorded At:

SQL Saturday Dallas BI Edition 2017

Leave a Reply

Your email address will not be published. Required fields are marked *


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>