SentryOne Team Blog (blogs.sentryone.com)

Tag : median

Paul White : Improving the Top / Top Descending Median Solution

Paul White (@SQL_Kiwi) finishes up his series on the performance of calculating a median with a thorough treatment of eliminating bad elements from plans.

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.

Paul White : Locking and Performance

Paul White (@SQL_Kiwi) follows up a great post on calculating medians with some information on how locking can affect query performance, often undetected.

Paul White : Calculating the Median with a Dynamic Cursor

Paul White (@SQL_Kiwi) demonstrates another case where a cursor might be the most efficient approach to solving a typically set-based problem: medians.