« first day (1968 days earlier)      last day (3199 days later) » 

06:11
Can't get the search to return messages posted after 2015-04-07. Can this mean the index rebuilding process stopped or is it still working and we just need to wait till it completes?
Another curious review item, this time in the First Posts queue: dba.stackexchange.com/review/first-posts/70628
The question was asked 6 days, shows up in First Posts just now
07:09
*6 days ago, of course
07:39
What's the opposite of "link-only answer"? I think this one could qualify:
3
A: Oracle 11g R2 on CentOS 6.3, and Net Configuration Assistant

Marcelo Woerneri'm recently install oracle linux on linux mint using this: https://mikesmithers.wordpress.com/2011/11/26/installing-oracle-11gxe-on-mint-and-ubuntu/ its works, the step are so many soo for that see the guide, good luck :) EDIT: ** C&P from the guide ** Installing Oracle 11gXE on Mint and Ubu...

My take on it:
This is impressive, but does the question really require such an answer? What's the point of duplicating such a big blog article here? I mean, if later someone comes up with suggestions specific to the question, their answer will just be lost because of the sheer size of your post. — Andriy M 4 mins ago
@AndriyM I would consider that plagiarism, it could possibly take away traffic from the original blog post instead of increasing traffic to said blog post by linking to it and just posting some excerpts
@AndriyM I'm not sure if that answer/artcile is even helpful. CentOS is based on Redhat. Ubuntu on Debian. Differ in certain points, especially regarding installations
 
2 hours later…
09:40
0
Q: How can I stop Oracle Shutdown command?

user95381I used Shutdown normal, instead of Shutdown immediate. Now I want to stop the process, because its taking too long. How can I do it?

^^^Too localazed
@AndriyM I want to stop the process that is stopping the shutdown process because it's taking too long to stop the stopping. I want the shutdown to proceed ...
@ypercubeᵀᴹ Now that might be harder to find a ready solution for.
@ypercubeᵀᴹ A follow-up Workplace question from a colleague: "How can I slap the hand that typed 'shutdown normal' too soon and then 'shutdown abort' even sooner?"
@AndriyM slap the hand that gave them shutdown privileges ;)
 
2 hours later…
12:11
Because the 2nd index has all the ID values ordered. The 1st index has the ID values, ordered by status first, so the ID values are not ordered (actually there are up to 19 (for the values 1 to 19) sub-ordered groups but I don't think the optimizer knows or uses that.) I think the optimizer considers that the join will be more efficient if the indexes from both tables are ordered the same way. — ypercubeᵀᴹ 2 hours ago
carefully stepping into Paul land territory ...
 
2 hours later…
13:45
@ypercubeᵀᴹ I added an answer.
 
1 hour later…
14:54
@ypercubeᵀᴹ Ugh. Did you really just edit my answer to put code tags around non-code?
I'm not going to roll it back, but I dislike that formatting habit.
Especially when people go nuts with it.
Sorry. The paragraph seems a bit less readable to me, without the code format.
@PaulWhite I must admit that I prefer to put code tags like that too
No doubt it's a style thing, and the monospace side effect is arguable. It just makes my brain work too hard when people do it to excess. And to me, it looks ugly.
Done to excess I mean.
My personal preference is code tags for code. I use italic for column and table names, most often.
I guess an in-line index reference is a borderline case, and acceptable enough to me not to undo it.
@ypercubeᵀᴹ In this case you're probably right and it does look better :)
So I retract my "ugh".
@PaulWhite Everyone is happy. Plus a parenthesis was fixed ;)
@PaulWhite My intention first was to edit only the 2 index defs. I carried away editing the columns, too.
I agree that when a paragraph has a lot of column references, the excessive mixing of normal with code format is annoying.
15:12
@ypercubeᵀᴹ Oh was it? My typing has become decidedly sucky recently, so thanks for that.
must've been taco tuesday last night. some guy in the men's locker room provided no fewer than 7 courtesy flushes
It was (Status, Include(ID)), I changed it to (Status) Include(ID). Not sure if it was intended or not.
@ypercubeᵀᴹ Your edit was correct, but I did have the right number of opens & closes.
15:43
@PaulWhite In my opinion, the problem with in-line code excerpts is the darkness of the background, more than the monospaced font. Said darkness makes the excerpts look too invasive, so to speak. When used in a normal document created with a word processor, the monospaced font looks much better without such a background (in my opinion, of course).
I believe it would look better without the grey background. The background is what mostly makes inline code formatting ugly for me.
2
@MDCCL Yes I agree with that.
@MDCCL I can't believe that
We were both writing about the same thing at the same time.
@AndriyM Almost at he same time, a matter of seconds, ha ha.
Clearly you are sockpuppets.
15:46
But then who's the puppet master
Good question!
Why do people find it so hard to ask about the problem they need to solve, rather than something tangential about the way they are currently doing it?
embarrassed
A simple answer might be to use OR and order by the type of match found.
@PaulWhite It's the way people think. Talk about requirements for anything and people will always express their requirements in terms of inputs into their incumbent process, rather than what they are trying to achieve.
@ConcernedOfTunbridgeWells Yeah I guess. Still it's a human trait that sucks on a Q & A site.
15:59
@PaulWhite It's a trait that sucks when you're trying to do analysis work, too.
I'm sure!
If I asked people what they want, they'd have said faster horses.
- Apocryphally attributed to Henry Ford.
4
Ha! Nice.
@PaulWhite That's just another example that shows that the Monospaced.Font looks much better without the background.
@MDCCL Yes it looks much better in chat, it's true.
I wonder if they'd change it for us.
16:02
does it make sense that compressed reorgs are much faster than noncompressed reorgs?
@PaulWhite Is there a means to request such a thing?
There is a meta to request such things.
Who knows if it would be well received by everyone. Perhaps we're too bothered about these details.
We'll never know what everyone thinks if we don't ask.
We'll never ask if we keep being afraid of what people might think.
16:09
@PaulWhite Let's see if the Andriy comment gets upvoted, depending on that it might progress to a meta request.
I might ask it anyway, just to see what people think.
@PaulWhite you are a brave soul
@Lamak Local meta. I'm not that stupid.
@PaulWhite If you ask it, it might reach a broader audience.
ah, well, you are a lesser brave soul
16:30
@PaulWhite So I can go crazy with the back-ticking again (feeling hopeful)
@Shaneis Yep!
0
Q: Should we change the formatting of backtick markdown elements?

Paul WhiteAt the moment, backtick markdown elements are rendered with a grey background. This can get a little jarring when used frequently, for example: I have a table Widgets with columns, WidgetID, Name, Quantity, Frequency, BananaType, and UnitCost. I want to SUM the Quantity for each Name and produce...

2
@PaulWhite Oh I wish I could up-vote that response...oh wait I can!
Huh. By asking and answering my own meta question, I don't get a vote.
@PaulWhite You got my upvotes already.
I do get to accept an answer eventually ha ha.
16:46
3
Q: Should we change the formatting of backtick markdown elements?

Paul WhiteAt the moment, backtick markdown elements are rendered with a grey background. This can get a little jarring when used frequently, for example: I have a table Widgets with columns, WidgetID, Name, Quantity, Frequency, BananaType, and UnitCost. I want to SUM the Quantity for each Name and produce...

too slow Master Database
@ypercubeᵀᴹ You messed up my nice tidy yes/no arrangement ;) Hey so when you say "white" do you mean "transparent'?
I think I'd prefer it if that were a comment or edit to the yes option.
@PaulWhite i'm a noob in html, that's the point ;)
@ypercubeᵀᴹ Well me too, but my site background is white just not sure if it is for everyone.
You could edit the Yes. I can delete my answer. And you lose the voting option ;)
16:48
I'll have a go.
Let's see how it works as a comment first.
@ypercubeᵀᴹ OTOH what's a code-only paragraph? Not proposing any change to code blocks.
@ypercubeᵀᴹ Clarified the question.
@PaulWhite Yeah, I meant code only blocks
Ah OK. Gosh writing meta questions is hard.
Please downvote my answer. It's at -1. I want a Peer Pressure badge ;)
4
17:06
Pressing us into pressing you to delete your answer – that's... so meta.
@ypercubeᵀᴹ your wish is my command, Sahib
thank you, sir
Thanks @MDCCL
@PaulWhite Added a code block sample to your question.
@PaulWhite My pleasure
AK_ prefix for unique constraints?
17:17
@MDCCL it'd be great if we could specify the color of the code block background. I'd like to use chartreuse for some edits, lol.
@MDCCL I am preemptively answering chat messages today.
@AndriyM I've seen that, on things that are alternate keys in the logical model. I use UQ_ for unique indexes/constraints.
"Alternate Key", makes sense.
@PaulWhite watch out for those context switches
@swasheck Not an issue with a fast enough cpu :)
touche (too busy to google the accent)
17:24
touchè
touchy
touché, says Google
@swasheck Alt+0233
danke
@AndriyM Yes, AK_ stands for ALTERNATE KEY.
danké
17:26
dank
@MaxVernon That'd be quite elegant ;).
anyway ... there really needs to be a sarcasm.stackexchange where questions are answered with snark and vinegar. it should be the default migration location for dba.se ... @bluefeet can we make this happen soon?
17:47
0
Q: Why do I want follow different communities in StackExchange

Marin MohanadasFor my curiosity, I found StackExchange Database Administrators has groups or communities such as Database Administrators and Database Administrators Meta. What is the difference between both communities? Even my reputation and number of badges are different in both communities. Do I want to fo...

So chatty today, M.D.
kind of you to answer it
18:04
@PaulWhite are you convinced it should be one or the other?
0
A: Should we change the formatting of backtick markdown elements?

Jack DouglasIt is jarring, but taking the background colour away entirely leaves it hard to tell what is code and what isn't: I think we should consider a third option, ether a lighter grey: Or something else: Just for reference, this is what we currently have:

hey, jack is back
maybe it is down to my low-res screen but I find it pretty hard to tell the difference
Hello @Lamak :)
I come back when @Paul leaves a few flags for me ;)
aaw, I don't feel special anymore
@JackDouglas Pretty much. I also wanted to start out with binary options to keep the focus as much as is possible on meta. 100 different answers with 100 different shades of grey was one of the things I was hoping to avoid. A comment on the 'yes' or 'no' suggesting a refinement (lighter background) could be upvoted.
But I'm happy to let the thing develop on its own. That's kinda the point of asking what people think.
@JackDouglas Quality over quantity, Jack :)
do any other sites have something better we can compare?
@PaulWhite ha
practice makes perfect
18:09
@JackDouglas I don't think so, but I didn't check every single one. I still think it's likely the designers would ignore it anyway, but if you don't ask you don't get.
Also, genuinely interested to hear what people think.
I did check with a CM first that the request was not 100% pointless.
@JackDouglas Difference between? Existing dark grey and no/transparent background? Is very clear here.
@PaulWhite yeah, just blame me :P
@bluefeet a CM :)
@PaulWhite difference between monospace and regular
in chat, and in the example I posted of what it would look like on main
@Lamak you are special
@JackDouglas Oh right. Yeah, nah it's enough of a distinction here. And my eyes are older than yours.
how many words in this sentence are monospace and how many use a regular font?
I'd prefer them to tweak the css in here instead!
18:20
@JackDouglas Why should I care? By which I mean: is the distinction important?
But "three".
@PaulWhite if the distinction isn't important then don't use backticks!
@JackDouglas It's more distinct on my screen than in your image. (Works on my computer!)
it's impossible to tell on my screen — the image is a screenshot
maybe I need a new laptop :)
@JackDouglas Adjusting font settings might be cheaper :)
or maybe it's a quirk of Firefox on OSX, dunno
18:24
@JackDouglas thanks man
@AndriyM it's big on my screen, just low res
@JackDouglas No, I mean perhaps reducing the standard/default size for monospace slightly
I have a table Widgets with columns, WidgetID, Name, Quantity, Frequency, BananaType, and UnitCost. I want to SUM the Quantity for each Name and produce a 3-week rolling AVG with a PARTITION BY Name ordered by BananaType DESC and WidgetID ASC. The problem is...
you're making widgets from bananas
@JackDouglas Does that not look distinctive enough on your screen? Insofar as the distinction is important for comprehension or readability anyway.
18:27
I think I'll not vote on this one, if the formatting isn't overdone I think the existing solution is fine and the new one would be less distinctive, if the formatting is overdone it's the other way around, just my 2c (and paul asked not to vote twice in the question)
@swasheck Would you like to place an order?
on my windows 10 the monospace is clearer than on my fedora, the grey thing is clear anywhere although easily overdone
so "it depends"
Always.
@JackDouglas My font settings, for reference (Firefox on Windows):
Anyway, my concern is that I actively avoid backticks because the formatting is so ugly when it occurs more than a token amount.
18:30
I haven't changed them, just posting in case they are different on OSX
If they were less jarring (to me), I would likely use them more, with whatever small benefit that might provide.
@PaulWhite I find myself not backticking field names and the likes too in fear of making the post look like a painting, so you have a point
I sometimes start off with the odd backtick, then it gets out of control, and I end up going back and reformating some other way (usually italic). It would be nice not to have to worry about that any more.
It's just that a post with one or two inline code blocks the code formatting might be easily glossed over on some setups
which is not really a problem either because a reader of the post who knows what it's about should easily recognize dbcc checkdb is code without formatting
anyway, just my 2 cts, it's not something I feel strongly about
@TomV Well I'd argue that if it is that important it should be in a code block... :)
18:39
@PaulWhite I'd agree with that argument :)
It's the only way to stop me posting.
You were only 2 arguments away from convincing me to vote :)
@TomV Vote early. Vote often.
The question has a vote, I'm undecided on the answers
and since it's a ballot, not a regular answer upvote I vote blank
hmm, blank seems to have a protest connotation in English, it doesn't in Dutch
Not voting is a valid option as well.
Part of me is just curious to see if they would even consider such a UX change for one site.
18:51
not voting is a vote against the establishment
@swasheck Not in Belgium, we have a legal obligation to turn op on voting day, so you're there anyway
and there is a calculation method where not voting differs from invalid voting
So he who wants to protest writes profanity on the election ticket :)
I VOTE FOR FRAU SAU!!!!!!!
Anyone worked with IBM Bluemix or SAP VORA? Just looking for a chat about your experiences. TIA
 
1 hour later…
20:09
@PaulWhite only because of the CAPS and TitleCase, not the monospace
Ok.
13 vs 2 for change so far.
@AndriyM doesn't seem to make any difference — maybe that's just a default and overridden by the css

« first day (1968 days earlier)      last day (3199 days later) »