SELECT *
FROM Posts
WHERE Tags IN ('Compression')

Nov
3
2016

Database Design Matters, Real World Scenario

Disclaimer: This is how I solved a particular problem after analyzing and understanding my data….

Continue Reading »

Feb
15
2016

Row compression, a bit of internals

Compression in SQL Server has been around for a while now, to be precise since SQL Server 2008, and comes in two different (complementary) flavors, ROW and PAGE compression. Unfortunately it’s only available in the Enterprise Edition (and Developer…

Continue Reading »