• Yet another great question that required some digging to ensure the correct answer...

    Referencing BOL

    The Stream Aggregate operator requires input ordered by the columns within its groups. The optimizer will use a Sort operator prior to this operator if the data is not already sorted due to a prior Sort operator or due to an ordered index seek or scan.

    Hope this helps...

    Ford Fairlane
    Rock and Roll Detective