SqlServerKudos

Welcome!

SqlServerKudos is a place where you can find the latest SQL Server stories and articles to improve your skills and share your opinions.

Enjoy participating in this community and see which others are getting Kudos.

faq »

1
kudos

Kudos

SQL SERVER – Stream Aggregate Showplan Operator – Reason of Compute Scalar before Stream Aggregate « Journey to SQL Authority with Pinal Dave

published 720 days, 9 hours, 45 minutes ago posted by

pinaldave 728 days, 57 minutes ago

SQL SERVER – Stream Aggregate Showplan Operator – Reason of Compute Scalar before Stream Aggregate « Journey to SQL Authority with Pinal Dave

I keep a check on the questions received from my readers; when any question crosses my threshold, I surely try to blog about it online. Stream Aggregate is a quite commonly encountered showplan operator. I have often found it in very simple COUNT(*) operation’s execution plan. If you like to read an official note on the subject, you can read the same on Book Online over here. The Stream Aggregate operator groups rows by one or more columns and then calculates one or more aggregate expressions returned by...

category: Query | clicked: 0 | | source: blog.sqlauthority.com | show counter code

tags: pinaldave, SQL, SQLAuthority, SQLServer

Border color:

Kudos Backcolor:

Kudos Forecolor:

Count Backcolor:

Count Forecolor:

Preview

update reset

SqlServerKudos

Welcome!

SQL SERVER – Stream Aggregate Showplan Operator – Reason of Compute Scalar before Stream Aggregate « Journey to SQL Authority with Pinal Dave

No comments yet, be the first one to post comment.

Open ID Login

Standard Login

Forgot Password?

Sign up