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 «««12345

T-SQL Expand / Collapse
Author
Message
Posted Thursday, August 1, 2013 6:14 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 10:22 AM
Points: 1,830, Visits: 6,646
Mike Dougherty-384281 (8/1/2013)


This is why we need a "+1" or "like" signal that doesn't clutter-up the thread. :)


+1!

(oops)
Post #1479898
Posted Friday, August 2, 2013 9:04 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 28, 2014 7:12 PM
Points: 2,148, Visits: 487
I think the bottom line is that SQL Optimizer will return rows in the best order it sees fit based on execution plan. There are definitely cases, especially with larger tables using parallelism, when even the order of the clustered index is not obeyed/returned to the calling client.....
Post #1480455
Posted Tuesday, March 25, 2014 3:29 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, October 2, 2014 5:23 PM
Points: 116, Visits: 56
hesitated for a moment thinking this was a trick question
Post #1554704
« Prev Topic | Next Topic »

Add to briefcase «««12345

Permissions Expand / Collapse