I am planing to have very soon few highly loaded postgresql databases. I have some expirience managing mysql databases with high load, but now we have to use postgresql.
I want to know what are the best tools for day-to-day database management and status reporting. (Of course console is the best...
@ConcernedOfTunbridgeWells just one so far - don't ask me to keep calm
@dezso not if they're sufficiently answered - do they need new answers? That'd be the only reason to keep it open. The C++ book model on SO has a community wiki answer that everyone keeps updated, rather than invite new answers or keep different sets of resources separate. The other thing I like about closing them is that they can't be used as "but this person asked a similar question, and it's not closed!"
@dezso I suspect that will be a long list - and I don't know if there's an easy way to see when this trend started, or how long the user may have waited to exact their revenge. It'd all be speculation.
Flagging is actually more likely, at least in my few run-ins with this on SO, the reason is that the scorned user pissed off is a new user who doesn't understand how the site works, thinks that closing their question is abuse, and doesn't have the rep required to VtC.
@phil note that sometimes I will vote to leave a question open if the vote is to move it somewhere else and the question itself is craptastic
@dezso doesn't make them on-topic. If they have good answers that haven't become obsolete I'm ok with leaving the question up on the site, but don't want to encourage more answers or use them as examples of questions to be asked here.
@dezso I think it means that if there are enough LeaveOpen votes (without any Close), then it is removed from the queue. Not really sure though, and no idea if there are rules when both close and leave open votes are placed.
@ypercube oh that may be true. I do know though that a leave open vote by a moderator is not binding (the close votes are still there, though I don't know if it's in the queue still because the queue knows I've already seen it so doesn't show it to me).
Anyone else finding that KB articles from support.microsoft.com are taking a minute or more to finish loading lately? I'm not yet sure if it's just the BlueCoat proxy that's been installed here or something else.
@JamesLupolt try support2.microsoft.com instead of support.microsoft.com - the latter was showing blank articles for 48 hours last week so this is probably still residual from that.
@Phil Save a few bucks with the latter but IMHO not worth it
@Phil Since the new dustbins came out they just aren't in demand anymore.
@Phil, apropos of nothing at all, get one of at least Nelahem generation. At that point Xeons went from FSB to Quickpath (and were thus much, much faster). You might have to do your homework about which models had this architecture.
@ConcernedOfTunbridgeWells my uncle still has a 1964 Cadillac. That doesn't mean it's the norm. I had two $5000+ Dells that limped past the warranty date and died.
I think Dell workstations might be better now than then. The HP workstations feel like old-school Compaq machines - the fit and finish is the best I've seen on a PC in about 15 years.
If you're going to spend 4000-5000 pounds on a workstation, it better come with free hummers, dancing girls or something that makes it a lot more compelling than a Mac Pro
Especially since you have to regain trust from people like me who don't believe they will last as long.
And who have time to invest in reformatting Windows 8.yuck off of there...
So many people get hung up on the "I need to use Windows" bit, and think that makes Macs a non-starter. My job revolves solely around Windows + SQL Server and I haven't owned a PC in 7 years.
@Zane Varies. They're two socket boxes with a server chipset on the motherboard. The main claim to fame is that you can put a shit-load of memory on them.
But I also argue with people like Kendal who brag all year about how much money they save on cutting their cable TV cord, then bitch every time they try to watch live sports
I suppose you've got the fact that most of these are dual machines and if what you're using it for isn't processor bound you can save tons of cash cutting back on that.
Hey man, to each his own. If you want a screaming machine, you're likely spending about the same amount of money regardless of which vendor you go through. If you just need to get by, you're not. Some people are happy with an '82 Tercel that still runs, or an '11 Civic. Some people aren't. There's no universal right answer for what computer to by. It's how much are you willing to spend and how much performance do you need.
These days I think the main claim to fame of something like a Z820 is the memory capacity. If you wanted something memory heavy (maybe an in-memory server like Tabular Model or Qlikview) then it might be useful.
@ConcernedOfTunbridgeWells yes, dual boot just for the odd game or two. I've no need for windows otherwise, as I have a VMware Fusion licence (and parallels, was hard to choose between them at one point).
@Phil It's quite a few years since I scratch-built a PC, although I put new CPUs, fans, memory and disks on all the 9300s I built so they might as well be.
@Phil Is there anything wrong with the performance of the machine you've got at the moment? The cheapest upgrade is none at all, and an i7 ought to be pretty quick.
@Phil @ConcernedOfTunbridgeWells I've been thinking about one of these. 32 GB of RAM so it's probably decent for a home lab, plus has a decent GPU if I want to play games or crack passwords. Anything other than a laptop isn't really a good option for me since I have a very small apartment.
@JamesLupolt I had a cow-orker who had a shiny new Clevo that overheated and died. My thinkpad was quite a bit more expensive but still keeps trucking. As an alternative to a laptop, you could look at something like this: www8.hp.com/us/en/campaigns/workstations/z230.html
They're about the size of little corporate desktop machines and you can get them off ebay quite cheaply (especially older models).
hello, I have a question stackoverflow.com/questions/8730933/…: why is preferable the use of boolean logic instead of the case in the where clause in sql server?
You need to write a query that groups data by year, you can't just barf a table name at an adapter and expect C# to know what you want to do. — Aaron Bertrand19 secs ago
@EmilioGort I don't quite understand your question. Why is the answer written WITHOUT a CASE expression? Other than the facts that it doesn't need a CASE expression and that writing it with a CASE expression would be longer and more tedious?
well yes, I have some legacy code and all the condition in the where are wirtten with case, I'd like to know is it preferable avoid the use of case statement in the where clause
for me is easier understand the normal and ,or that the Case
@JamesLupolt Probably better off with a W series thinkpad or something similar. If the new price induces a sharp intake of breath and/or tightly clenched buttocks then you can get ex-lease ones off ebay if you don't mind a spot of tinkering.
@JamesLupolt and if you order from Amazon (depending on what state you deliver to) you don't pay sales tax. Same for eBay. You're supposed to declare that on your taxes, but nobody does.
Am I the only one with a soon-to-be former employer that does not grasp the concept that I have to cut all ties with them since I am going to work for another consultanting company?
I mean I can understand the general question or two down the road on process or work previously done...but he is still asking me to do work for him "down the road".
I copied some xml to an answer, and I formatted it as code, but it hides everything between the < and > braces.
Answer is here.
What did I do wrong?
