Monthly Archive: December 2009

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

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

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

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