An introduction to PERCENTILE_DISC, the SQL Server 2012 analytic function that returns an actual value from your data at a given percentile.
SQL SERVER – Puzzle to Win Print Book – Explain Value of PERCENTILE_CONT() Using Simple Example
Win a print book: explain the value of PERCENTILE_CONT with a simple example, and learn this SQL Server 2012 function even on an earlier version.
SQL SERVER – Introduction to PERCENTILE_CONT() – Analytic Functions Introduced in SQL Server 2012
An introduction to PERCENTILE_CONT, the SQL Server 2012 analytic function that finds a percentile on a continuous distribution, much like a median.
SQL SERVER – Introduction to PERCENT_RANK() – Analytic Functions Introduced in SQL Server 2012
An introduction to PERCENT_RANK, a SQL Server 2012 analytic function that returns the relative standing of a value in a result set, shown next to RANK.
The Previous Row Before LAG Existed: A ROW_NUMBER Self-Join
Before LAG, we numbered rows and joined each one to its neighbor. Here is how that pattern works, where ties and NULLs bite, and how LAG compares.
SQL SERVER – Puzzle to Win Print Book – Write T-SQL Self Join Without Using LEAD and LAG
Win a print book: write a T-SQL self join that simulates LEAD and LAG, so you can learn a SQL Server 2012 feature even on an earlier version.
SQL SERVER – Introduction to LEAD and LAG – Analytic Functions Introduced in SQL Server 2012
An introduction to LEAD and LAG in SQL Server 2012: read a value from the next or previous row without a self-join, with an AdventureWorks example.






