pradocchia

10 ms·

31.
by pradocchia 13y ago
The OUTPUT clause in MSSQL doesn't require a CTE, and can be used with INSERT, DELETE and MERGE in addition to UPDATE. Likewise, your example can also be done with derived tables, which predate CTEs in MSSQL: UPDATE a SET col2 =
32.
by pradocchia 13y ago
CTEs are defined as being optimisation boundaries and databases are not allowed to optimise across CTEs. Wait, no. I know for a fact that SQL Server will happily optimize across CTEs. They are effectively syntactic sugar, and handled much
33.
by pradocchia 13y ago
There was this Hittite king who might or might not have had a son, but definitely moved his seat of government from one place to another, and then his brother moved it back, and all 8 people who care are like “Why’d he do that? Tevs.” -
34.
by pradocchia 13y ago
You may be a paragon of merit, but some of us have merely been fortunate in our gifts and circumstances and long-tail events.
35.
by pradocchia 13y ago
> I'm maybe too much of an optimist , but I've always felt like we're(Americans) a bit less realpolitik than the rest of the world, and that if it were to come to shooting Americans for political gain, somebody would say s
36.
by pradocchia 13y ago
Pyongyang looks like Beijing in the 1990s: same road design, same light traffic, same electric bus lines, lots of bikes, lots of simple concrete construction, a few glitzy high rises.
37.
by pradocchia 13y ago
People would make their own entertainment if sports and Hollywood were not available: games, stories, conversation, crafts, and so on. Our lives might even be a bit richer for it. And in that sense, the entertainment industry captures value
38.
by pradocchia 13y ago
Maybe Google is trying to do us a favor, and spare us the illusion of anonymity when true anonymity is dead. That's my most charitable interpretation. Less charitably, they simply don't care how their policies happen to burn x% of
39.
by pradocchia 13y ago
Don't be absurd. Midwives are practitioners in the field of child birth. Some will have acquired a highly developed sense of what works and what doesn't. It is foolish to ignore their experience.
40.
by pradocchia 13y ago
The markets probably underprice the value of forgiving debt. For instance, cancelling all mortgage debt under $300K would liquefy the housing market overnight and bring housing prices more in line w/ income, while improving public heal
41.
by pradocchia 13y ago
Some day, when the AI systems take over, and the world no longer needs so many people that enjoy reading programming manuals and studying Fourier transformations, the great bulk of programmers will be lined up and shot, in retribution for t
42.
by pradocchia 13y ago
It would have sufficed to find out if he was willing to travel. Ah, but it would not have sufficed. They were planning to go whoring in Korea. (Yes I am reading between the lines here.) That's why they asked, "are you single?&qu
43.
by pradocchia 13y ago
But it ended with his death and there was a backlash from power. That's what doesn't make me worry about the NSA actually spying on US political figures. On the contrary, FBI Deputy Director W. Mark Felt brought down Nixon throu
44.
by pradocchia 13y ago
Yes, but no: Kennedy didn't just have a thing for Social Register girls; he had a thing for humiliating Social Register girls. He also had a thing for humiliating his fellow Irishman, Dave Powers. Alford and Powers may have felt humi
45.
by pradocchia 13y ago
Well, in so far as the episode by the pool was concerned, there was consensus among all three present--Kennedy included--that he should not have done what he did. Perhaps he was just shamed by Powers. That doesn't reflect well on him e
46.
by pradocchia 13y ago
That was an occupational hazard in Sinology for many years. Still, it's a great resource--the bibliography alone is a great resource.
47.
by pradocchia 13y ago
Well, there is this, by Joseph Needham, in 7 volumes: http://en.wikipedia.org/wiki/Science_and_Civilisation_in_Chi... If you have access to an academic library, they may have a copy.
48.
by pradocchia 13y ago
The child who doesn't want to learn is the child who doesn't learn to walk and talk. They are few and far between. Things may happen later on that co-opt or subvert whatever gets the child going, and by the time you come along the
49.
by pradocchia 13y ago
I was instantly hooked, programmed daily, and some 35 years later I'm still lovin' it. This doesn't demonstrate innate ability. It demonstrates your interest in programming. Do we have natural born interests?
50.
by pradocchia 13y ago
What I find interesting about RMS isn't that his productivity was suspect, but frankly that it just ended in the late 80's. IIRC, RMS had developed pretty severe wrist pain by then, and was forced to dictate his code to assista
51.
by pradocchia 13y ago
The issue has been looked at by various think tanks. The question of trust is relevant to public health policy of course, but also to other areas of governance. If the response is simply "better messaging", that will backfire even
52.
by pradocchia 13y ago
I appreciate the appeal to reason and evidence, but these arguments miss the root: trust. Many people don't trust the medical establishment. If more people did trust the medical establishment to consistently provide optimal treatments
53.
by pradocchia 13y ago
It means, when I add two spaces after a comma, I have increased its visual strength and thus I may choose alternate syntax where I don't want a strong break. eg, "already, I have" -> "already have I". The
54.
by pradocchia 13y ago
Did you even read the article?
55.
by pradocchia 13y ago
Nice article and nice use of primary sources. The convention was: put wider spaces than word spaces after punctuation, and put an extra-wide space after a period. I will try this for two weeks: three spaces after the period; two after t
56.
by pradocchia 13y ago
re: discrete log vs ECC, Schneier wrote the following in the comments section of his blog: I no longer trust the constants. I believe the NSA has manipulated them through their relationships with industry. http://www.schneier.c
57.
by pradocchia 13y ago
> It turns out they didn't secretly have reliable information the rest of us didn't. They were blinded by conviction and ideology. They really, really wanted to invade Iraq. It never made any sense from the rhetoric alone.
58.
by pradocchia 13y ago
There have been laws, prohibitions and taboos against usury since time immemorial, and for good reason. It's a dangerous thing. "Personal responsibility" is manifestation of this same societal impetus to restrain debt, in thi
59.
by pradocchia 13y ago
The potential of abuse for guns is pretty damn large, but some would argue that the US was founded on the idea of gun ownership. Yes, and those guns were widely distributed among the general populace. It was this wide distribution that co
60.
by pradocchia 13y ago
Right, so you are describing what Kuhn termed the period of "normal science": theory in hand, collect new facts, fit facts to theory, repeat. HOWEVER, that theory-in-hand rests on an earlier paradigm shift, where previously anomal

More ›