In several of my production databases I have to deal with tables that have hundreds of millions of records.  Querying these tables are challenging; doing updates to them can be nightmarish. I recently had to add a column to a table that had 65 million records.  The table is an aggregate table so the new [...]