August 1, 2012 – SQLBlog.org

Daily Archive: August 1, 2012

SQL Server / SQL Server 2008 R2

August 1st, 2012

SQL Server 2008 R2 Service Pack 2 Cumulative Update #1 is available

Microsoft has released a cumulative update for SQL Server 2008 R2 SP2, which was only released last week. KB article is http://support.microsoft.com/kb/2720425 Build number is 10.50.4260.0 There are 35 fixes published as of 2012-08-01...

SQL Server

August 1st, 2012

When the DRY principle doesn’t apply : BITWISE operations in SQL Server

This week I came across a case where DRY should be thrown out the window. There are other cases as well (for example, scalar functions), but this one was an interesting one involving Bitwise logic.