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
Posted Thursday, August 1, 2013 6:14 AM


Group: General Forum Members
Last Login: Friday, May 22, 2015 10:35 AM
Points: 1,942, Visits: 7,081
Mike Dougherty-384281 (8/1/2013)

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


Post #1479898
Posted Friday, August 2, 2013 9:04 AM


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


Group: General Forum Members
Last Login: Yesterday @ 12:03 PM
Points: 154, Visits: 83
hesitated for a moment thinking this was a trick question
Post #1554704
« Prev Topic | Next Topic »

Add to briefcase «««12345

Permissions Expand / Collapse