Fun with (columnstore) compression on a very large table – part 1
SQL Performance
DECEMBER 27, 2019
Recently someone at work asked for more space to accommodate a rapidly growing table. At the time it had 3.75 billion rows, presented on 143 million pages, and occupying ~1.14TB. Of course we can always throw more disk at a table, but I wanted to see if we could scale this more efficiently than the current linear trend. Sounds like a great job for compression, right?
Let's personalize your content