There a quite a number of articles and scripts dealing with this issue like:

http://www.sqlservercentral.com/articles/Miscellaneous/findinganddeletingduplicatedata/1075/

or

http://www.sqlservercentral.com/articles/duplicates/65916/

Type 'Duplicate data' in the search field too find the complete list

If you are referring to physical file fragmentation of the mdf and ldf files, then I use the contig utility to check and correct this. See http://technet.microsoft.com/en-us/sysinternals/bb897428.aspx...

Is the archiving process fragmenting the index? If so then try to disable (or drop) the index on Table B then add the records from Table A then lastely...

If you are referring to the maintenance jobs then start woth BOL (books on line) The help feature is very useful.

see ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/uirfsql9/html/c7a3932e-e6ab-4cc2-8664-e0284490b898.htm

and

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/uirfsql9/html/ad879ed6-223a-4a06-a459-8c2ca25ce92d.htm

Personally I don't use maintenance plans at...

We use a Groupwise agent to control relaying. All servers that want to sent SMTP mail must have their IP address registered int he GroupWise Internet Agent configuration, under...

Since this question was asked in the SQL 2005 forum then ALTER INDEX is a better choice to defrag indexes as DBCC INDEXDEFRAG is deprecated.

see http://blog.ola.hallengren.com/blog/_archives/2008/1/1/3440068.html

Steve. that is my understanding as well. You purchase whatever edition of SQL you need Standard, Enterprise etc. Microsoft ships you disks in both 32 bit...

Please don't post the same question multiple times. See http://www.sqlservercentral.com/Forums/Topic706719-146-1.aspx

I use this on all my production servers: http://www.sqlservercentral.com/articles/Administration/2757 It works great

I use contig as well. I created a SQL job to run this periodically (once a month usually) It takes very little time and I've never have a conflict...

Well thats annoying. Although I (only sort of) accept the E notation being accepted. Anyway the referenced discussion was a interesting read. Thanks for pointing that...

By the way I noticed my previous posts were wrong about the ports used. Posts 135 and the high range of ports 1024-65000 are used by SQL integration services...

I had (still have on certain servers) this same issue. I documented the process I used to address this issue at http://www.simple-talk.com/sql/database-administration/on-the-trail-of-the-expanding-databases/ I should note that...

This problem for me was only resolved for me when both port 135 and TCP high ports 1024 to 65535 were opened. The firewall guys wersn't happy about opening...