News for hackers. Stuff that matters.
Re:Migrating a 40TB SQL Server Database by jto1218 on Thursday July 30, 2020 @12:56PM (#24000409)
> There were lots of reasons this needed to be done, one being tech debt. We realized that the original daily table structure wasn’t ideal. If we needed to query something over several days or months, it was terrible — lots of UNION ALLs or loops to crawl through days or even months at a time was slow.

Maybe i'm missing it, but there doesn't seem to be any discussion of the result. _How_ much faster was it after the change? Was it 11-months-worth-of-dev-time faster?

Re:Migrating a 40TB SQL Server Database by BrentOzar on Thursday July 30, 2020 @01:05PM (#24000524)
> Maybe i'm missing it, but there doesn't seem to be any discussion of the result.

Sometimes you have to stop writing after 9,000 words. ;-)