Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Ordered Data Expand / Collapse
Author
Message
Posted Monday, December 9, 2013 9:57 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 10:39 AM
Points: 33,097, Visits: 15,204
Comments posted to this topic are about the item Ordered Data






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1521387
Posted Monday, December 9, 2013 10:40 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 12:45 AM
Points: 1,679, Visits: 751
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





Post #1521397
Posted Tuesday, December 10, 2013 4:35 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Monday, July 28, 2014 5:56 AM
Points: 632, Visits: 1,152
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
Post #1521458
Posted Tuesday, December 10, 2013 5:15 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, July 4, 2014 9:03 AM
Points: 1,415, Visits: 796
'Lazy Spool' - never come across that before...
Post #1521468
Posted Tuesday, December 10, 2013 5:29 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Monday, July 28, 2014 5:56 AM
Points: 632, Visits: 1,152
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/
Post #1521470
Posted Tuesday, December 10, 2013 5:41 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 10:43 AM
Points: 3,986, Visits: 3,004
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
Post #1521471
Posted Tuesday, December 10, 2013 6:17 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, March 20, 2014 6:00 AM
Points: 588, Visits: 276
Steve, nice and easy. Thanks

+1
Post #1521491
Posted Tuesday, December 10, 2013 6:20 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, July 24, 2014 1:50 PM
Points: 532, Visits: 448
Thanks, Steve. Good question.
Post #1521493
Posted Tuesday, December 10, 2013 6:30 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, July 28, 2014 4:38 AM
Points: 1,139, Visits: 520
Ford Fairlane (12/9/2013)
Yet another great question that required some digging to ensure the correct answer...

+ 1, Thanks
Post #1521496
Posted Tuesday, December 10, 2013 12:23 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 10:45 AM
Points: 3,266, Visits: 1,959
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!
Post #1521642
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse