To capture query plans without guessing, use an Extended Events session scoped to one database and a duration threshold. This post builds one on SQL Server 2025, reads the captured actual plan, and measures why plan capture must be switched on briefly and then off.
NEWID vs NEWSEQUENTIALID: What Each Does to Your Index
NEWID vs NEWSEQUENTIALID decides whether new uniqueidentifier keys land at random in your clustered index or in order at the end. This post loads 20,000 rows with each default, measures pages, fullness and fragmentation, and shows the limits of NEWSEQUENTIALID. It also answers what happens when you switch the default on a table that already has rows.
Session Wait Stats: Find the Query Behind a Wait Type
Session wait stats tell you which session produced a wait type, and the input buffer tells you which query that session ran. This post shows how to see who waits right now, how to read the wait history of each session, and how to join them to the query text. It also explains the THREADPOOL wait.
Parallel Plans: Reading Gather Streams and Repartition Streams
Read Gather Streams and other parallel exchanges, inspect rows per thread and spill evidence, and relate exchange waits to actual work.
Operator Costs in an Execution Plan: Read Them Without Being Fooled
Interpret operator costs as estimates, compare actual rows and runtime evidence, and find expensive work without trusting plan percentages.
Priority Boost in SQL Server: Check It and Turn It Off
Priority boost sounds like a speed setting, but it can make a server slower. This post explains what the option does, checks it with a query that works when Management Studio doesn’t show it, prints the statements that turn it off with their undo, and explains why a restart is needed.
Check Index Fragmentation With Row Count in SQL Server
To check index fragmentation with row count, read sys.dm_db_index_physical_stats in SAMPLED mode and keep the page count and row count next to each percentage. This post builds a demo with three tables, lists every index, filters out the tiny ones, loops over every online database, and rebuilds the one index that matters.







