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

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