Any thought of cleaning the string of Suffix (Mr, Mrs) and prefix (MD, Jr) and just using SOUNDEX?

Are you actually running the code or just getting a plan?

Ok,

You have millions of rows and you need to delete some.

-- Create an index that covers the 'create date' or however you qualify older than 3 motnhs.

-- Cluster on...

Need to do one for each table, it wouldn't be that hard to script however. Also there are some audit tools that do this for you.

Doesn't the index tuning tool give you a top 10?

Also do you have any large transactions (ie large number of rows updated) etc. that may still be open and require rollback when you failover?

Why 7 vs. 2K matters. The optimizer in 2K does a better job at using some indexes and developes better plans.

The network may be an issue. You may...

Why not just store them in files and put the file location in SQL Server. Also you sure you want to do this word files that could be edited and...

Have you tried restoring a full and then appling the transaction logs after. Perhaps a tranlog failed to get shipped.

If you do a massive delete you may want to reindex the table or at least set recompile on for it.

Ok,

First the LIKE statements in your Unions may be hurting you. If the like was LIKE '%dog%' I know it would be hurting you.

Is there an index on ATC_CD...

Try a dbcc checkcatalog as well as forcing a recompile on every table, view and SP.

Also take a peek at the data in syscomments.

Good Luck

Henry

Ok,

I have a bias here. I have every one of the things I am going to suggest you get.

1) A BS degree is CS with a minor in business...

Ok, why unfettered Access, access to a SQL Server database for users unless they really know what they are doing.

Two words: Table Lock

It is really, really easy for someone...

Next time you may want to just BCP the data out and use Oracle's version of BCP (I forget what it is called) to bring the data in. Don't know...