I do want the string built in Sequence Order.
Here's the weird thing- query #2 has been working for 4 months. Not sure what changed, but the explanation that the rows are being fetched slow makes sense (they're always messing with my server settings!).
The Top 800 is included in the subquery because MS SQL returns an error without it- Can't use an Order By in a subquery without a TOP. 800 just happens to be ~5x the current number of Model Points in the Model Points Table (and thus, this function should NEVER return that many rows).
But the idea that it's a [good, bad] thing should be agreed first,
It has been. The french government is democratically elected.
simply shrinking the market doesn't radically change things,
The market doesn't shrink. The market is the number of exchanged goods. The market doesn't care if there are 200 merchants or 250 merchants. What changes is the distribution of goods and merchants, and when the number of merchants is very low and their concentration of market power high, we get into situations (oligopoly, monopoly) that we do not want because we know they are bad.
If you want a book that isn't in the bestsellers list, then in your local town there's probably only one or two book shops that stock it at best and most likely none.
For the past 20 years, when I go to a bookstore and I want a book they don't have, they could almost always order it and have it for me the next day.
while it'd be nice to have geographically distributed demand for labour, in practice this has not been true since the invention of cities.
I'm not talking about a perfect equilibrium. I'm talking about the simple fact that if your country has one region with 50% unemployment rates and one region where employers can't find workers, your whole country will destabilze.
Of course there will always be differences. But if they get too extreme, the consequences are much higher and much more expensive then the costs of some small interventions.
What's more once you decide that lots of people deserve to be protected from changing times,
I never said anything like that and my arguments are completely unrelated to technical or other progress. So please burn the strawman somewhere else.
A revolution, however warranted, would lead to an unimaginable amount of freezing and starvation within the first two winters
Why, would the failing government interdict traffic? That wouldn't be the revolution causing freezing or starvation.
Without being in favor of the death penalty it sounds like it may well have a silver lining in this case.
No, the murder of two people does not have a silver lining, especially mentally ill people.
Why didn't they sell these kids to adoption agencies? The kids would have been better off. Is there some law that prevents the sale of children to adoption agencies such that they turned to slavers instead?
Well, it confounds it at any rate. But completely filling the device's memory 33 times in a row is pretty likely to overwrite everything at least once or twice - even the hidden "failure reserve" space if it's included in the wear leveling (and if it's not, then it doesn't yet hold any sensitive data, so there's no problem). Guttmann's values may be irrelevant to today's storage media, but that many repeated rewrites of anything still mostly does the job.
If you were an engineer in charge of destroying data printed on paper, and you decided on shred then burn then stir the ashes in water, how many times would you repeat the cycle in order to be sure the data was destroyed? Hint: if your recommendation is greater than one (in order to be pretty sure), check your job title, because you're probably Dilbert's pointy-haired boss.
Drives today work almost nothing like the drives of 20 years ago. They don't paint bit-bit-bit in a stripe, they encode a set of bits in every pulse of the write head. Alter it a tiny fraction, and it becomes a completely different set of bits, one that error correction won't be able to overcome.
Old disks were recoverable because the mechanisms weren't precise, and the data was written with big chunky magnets to assure it was readable. All that slop has been engineered out on order to achieve today's remarkable areal densities. One overwrite is all it takes - as long as you're overwriting it all.
If people really care about global warming and economic activity, they should read the latest IPCC report. It says that the best way to avoid warming is economic development. If the economy freezes in place (something a high carbon tax could do) then the warming will be about 4C by the end of the century. If the economy in all the "third world" countries develops into something like first-world conditions by the continued march of progress, then the warming will be closer to 1C.
Anything that stands in the way of that development is going to contribute to the warming. Removing these tariffs is a good thing, but to get maximum environmental benefit they need to get rid of the rest.
I know, Overton's Window and all.
only available in CO and WA.
I'll have to see if my Bundt pan boils water quickly. Or hammer an iron rod on an old pot.
small local bookshops are inherently worth protecting. Why is that?
Because you need many, many competitors in a market for it to actually be a market. The amount of large corporations any market can support is limited and fairly low, general business wisdom has it that it is around 3-5 with the first 3 being profitable and two or so more being able to just barely make it.
If you want many participants in a market, most of them will be small. That is why small shops are worthy of protection.
You also want to have employment in your country be fairly even, and not have some areas with high demand and low supply and some with low demand and many unemployed, which is why local shops are worthy of protection.
Really, you just need to use your brain a little more and it's all very simple.
Perhaps the space the bookshops used up can be replaced by coffee shops
Maybe, but this is not at all about bookshops being replaced by something else, it's about small competitors being driven out by large competitors, so put the strawman away again.
Protectionism is protectionism,
And sometimes it is needed. The whole "free market über alles" philosophy makes assumptions that are not true in the real world, such as perfect transparency. To come even close to working as it should, the free market needs to be guided. Among other things, protecting small competitors guarantees that it remains a free market and doesn't turn into an oligopol or a monopol.
The ones that actually provide value to the customer will stay due to people actually visiting them.
Unfortunately, they will not. Too many people will use the cozy atmosphere and the good service to make their selection, and then order it online because it costs a dollar less.
Yes, poor buggy whip makers will be out of jobs in the short term, but we can't all be riding carriages into the future...
Except that Amazon has not invented the car. The buggy whip makers are not going to be out of jobs, they are going to be replaced by minimum-wage buggy whip warehouse slaves.
There are real industrial design reasons to have a round watch on your arm. The ease of drawing to a rectangular display buffer do not outweigh them.
Any marginal blocks mapped out before you encrypt will remain unencrypted and may be available to a determined attacker. Same goes for hard drives, and SATA secure erase is not provably trustworthy. Always encrypt your storage before you put any data on it. If you do not trust your hardware AES to not be backdoored then use software crypto.
This.
What is the value of a used device? Compare that to the risk of the data on that device going to a malevolent third party.
I've had people saying "oh, look at all these hard drives, you should totally sell them on ebay and I bet you could get $10 apiece for them!" Adding up the time I would waste running DBAN or sdelete or whatever, and keeping track of which ones have been wiped, and double checking to make sure everything is really gone, it's not worth the time.
A big hammer and a punch, driven deeply through the thin aluminum cover and down the platter area, takes about a second and leaves nothing anybody would bother trying to recover. You can quickly look at a drive and say "yes, this drive has been taken care of", or "hey, there's no jagged hole here, this drive isn't destroyed." The aluminum cover contains the shards if the platters are glass. I don't care who handles them after destruction. There's no worries about toxic smoke. And if you have to inventory them before shipping them to a recycler, the serial numbers are still readable.
Smashing a phone wouldn't destroy the data on the chips, so a fire is a somewhat safer option.
Many people are unenthusiastic about their work.
