I'm trying to get a deeper understanding of differential backups: Say I have a fairly large database (2.5 TB) that uses the simple recovery model. (Bare with me. ) How does the db engine determine what's changed since the differential base was created? Is it just a page-by-page comparison? If so, will index reorgs/rebuilds bloat the differential?