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

CTE - Temp table - CROSS APPLY Expand / Collapse
Author
Message
Posted Thursday, April 11, 2013 12:19 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, July 31, 2014 3:56 PM
Points: 223, Visits: 167
Two queries that do not have "ORDER BY" running at the about the same time might give results in the same order but might not. For example: the order of data returned can depend upon the query plan chosen which can vary by the memory available to the query which varies from instant to instant.
Post #1441417
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse