Skip to content
A small slice of pie

Think twice about storing JSON in your SQL Server database

  • by

During routine maintenance on a customer’s production server, I discovered that they have one table consuming 40% of the storage in their database. That table contains just under 10 million rows, which isn’t that remarkable;… 

Stonehenge with miniature effect applied

Compression in SQL Server: COMPRESS and DECOMPRESS

  • by

On Twitter recently, I asked: Does anyone I know use the COMPRESS and DECOMPRESS features in T-SQL? To those who replied in the affirmative, I asked: What made you decide on this as opposed to…