Administration

SQLServerCentral Article

DTS Parallel Processing

  • Article

SQL Server DTS is an amazing ETL tool. Parallel processing is not only possible, but author Leo Peysakhovich shows us how he does it in this article about his index rebuild process. By bundling DTS into SQL Server for free, Microsoft gave us a platform for not only ETL, but also many basic tasks that all DBAs are stuck working on. Read on to see if parallel processing of index rebuilds is something you can use.

You rated this post out of 5. Change rating

2004-07-13

9,823 reads

Blogs

Adding Test data to msdb.sysjobhistory

By

One of our internal people was looking to test some process in (I assume)...

Microsoft Ignite Announcements Nov 2024

By

Announced at Microsoft Ignite last week were some new product features related to the...

SQL Training: Black Friday Deals Up to 75% Off

By

This Black Week, don't just get a discount—get ahead! Whether you're a total newbie...

Read the latest Blogs

Forums

% processor Time in Activity monitor is greyed out

By IT researcher

When I connect to my SQL Server using SQL Server Management Studio (SSMS) from...

Tools for MySQL memory estimations and optimization?

By EdZzy

Hi all! I’ve been using MySQLCalculator.com for memory calculations, but I’m looking for alternatives...

DELETE

By 0xERROR

DELETE  

Visit the forum

Question of the Day

The Hash Join II

Which of these inputs is the smaller input to a hash join?

See possible answers