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,851 reads

Blogs

Building AgentDBA’s Slack Escalation

By

Until now, a CRITICAL finding did the right internal routing, but the last mile...

Changing the Owner Removes Permissions: #SQLNewBlogger

By

This is actually inspired by an article SQL Server Central, which taught me something...

T-SQL Tuesday #200 - I Bet It's Bad if I See...

By

T-SQL Tuesday is a monthly blog party hosted by a different community member each...

Read the latest Blogs

Forums

How Clustering can be Used as a Preprocessing Technique for Classification in Azure Machine Learning

By Dinesh Asanka

Comments posted to this topic are about the item How Clustering can be Used...

Moving the Error Log

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Moving the Error Log

A Security and AI Fail

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A Security and AI Fail

Visit the forum

Question of the Day

Moving the Error Log

How can I change the location in which the SQL Server error log is written in SQL Server 2025?

See possible answers