December 29, 2009 – SQLBlog.org

Daily Archive: December 29, 2009

December 29th, 2009

Mixing OLTP and reporting using indexed views

I'm not a big fan of denormalizing, nor of repeating redundant redundant information in a database when those facts can already be derived from other information. A classic example of the latter is when...

SQL Server / SQL Server 2008

December 29th, 2009

Playing with page compression – for real

During maintenance windows and against test databases, I have been applying page compression to some largish tables (~200+ million rows, ~50GB). These tables are heavy write and medium read, but all writes are inserts...