A long-running query for demonstrations has to run long enough to watch and stop when you say. This post builds one from a counting table, shows how its run time grows with the row count and explains how to watch and stop it. It also compares it with WAITFOR DELAY.
In-Memory OLTP Migration Checklist: Which Features Block You
An In-Memory OLTP migration checklist from SSMS lists the tables and procedures the engine will refuse. This post tests those refusals on SQL Server 2025, shows which old limits are gone, and adds a query that finds blockers in your own database.
SQL SERVER – Active Parallel Requests and Cached Parallel Query History
I Identify parallel running requests separately from parallel queries recorded in the cache. Those lists answer different performance questions.
Do Stream Aggregate Operator Always Need Sort Operator? – Interview Question of the Week #240
Question: Do Stream Aggregate Operator Always Need Sort Operator?
Answer: Absolutely No.Before I explain this question a bit more in detail.
READPAST Query Hint: Skip Locked Rows in SQL Server
The READPAST query hint makes a read skip rows that another transaction has locked, instead of waiting for them. This post builds a five-seat demo, runs it in two windows and lists the cases where the hint does nothing. It also shows the work queue pattern that pairs READPAST with UPDLOCK.
SQL SERVER – Is Stream Aggregate is Same as Gather Streams of Parallelism?
Is Stream Aggregate is Same as Gather Streams of Parallelism? – This was one of the brilliant questions I had received during my recent engagement.
ENABLE_PARALLEL_PLAN_PREFERENCE Limits: Rows Per Thread
The ENABLE_PARALLEL_PLAN_PREFERENCE limits are easy to miss: the hint can’t make every query parallel, and it can’t spread rows evenly over the threads. This post proves three limits from the last actual plan of demo queries, with the rows each thread processed and the reason a plan stays serial.







