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 Server 2005 #522123 : SQL Server 2008 Service Pack 2 In a predictability area, I suggested […]

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 I see questions on newsgroups, forums or StackOverflow that ask how they can update a table's […]

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 (no updates).  Clustered indexes are on a DATETIME column, and then on INT columns.  Since there […]

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 2 brings you to 9.00.3356.  The only fix for the latter involves MDX queries, so if […]

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 that call C# command line programs, VBScript files, etc.  Some of these programs simply BULK INSERT […]

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 SAN undercarriage, double the memory and twice as many CPUs.  I'll blog more about that later, […]