Monthly Archive: December 2009

Connect digest : 2009-12-31

Connect digest : 2009-12-31

Like Hugo's immensely popular item pushing for SQL Server 2005 Service Pack 3, Steve Jones has created suggestions prompting new service packs for both 2005 and 2008: #522122 : Service Pack 4 for SQL...

Mixing OLTP and reporting using indexed views

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...

Playing with page compression – for real

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...

Cumulative Updates for SQL Server 2005 are available

Cumulative Updates for SQL Server 2005 are available

Last week Microsoft snuck in some updates for the SQL Server 2005 product line.  Cumulative Update #7 for Service Pack 3 brings you to build # 9.00.4273, while Cumulative Update #17 for Service Pack...

On software bloat…

On software bloat…

This morning I decided to install Visual Studio 2010 on one of my development VMs.  I have several processes in our production environment where, for convenience, I have SQL Server Agent calling batch files...

Connect Digest : 2009-12-12

Connect Digest : 2009-12-12

Sorry I have been quiet recently; been working very hard for the past two weeks on a migration of an old, tried SQL Server 2005 database to a brand new 2008 cluster with faster...