SentryOne Team Blog (blogs.sentryone.com)

Tag : row_number

Paul White : Improving the Row Numbering Median Solution

Paul White (@SQL_Kiwi) takes one more look at medians, this time describing how a locking hint can help improve the performance of a pre-2012 solution.