Ordered Data

Question

Post reply

Ordered Data

Steve Jones - SSC Editor

SSC Guru

Points: 736602
More actions
December 9, 2013 at 9:57 pm

#74378

Comments posted to this topic are about the item Ordered Data
December 11, 2013 at 2:47 am

This was removed by the editor as SPAM

Viewing 15 posts - 1 through 14 (of 14 total)

You must be logged in to reply to this topic. Login to reply

Ford Fairlane SSCertifiable Points: 7664 More actions · Answer 1

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

Umer Akram SSC-Insane Points: 22209 More actions · Answer 2

Ford Fairlane (12/9/2013)
Yet another great question that required some digging to ensure the correct answer...

+1 , Excellent question its make you dig 🙂

thanks for sharing

paul s-306273 SSChampion Points: 10730 More actions · Answer 3

paul s-306273

SSChampion

Points: 10730

December 10, 2013 at 5:15 am

#1672265

'Lazy Spool' - never come across that before...

Umer Akram SSC-Insane Points: 22209 More actions · Answer 4

paul s-306273 (12/10/2013)
'Lazy Spool' - never come across that before...

if you need to know it in detail then you can refer to the following link

https://www.simple-talk.com/sql/learn-sql-server/showplan-operator-of-the-week---lazy-spool/

Ed Wagner SSC Guru Points: 287026 More actions · Answer 5

Yup - It make me research it as well. Thanks for the question.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

steve.jacobs SSCommitted Points: 1830 More actions · Answer 6

steve.jacobs

SSCommitted

Points: 1830

December 10, 2013 at 6:17 am

#1672287

Steve, nice and easy. Thanks

+1

Tee Time Hall of Fame Points: 3745 More actions · Answer 7

Tee Time

Hall of Fame

Points: 3745

December 10, 2013 at 6:20 am

#1672289

Thanks, Steve. Good question.

Hany Helmy SSChampion Points: 13921 More actions · Answer 8

Ford Fairlane (12/9/2013)
Yet another great question that required some digging to ensure the correct answer...

+ 1, Thanks 🙂

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

Ken SSCoach Points: 17191 More actions · Answer 9

Had to do some research on this one too. At first I thought it was regarding SSIS transforms. Granted, had that been the case, only aggregate and union would have made any sense. Also, operator wouldn't have been the correct term to use. After pausing for some coffee, I switched my focus to the query plans.

Thanks Steve!