We use Maintenance Plans a lot in our environment, consisting of around 300 smallish SQL Servers across the globe. They generally work well.

Contrary to what is stated above, there is...

Didn't find this very helpful.

For very large tables, the cursor approach would be dreadfully slow.

There are other techniques that exist, such as using duplicate indexes with IGNORE_DUP_KEY option that would...

Just going to add guys that the Maintenance Plans do offer a reasonable amount of error reporting if you know where to look.

Don't look at the job, flick back to...