Browsing the archives for the TOP tag

Use a View to Control the Size of UPDATE Transactions

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 […]