SQL Server 2008 Analysis Services Training Video: Tips on Bulk Lo ading Data, Part 1

Tips on Bulk Loading Data, Part 1 - view details
This video focuses on loading data from external sources, specifically text files. The ETL (Extract, Transform, Load) process is very common. SSIS' built-in tasks are often used for bulk transfer, but what if you need more than the built-in tasks, or don't even have access to SSIS? Here, and continued in part 2 of this video, you'll learn a valuable step-by-step approach to optimizing bulk loading operations.

Highlights from this video:Why loading tables from external text files can be time consuming
Bulk loading without SSIS
What is a minimally logged transaction?
Example of traditional loggingExample of minimally logged XACTs
Why is minimal logging during bulk loads important?
Optimizing bulk loading operationsThe eight steps

and much more Source: http://www.learnitfirst.com/Course/161/Video/3072/Bulk-Loading-P1.aspx Course: http://www.learnitfirst.com/Course/161/SQL-Programming-2008.aspx Skill Level: 400 (Intermediate - Advanced) Length: 14:45 (29.3MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: extract, transform, load, tables, external source, text file, optimize bulk loading, pattern, ssis, logged transaction, traditional logging, minimal logging, bulk logged, nonclustered index, recovery model

This video comes from the SQL Server 2008 Analysis Services online training course, Transact-SQL Programming: SQL Server 2008/R2. And be sure to check out even more SQL Server Analysis Services training videos.