Question: Do Stream Aggregate Operator Always Need Sort Operator?
Answer: Absolutely No.Before I explain this question a bit more in detail.
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.
SQL SERVER – 3 Different Ways to Explore Actual Execution Plans
We will explore 3 different ways to explore Actual Execution Plans. I had discussed this Comprehensive Database Performance Health Check.
SQL SERVER – Number of Rows Read Per Threads in Parallel Operations
Question received via email: The question was about is there any way to know how many rows each thread execute in parallel operations.
Trivial Plan: Why Some Queries Skip Full Optimization
Identify a trivial plan in SSMS and cached XML, understand skipped optimizer work, and compare a more complex query without forcing it.
Removing a Bad Plan From Cache Without Clearing Everything
Remove one bad plan from cache by handle, compare narrower recompilation choices, and fix the cause so the plan stays healthy.
SQL SERVER – Get Last Known Actual Execution Plan for a Previously Cached Query Plan
In SQL Server 2019 you can get the last known actual execution plan for a cached query plan. Enable trace flag 2451, then run the query in this post.