Viewing 15 posts - 1,891 through 1,905 (of 8,416 total)
The 'order of update' you refer to is a consequence of physical implementation details that you cannot rely on. Yes, it is true that in one scenario you 'always'...
July 7, 2011 at 5:12 am
Hi Chris,
There's no need for a join at all - a point I realised after editing the TOP trick into your code. I have updated the code and query...
July 7, 2011 at 4:58 am
ChrisM@Work (7/7/2011)
You'd think so, but it's not straightforward...
MIN and MAX may not be allowed in the recursive part, but MIN and MAX are no more than the first row (TOP...
July 7, 2011 at 4:10 am
S_Kumar_S (7/7/2011)
ok, but i am sure, clustered index always gets sorted data on key columns, without adding ORDER BY, Always.
No, that is not correct.
July 7, 2011 at 3:38 am
Kit G (7/6/2011)
All you Aussies and Kiwis stay safe, just heard of a tsumani warning for northeast New Zealand and Australia (East Cape and Auckland).
Hopefully it will only be small,...
July 6, 2011 at 2:39 pm
Lynn Pettis (7/5/2011)
July 5, 2011 at 10:36 pm
Just so we're all clear on this, I'm interested in how you justify things like attending the summit to the person paying. I have heard of some people having...
July 5, 2011 at 10:47 am
SQLRNNR (7/5/2011)
Could do that - but the networking sometimes is more valuable than attending the courses.
To you, or to your employer? 😉
July 5, 2011 at 10:28 am
David Portas (7/5/2011)
July 5, 2011 at 7:23 am
CREATE TABLE #Changes
(
account_id INTEGER PRIMARY KEY,
the_address ...
July 5, 2011 at 12:47 am
James Goodwin (7/1/2011)
It would be nice if there was a more clean SQL syntax than (X is NULL OR X <> 'Value'), but that is implementation, not theory.
There is an...
July 4, 2011 at 7:54 am
ALZDBA (7/4/2011)
July 4, 2011 at 5:29 am
tnk7200 (6/30/2011)
I don't think there's any confusion about today question. Thanks Steve.
Uh oh!
Trace flags can also have statement scope, using the (undocumented) OPTION (QUERYTRACEON xxxx) syntax. Just saying.
July 4, 2011 at 5:26 am
There are a number of possibilities - too many to speculate on. If you would like a precise answer, please post the full output from the two runs with...
July 4, 2011 at 5:06 am
Tom.Thomson (7/3/2011)
[...] you also have to work hard to earn the rest of the costs (eg travel, accomodation) [...]
Exactly. I think Gail's in the same boat (so to speak)...
July 3, 2011 at 8:53 pm
Viewing 15 posts - 1,891 through 1,905 (of 8,416 total)