Viewing 15 posts - 3,226 through 3,240 (of 7,484 total)
Gary Varga (8/22/2013)
I agree with what I think the general consensus is: the time when this was acceptable as a flaw due to lack of knowledge and education has passed.
Yes,...
August 22, 2013 at 11:30 am
Obviously there's no way to avoid a complete scan when all the values are the same.
It's possible to have something which takes quadratic time when all the values...
August 22, 2013 at 10:35 am
RonKyle (8/22/2013)
no-one held it today, but you are showing me that I was absolutely wrong about that.
Well, then I'm glad. However, I didn't create that. As...
August 22, 2013 at 8:42 am
Nick Doyle (8/22/2013)
August 22, 2013 at 8:12 am
RonKyle (8/21/2013)
I favour moving as much application business logic into stored procedures as is possible, thereby abstracting out the UI layer from the business logic
I think I can help with...
August 21, 2013 at 5:43 pm
hakan.winther (8/20/2013)
L' Eomot Inversé (8/20/2013)
hakan.winther (8/20/2013)
+1 Learned something new today. The leaderbord has a bug, is that the reason why I am not at the top? 😀
I doubt it; probably...
August 21, 2013 at 5:22 pm
Phil, I find myself about 95% in agreement with you; the 5% discrepancy is because I think you are understating your case.
For a long, very long, extremely long time...
August 21, 2013 at 5:09 pm
Anyone who did what is suggested in the last sentence of the editorial ought to be given a good thrashing with a clue stick. (My comments here are...
August 21, 2013 at 4:50 pm
I like the "do everything through stored procedures" approach, and have been practising and advocating it for more than a decade. I'm surprised it isn't used more often, since...
August 21, 2013 at 9:46 am
GilaMonster (3/19/2013)
For B to be correct, it needs ORDER BY CustomerName added at the end.
Strictly speaking that's not true, as it doesn't need ORDER BY CustomerName, as it could have...
August 21, 2013 at 8:45 am
crookj (8/21/2013)
Daniel Bowlin (8/21/2013)
starting overReboot
UNIX SVR3
August 21, 2013 at 8:10 am
Interesting question. I'm surprised so many got it right - surely people don't use identity insert so much that they either know this from experience or have taken care...
August 21, 2013 at 8:04 am
Viewing 15 posts - 3,226 through 3,240 (of 7,484 total)