Delete rows from a large table
You should do 2 things for efficiently deleting the data from your big table :


Delete in batches and/or do careful batching
Watch out your Transaction log size - if db in simple recovery mode - perform frequent CHECKPOINTS or if db is full recovery mode - perform frequent log backups.