Design a nightly job that processes millions of records without falling over or grinding the database to a halt. Talk me through it.

Situational