Small, undocumented optimization enhancements can improve performance

SQL Server 2012 provides new solutions

New tricks for an old tool

This article starts with a brief reminder of the meaning of the computation of percentiles. I then provide solutions to the computations that are supported in SQL Server versions starting with SQL Server 2005. I hope...

Work around SQL Server 2012's lack of support

More tips for producing healthy and efficient code

Tips for producing healthy and efficient code

Tips on how to analyze query plans efficiently

Optimization for improved performance

If you're looking for a good querying challenge, try to come up with your own solutions to computing PERCENTILE_CONT and PERCENTILE_DISC for a given input argument @pct. Here's how standard SQL defines the...