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: Today @ 10:16 AM
Points: 1,987, Visits: 7,192
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: Wednesday, June 3, 2015 11:25 AM
Points: 155, Visits: 84
hesitated for a moment thinking this was a trick question
Post #1554704
« Prev Topic | Next Topic »

Add to briefcase «««12345

Permissions Expand / Collapse