I am trying to learn more about Relational Databases and I figured there is no better way to learn then to actually do something. I decided to make a personal attempt to look at Personal Budget Accounting and Forecasting. I have done some research thus far and would like to get some insight on my...
I installed Postgres and I am going to give that a try. I have had some experience with MsSQL in the past and not too much of a fan of MySQL. I updated and redacted a lot from the original question. I will try and post the other questions in the next few days I am sure there is no rush. I just wanted to say I really appreciate everyone's generosity and help!
> My first **ask** is to isolate which of these changes had a component on <server> that was affected. > The second **ask** is to determine how that change is or isn’t affecting the performance on <server>.
I'd love to reply saying:
The above wording might be better worded like this:
> Please isolate which of these changes had a component on <server>, and determine how that change is or isn’t affecting the performance it.
.
Why is it so hard to write sentences that make sense?
damn, the edit time-out on chat messages is friggin' annoying.
lol. Most of the questions are not by superusers, presumably, so perhaps there is a lower standard there. And maybe that's why almost no-one votes there.
@hot2use Windows Store apps are totally painful - that game I reference in my question is well over 100 GB to download, and needs to be downloaded on every computer where you want it installed - there is no way to download the installer, then install it where you want. And you can't even run "repair" on it to have it patch up any problems... On the other hand, most regular Windows apps work really well and can be uninstalled, reinstalled, or even repaired (gasp!).
I was able to download the package using an http sniffer, but the package is encrypted, requiring a special decryption key that is protected by the Windows Store app itself.
I agree with that 100%. I bought a 1TB Samsung 850 SSD for storing that kind of thing, but I sure don't want 10% of it being wasted for each extra instance of the same game.
Seen on the interwebs today - one dollar worth of bitcoin takes 17 million joules of energy to mine on average. That's roughly the explosive yield of 4kg of TNT.
@ConcernedOfTunbridgeWells A mined block (12.5 BTC) is worth (~$6500 * 12.5) approximately $81,250 without transaction fees. If you assume average worldwide electricity costs $0.05 USD per Kilowatt Hour for mining, then you can only consume 1.625 MegaWattHrs per block before mining is not profitable. 1.625 MegaWattHr in joules is 5.850,000,000. Ergo, joules per dollar should be 5.850,000,000 / 81250 = 72,000. Of course, math is hard, so I may have done something wrong.
And if electricity is free, then this goes right out the window.
Even if electricity was $0.01 USD per kilowatt hour, it would still only be 360,000 joules per dollar.
I think many of the people promoting how expensive it is to mine bitcoin don't actually understand economics. Of course, I'm not talking about you... I'm talking about the incumbents who want bitcoin to fail.
Transaction fees might be trotted out as something I've left out, but if you look at any of the various bitcoin block explorers out there, you'll see blocks are currently being mined with around 0.22 BTC per block, which is ~$1430 USD.
these on Nov 1st: https://dba.stackexchange.com/questions/183251/select-from-clause/ https://dba.stackexchange.com/questions/134642/i-run-the-script-and-it-freezes-me-but-varcharmax-and-nvarcharmax-1-always/
down 120 rep as a result :-( - oh well, all those questions were really quite crap.
My question is simple - when should I cast delete votes?
I've recently reached enough rep on one of the sites to be able to cast delete votes. I am not sure when a question is supposed to be deleted as opposed to just remain closed. What criteria should I use when deciding whether or not to cast...
@PaulWhite I think your assessment in that meta post is the most likely reason why people don't vote to delete.
> The simple reality is that people with the power to delete don't often encounter questions that ought to be deleted, when they are able to delete them
I'm implementing an app with a payment system, and I need to record transactions that are made through the app. Also I need to use some of the information about the transaction for rendering some KPIs. I have an implementation already in Postgres in which my table has 2 columns, an Id and transac...
