SQL SERVER – DVM sys.dm_os_sys_info Column Name Changed in SQL Server. Let us learn about it in today’s blog post.
SQL SERVER – Solution to Puzzle – Simulate LEAD() and LAG() without Using SQL Server 2012 Analytic Function
Readers found five ways to simulate LEAD() and LAG() without the SQL Server 2012 analytic functions. This post shows each solution with its author, runs all five on SQL Server 2025 and compares the rows with the real functions. Four return the same ten rows and one adds a rule of its own.
SQL SERVER – 2012 – Summary of All the Analytic Functions – MSDN and SQLAuthority
SQL Server 2012 introduced Analytic Functions for common window calculations. I collected this series to make them easier to learn.
SQL SERVER – Introduction to PERCENTILE_DISC() – Analytic Functions Introduced in SQL Server 2012
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.
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.