Forum Replies Created
Viewing 15 posts - 526 through 540 (of 4,080 total)
-
RE: Are the posted questions getting worse?
Grant Fritchey (6/27/2014)
Koen Verbeeck (6/27/2014)
Grant Fritchey (6/27/2014)
Anyone think they can help this person? I think they really need it, and what's more, deserve it. 6.5? Please, no.6.5 to 2000 with...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Are the posted questions getting worse?
GilaMonster (6/17/2014)
Gotta love a review system where an above-average rating requires "Leaves only when work is done and stays to assist others""No pressure to work overtime" they say. :ermm:
So, basically...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Are the posted questions getting worse?
GilaMonster (6/14/2014)
Koen Verbeeck (6/14/2014)
Ah, the world cup...
Yup, that's pretty much how I feel.
I have little interest in sport. Most of the time that's fine. This week, I can't even go...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Are the posted questions getting worse?
Luis Cazares (6/13/2014)
SQLRNNR (6/13/2014)
The Dixie Flatline (6/13/2014)
Sean Lange (6/13/2014)
I hope I don't have to avoid SSC for the next month so I don't hear scores before I am able to...__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Are the posted questions getting worse?
Sean Lange (6/13/2014)
I hope I don't have to avoid SSC for the next month so I don't hear scores before I am able to watch the games on my DVR....__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Are the posted questions getting worse?
Go home before you kill the developer or after you kill him?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Are the posted questions getting worse?
jasona.work (6/13/2014)
Awful quiet in here over the last couple days...Should we turn out the lights on this thread?
:hehe:
We have lights in here now? THAT's why I've been squinting...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: output identity values
Thanks for letting us know, vasuarjula.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: output identity values
Sean, I'm just kidding with you.
I wasn't continuing this discussion in order to "win" it. The best discussions ultimately reach a consensus, because everyone understands the other person's...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: output identity values
Go ahead, Sean. Spoil my fun. :crying:
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: output identity values
This has turned into a very enjoyable discussion. 🙂
-Rolling over a period is a one-off per period, performance considerations in that sense aren't great.
(I agree.)
-Having to look up the...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: output identity values
That's where we disagree. 🙂
When I set statistics time,io on for the JOIN solution, it gives the following results:
Table '#B558B379' Scan count 0, logical reads 3
Table #test...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: output identity values
Sorry to be so late in responding. 🙂
Take a look at the following code and maybe it will clarify the situation.
create table #test
(col1 int identity(1,1),
col2 varchar(20),
...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: output identity values
Eirikur Eiriksson (6/6/2014)
The Dixie Flatline (6/6/2014)
That will work but it's pricey in performance compared to just adding the column.Agree on the costly part but exactly the same work then would...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: output identity values
That will work but it's pricey in performance compared to just adding the column.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
Viewing 15 posts - 526 through 540 (of 4,080 total)