While working on working on a Comprehensive Database Performance Health Check my client asked me – Do MAX(col) Scan Table? Let us learn about that today.
What I love most about my job, is that I get to work with different people and answer questions. Are Not Equal to Operators Equal to Not In?
One of my clients recently asked me a very interesting question about the computed column and Compute Scalar Operators. Let us learn about it today.
Question: Do Stream Aggregate Operator Always Need Sort Operator?
Answer: Absolutely No.Before I explain this question a bit more in detail.
Is Stream Aggregate is Same as Gather Streams of Parallelism? – This was one of the brilliant questions I had received during my recent engagement.
In my earlier post on “SQL SERVER – Remove Duplicate Rows Using UNION Operator”, I showed a different method of removing duplicate rows from the result set using a UNION operator. Here is another similar method using EXCEPT operator to find distinct results.