This is in MSSQL of course...

-----Original Message-----
From: Regis Biassala [mailto:Regis.[Email Address Removed] Wednesday, April 30, 2003 4:17 PM
To: LazyDBA.com Discussion
Subject: Deleting milions of rows best approach


DBAs,
suppose you have a table with 400 millions of rows and You only have to
delete 140 millions...what would be your best approach in accomplishing this
?
example:
table customer(CustNr int, Name varchar(100), Createdate datetime)
The query for deleting would look like:
delete from Customer where createdate between blab and blab

Is there way of deleting let say n number of rows at a time ?


Thanks,
Regis



*********************************************************************
This electronic transmission is strictly confidential and intended solely
for the addressee. It may contain information which is covered by legal,
professional or other privilege. If you are not the intended addressee,
you must not disclose, copy or take any action in reliance of this
transmission. If you have received this transmission in error,
please notify the sender as soon as possible.

This footnote also confirms that this message has been swept
for computer viruses.
**********************************************************************


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed] electronic transmission is strictly confidential and intended solely
for the addressee. It may contain information which is covered by legal,
professional or other privilege. If you are not the intended addressee,
you must not disclose, copy or take any action in reliance of this
transmission. If you have received this transmission in error,
please notify the sender as soon as possible.

This footnote also confirms that this message has been swept
for computer viruses.
**********************************************************************

MS Sql Server LazyDBA home page