February 2014 – SQLBlog.org

SQL Server

February 24th, 2014

Avoid using NOLOCK on UPDATE and DELETE statements

Tip : Avoid using NOLOCK on SQL Server UPDATE and DELETE statements

SQL Server / SQL Server 2008 R2

February 19th, 2014

February 2014 Cumulative Update for SQL Server 2008 R2 SP2

Microsoft has released Cumulative Update #11 for SQL Server 2008 R2 Service Pack 2. KB Article: KB #2926028 12 fixes listed at time of publication Build number is 10.50.4302 Relevant for @@VERSION 10.50.4000 through...

SQL Server

February 11th, 2014

Best approaches for grouped median

I revisit an old post and explores approaches to calculating the median across partitioned sets.

Monthly Archive: February 2014

Avoid using NOLOCK on UPDATE and DELETE statements

February 2014 Cumulative Update for SQL Server 2008 R2 SP2

Best approaches for grouped median