Performance Tuning Your Active X Script Transformations With the Multiphase Data Pump - Video Series Video Category: Working with the Common Tasks in DTS Skill Level: 400 (Intermediate - Advanced) Versions/Editions Covered: SQL Server 2000 The Multiphase Data Pump (MPDP for short) is hidden from site inside of DTS and, unless you've worked with DTS for quite a while, you may not even realize that it's there. It can seriously boost your ActiveX Script Transformations though and, unless you know how to use it, your DTS packages could take 20 minutes instead of 20 seconds!

Videos in this Series:

Title Skill Length Download Pt. 1 - An Introduction to Using the Multiphase Datapump     400 13 mins. Download Pt. 2 - An Introduction to Using the Multiphase Datapump   400 13 mins. Download Pt. 3 - Data Transformation Tasks and Advanced Techniques Using the Multiphase D...   500 14 mins. Download Pt. 4 - Performance Tuning Your ActiveX Script Transformations Using the MPDP   500 9 mins. Download

< Return to list of all videos

Miscellaneous Bits & Pieces:

Want to see what's going on in your log? Run DBCC log (<insert your database name here >) WITH TABLERESULTS With SQL Server 2000 Service Pack 3 Microsoft updated versions of the SQL Server 2000 sample applications. Available from http://www.microsoft.com/sql Did you know that the database role "ddladmin" can TRUNCATE the table (delete all rows) but not SELECT?