I have a quite large DWH table (SQL 2005) with approximately
800.000.000 records. Somewhere in the ETL proces (SSIS) I need to
delete about 30.000.000 records that also exist in an other table. We
have choosen to do that with a Delete From query in a storedprocedure.