Google Answers: Quickly Deleting Rows from a table in MS SQL Server 2000

View Question

Q: Quickly Deleting Rows from a table in MS SQL Server 2000 ( No Answer, 0 Comments )

Question

Subject: Quickly Deleting Rows from a table in MS SQL Server 2000
Category: Computers > Programming
Asked by: gregoryew-ga
List Price: $20.00

Posted: 10 Aug 2002 17:20 PDT
Expires: 15 Aug 2002 07:15 PDT
Question ID: 53102

What is the fastest way in general to delete 2 million rows out of a
10 million row table? Please include a full explanation of why this is
the fastest way.  Please think about different environments in which
this would run ex. OLTP, OLAP, etc.  What kind of index should be used
if any and why?  What should happen with existing indexes and
triggers?  Is there any way to not have the transaction logged?

Answer

There is no answer at this time.

Comments

There are no comments at this time.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.

Search Google Answers for

Google Home - Answers FAQ - Terms of Service - Privacy Policy