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 emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
What Is In the Plan Cache and How to Look
Inspect the SQL Server plan cache, identify single-use plans and memory use, and understand what optimize for ad hoc workloads changes.
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.
T-SQL Habits Worth Unlearning
Review T-SQL habits that hide intent or create avoidable work, including SELECT star, NOLOCK, row loops, and functions on filtered columns.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.