Rows read per thread show whether a parallel query shares its work evenly. The post shows two plan based methods, a T-SQL query over the last actual plan, and a live DMV for running queries. A 500,000 row demo proves the threads add up to the table.
SQL SERVER – Query Specific Wait Statistics and Performance Tuning
Query Specific Wait Statistics helped explain a sudden customer-query slowdown. The remaining workload ran normally, and recompilation had not helped.
Unique Index Performance: What a UNIQUE Index Saves
Unique index performance gains come from what the optimizer learns, not from smaller pages. A tested demo compares pages, reads, plans and CPU for a plain index and a unique index. It also shows the error a duplicate causes.
Running SQL Server Under a Group Managed Service Account
Set up a group managed service account for SQL Server Engine and Agent, then verify permissions, SPNs, and Kerberos connections.
Temp Table Scope in Dynamic SQL: Who Can See What
Temp table scope decides what dynamic SQL and stored procedures can read. Tested demos show a child reading a parent table, a procedure that fails without it, a dynamic table shape and the error a typo causes. A card lists the rules.
Can an Index Reduce Performance of SELECT Query? – Interview Question of the Week #234
Question: Can an Index Reduce Performance of SELECT Query? There is a huge misconception that Indexes does not impact SELECT queries negatively.
Dynamic SQL Temp Table: Why It Disappears and How to Keep It
A dynamic SQL temp table is dropped when its dynamic batch ends, so the main code cannot read it. A global temp table keeps the data, and a per session name keeps it safe. Every step is tested, including the second session clash.