A small slice of pie

Think twice about storing JSON in your SQL Server database

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; another table in the same database has almost 500 million rows. The remarkable thing — because you read the subject
-> Continue reading Think twice about storing JSON in your SQL Server database

Stonehenge with miniature effect applied

Compression in SQL Server: COMPRESS and DECOMPRESS

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 ROW or PAGE compression? Joey D’Antoni (blog | Twitter), one of my co-authors, reminded me that row and page compression do
-> Continue reading Compression in SQL Server: COMPRESS and DECOMPRESS