Viewing 15 posts - 1,846 through 1,860 (of 8,416 total)
Hi Wayne,
It always confuses me when a CTE and subquery are compared like that - they are equivalent.
Beware drawing performance conclusions from CTP (beta) software. From what I have...
July 15, 2011 at 11:55 am
SwePeso (7/15/2011)
SQLkiwi (7/15/2011)
No, of course not. Neither SUM nor COUNT can use OVER ... ORDER BY before Denali.
I think Peter meant if existing code was ported to Denali and...
July 15, 2011 at 7:46 am
peter-757102 (7/15/2011)
Ineresting amount of control, but am i right to read in this that the default for this new functionality alters the meaning of existing code?
No, of course not. ...
July 15, 2011 at 7:34 am
Richard Warr (7/14/2011)
Good question but haven't we seen it before?
I thought so too, though I can't find the previous question. So, an easy 'green tick' for me today, but...
July 14, 2011 at 1:21 pm
Wayne, you can avoid the join:
UPDATE target
SET AccountRunningTotal = art,
AccountRunningCount = arc
FROM
(
SELECT
td.AccountRunningTotal,
td.AccountRunningCount,
art = SUM(td.Amount) OVER (PARTITION BY td.AccountID ORDER BY td.Date, td.TransactionDetailID),
arc = COUNT_BIG(*) OVER (PARTITION BY td.AccountID...
July 14, 2011 at 12:11 pm
Thanks! FYI I'm now using QotD-sneak-o-meter v2, which uses a logarithmic scale. I had to buy a replacement after my original meter had its needle wrapped around the...
July 14, 2011 at 11:18 am
Sean Lange (7/13/2011)
I also got this wrong because I chose 1 -64 processors. This argument/discussion can go either way really.
I think making a distinction between affinity I/O mask and affinity64...
July 13, 2011 at 7:21 pm
Jim Murphy (7/13/2011)
Oh, that hurt! 1 point for you.
Sorry! :Whistling:
July 13, 2011 at 2:05 pm
Ninja's_RGR'us (7/13/2011)
Am I missing a really easy joke or you didn't post the correct picture?
The joke is he is using FireFox 😉
July 13, 2011 at 1:52 pm
PHXHoward (7/12/2011)
Why do these give me different results? 0x80 has an even number of characters.
select CONVERT (bigint, convert(VARBINARY(20),'0x80') ,1)
select CONVERT (bigint, 0x80 ,1)
You're asking different questions....
July 12, 2011 at 5:05 pm
The Dixie Flatline (7/12/2011)
Forget Denali and R2... It's almost time to start talking about (American) Football again.
[font="Comic Sans MS"]Oh good.[/font]
Comic Sans MS is the official sarcasm font, I'm told.
July 12, 2011 at 2:32 pm
A couple of hours after Denali CTP3 and R2 SP1 are released, and what are you all talking about?
Banks and social contracts.
:blink: :laugh:
July 12, 2011 at 1:57 pm
opc.three (7/11/2011)
July 11, 2011 at 11:46 am
Flexdog (7/11/2011)
Yes, similar to EXISTS however the original post omitted the groupid predicate...
I don't see a missing predicate. Do you mean a column name?
...and pain-avoidance from the past I...
July 11, 2011 at 11:46 am
Craig Farrell (6/23/2011)
July 11, 2011 at 11:38 am
Viewing 15 posts - 1,846 through 1,860 (of 8,416 total)