Part 4 on reading the previous row and next row value in a SELECT statement. My friend Szymon Wojcik shows how a numbers table can make the query even faster.
UPDATE() in a Trigger Is True Even When Nothing Changed
Understand why UPDATE() in a trigger fires for unchanged SET values and log only real changes with inserted and deleted row comparisons.
Turning Key-Value Pairs Into Columns for Reporting
Turn key-value pairs into reporting columns with conditional aggregation and PIVOT, handle missing values and conversions.
Set Operator Rules: Column Names, Types and ORDER BY With UNION
Why did my UNION change its headers, fail on a word, or sort wrong? Small examples show each rule and the error it produces.
Single-Row Inserts in a Loop: Why Commits Cost So Much
A loop that inserts one row at a time waits for the log on every row. Here is how to see it, and three ways to wait far less.
Vector Search in SQL Server 2025 With VECTOR_DISTANCE
Use VECTOR_DISTANCE in SQL Server 2025 to rank small example vectors, compare cosine and euclidean distance, and plan larger searches.
How to Check What SQL Server Licensing You Are Actually Using
Check SQL Server licensing evidence with edition and CPU queries, then reconcile visible processors with host inventory and your agreement.