« first day (3258 days earlier)      last day (1593 days later) » 

5:39 AM
I would like to present a special award to the person that upvoted:
0
Q: SQL Server: Use Implicit or Explicit Cursor?

davidSELECT Table_Name FROM INFORMATION_SCHEMA.TABLES WHILE (1=1) BEGIN EXEC 'drop view ' + Table_Name END or DECLARE my_cursor CURSOR FOR SELECT Table_Name FROM INFORMATION_SCHEMA.TABLES OPEN my_cursor WHILE 1 = 1 BEGIN FETCH my_cursor INTO @vname IF @@fetch_status != 0 BREAK EXEC('drop vi...

 
 
1 hour later…
6:47 AM
@PaulWhitesaysGoFundMonica Just tested, it only happens when I down-vote, I can up-vote and it is displayed publicly
 
@TomV-TeamMonica Ah yes of course.
 
It doesn't seem to be new behaviour (although that post says 125)
56
Q: What does it mean when it says my vote is "recorded" but "does not change the publicly displayed posted score"?

P.V.I have less than 125 reputation, and when I upvote and then downvote the same post, this message pops up: Thanks for the feedback! Votes cast by those with less than 125 reputation are recorded, but do not change the publicly displayed posted score. What does it mean when it says my votes ...

 
 
1 hour later…
8:06 AM
@PaulWhitesaysGoFundMonica popped it in the queue.
 
8:59 AM
@TomV-TeamMonica vote down is 100 on main meta meta.stackexchange.com/help/privileges
47
A: Change rep required to downvote on MSE

Shog9As of right now, this is done: the "vote down" privilege is awarded at 100 reputation here on Meta Stack Exchange. This should allow folks with the association bonus - or those who earn 100 reputation by participation here - to downvote questions as much as they wish (particularly important for...

 
 
1 hour later…
10:24 AM
The Unbearable Lightness of the Upvote
 
 
1 hour later…
11:32 AM
morning
Does anyone know where I can find the collation rules of utf8mb4_unicode_ci ?
 
11:44 AM
@JohnEisbrener You should leave answers in comments on the 32nd day of the month. — Paul White says GoFundMonica ♦ 6 hours ago
It seems the 32nd day of the month is the most appropiate for many things
 
@AndyK nah
 
@Johnakahot2use cheers
 
12:11 PM
@Johnakahot2use ty
 
12:47 PM
@Johnakahot2use pro-level lmgtfy ;p
you don't get to 10k rep by sleeping on the official docs
 
1:02 PM
if i were having annoying issues with the psqlodbc driver, what network would i home that on? i feel like SO proper but asking a question there always feels like asking strangers to kick you in the crotch
 
@PeterVandivier what problem do you have?
 
everything is text
which is what i was trying to avoid by using the driver in the first place
 
@AndriyM would it still be called an ERD if it contains zero tables/entities?
 
@ypercubeᵀᴹ I hope John knows the right answer. My own understanding is, it's not called an Entity-Relationship Diagram if it doesn't contain an entity or a relationship.
Or a diagram
 
@PeterVandivier Your question would be closed with a friendly blue colour though.
2
 
1:12 PM
well that's okay then i guess
 
1:24 PM
@PeterVandivier You have to start somewhere.
 
RIP Too broad and Unclear what you're asking
 
ah... is that the "needs more focus" thing?
i've been flag-banned 🥺
was reviewing my history & saw that i apparently flagged something as "needs more focus" - got suuuper confused for a sec
 
  +----------------+
  | ID (int)       | -|----+
  | NAME (varchar) |       |
  | FIRST (varhar) |       |
  | BOSS (int)     | -|-0--+
  +----------------+
ERD in one table
 
> This post is hidden. It was deleted 2 hours ago by Paul White says GoFundMonica♦.
What is it, hidden or deleted?
 
why-not-both.gif
 
1:33 PM
hidden b/c deleted
 
☝️
what else gets hidden other than deleted stuff?
migrations i guess?
do any close types hide a post?
aw... i appreciated that meme
 
🎉it's back!! 🎉
 
In a onebox even
 
1:36 PM
@PeterVandivier hidden sounds more welcoming according to focus groups
@PeterVandivier no, well except a closed question might be later auto-deleted er I mean auto-hidden
 
"sent to nice forum upstate"
where it can play outside with other OPs
 
@PeterVandivier lol, its the worlds largest game of rochambeau
 
oof
@ypercubeᵀᴹ sorry, didn't realize the filename was breaking the link, fixed now floobits.com/PoshCode/PowerShell.Slack.com/file/petervandivier/…
 
1:53 PM
too long-winded, or perhaps wrong?
 
@MaxVernon i might've added the setup to the OP in an edit to improve the readability of the question-answer pair
 
2:14 PM
@AndriyM an empty table isn't a table any more? ;)
 
@PeterVandivier yah, I used to do that quite often. In this case, I didn't really want to suggest an [mcve] to the OP that wasn't what they had in mind. I think mine is fine, but I'm doubtful if it's precisely what they want. I should probably have just left it alone when I saw it in the vote-to-close queue 😜
doubtless they've already moved on to other things by now
 
undoutedly
my feelings on the etiquette there are that you're fine to make the edit since they should get a notification anyway - although an "@OP - FYI ..." comment is polite
then they can rollback the edit if they like and are still engaged
also - editting the OP in that way demonstrates what they should have done in the first place
win-win
 
except for the poor schmuck that has to clean up your transient comment mess that somehow always ends up being permanent
 
2:29 PM
somehow i think politeness to a newcomer is worth that price, despite it's oppressive externalisation
 
Well it comes at no cost to you so of course you do
Why rely on the automatic notification when you can chat the place up?
Ping them on twitter too, just to be extra sure and polite!
 
sarcasm detected
 
it's upside-down sarcasm so it's actually instructive & friendly
 
comments should auto-die
 
2:33 PM
I love comments on the new site
Can't get enough of them
If only SE had implemented them that way
 
because it's chat, not comments
 
But chat is dead to them
@MaxVernon Right
But I don't care so much about that. I care about comments getting in the way of the Q & A
People can chat all they like so long as I don't have to trawl through it just to get to the answer
 
if only there was a way to DELETE FROM dbo.Comments WHERE site = 'dba.se';
 
Taryn keeps promising me a truncate table
 
@PaulWhitesaysGoFundMonica so true
 
2:35 PM
heavy lies the hand that deletes the comments
 
hah. more like relieved.
 
2:54 PM
@MaxVernon You still around?
Guess not
I voted to reopen this question since it seems to have value to future visitors, and has a good answer. — Max Vernon 23 hours ago
That seems like an argument to not delete a question, rather than reopen
Reopening allows *new answers*
Shame the OP's account is deleted
I suppose it also suggests we'd like more questions like that
I look forward to the follow questions: What are the advantages and disadvantages of <product x> for a database?
 
3:10 PM
@PaulWhitesaysGoFundMonica I am now.
@PaulWhitesaysGoFundMonica I retracted that comment, but not the re-open vote. I don't see why it should be closed since it's a good enough question. In future, someone might want to add an answer, but as it stands they cannot.
 
Well I have a great example to point to next time you VtC a database-recommendation question anyway
 
@PaulWhitesaysGoFundMonica overall I tend to agree that [database-recommendation] questions tend to be [opinion-based], and probably don't have a large amount of value.
@PaulWhitesaysGoFundMonica dammit
🔥👀
wonders off to find questions to close
 
We'll just reopen them because someone might want to add an answer in future.
 
oh the sarcasm is strong in this one today
isn't it spring in NZ? Isn't that supposed to make you full of joy?!
 
It has been summer for six days
The amount of crap on the front page and in the review queues is disheartening.
 
3:17 PM
equinoxes appear to operate differently in the southern hemisphere
 
There are several definitions for seasons.
The most widely used here is 1 December for summer.
 
ahhh
 
Summer is the hottest of the four temperate seasons, falling after spring and before autumn. At the summer solstice, the days are longest and the nights are shortest, with day length decreasing as the season progresses after the solstice. The date of the beginning of summer varies according to climate, tradition, and culture. When it is summer in the Northern Hemisphere, it is winter in the Southern Hemisphere, and vice versa. == Summer timing == From an astronomical view, the equinoxes and solstices would be the middle of the respective seasons, but sometimes astronomical summer is defined as...
 
here's a classic comment for you:
Adding the result: — Jamie 8 mins ago
phew. I'm so glad they let me know.
 
Voted to reopen it
 
3:21 PM
> School summer holidays in Australia, New Zealand and South Africa begin in early December and end in early February
filed under "things I never realized, but are patently obvious once you find out"
so, I concur, it is summer.
Are the kids out of school yet?
 
Not yet. At least not in my town.
Can't be far away.
 
assuming you have no children, it doesn't make much of a difference aside from all the little buggers running around getting in the way.
 
The primary benefit is less traffic around schools in the morning and mid-afternoon
Not that the kids see it that way
 
We have 30 km/hr speed limits here around school zones from September to June (when school is "in" here). When school is out, you don't have to drop your speed in those zones, which is certainly nice. Those tickets can be expensive.
 
3:48 PM
@MaxVernon what about south america?
 
@Lamak Excellent point. Do you have an official or common start date for summer?
 
@PaulWhitesaysGoFundMonica oficial summer starts dec 21, I think. School summer holidays early december...as it should be
 
@Lamak what? Official in what sense?
 
@ypercubeᵀᴹ don't know
as in, "is it summer?"
 
3:57 PM
I thought summer = summer months = Jun-Jul-Aug in north and Dec-Jan-Feb in south hemisphere
 
south hemisphere summer
 
@ypercubeᵀᴹ Certainly true here, but USA does it differently I think
 
@ypercubeᵀᴹ summer moths:
 
well played Lamak ;)
 
winter moth:
 
3:59 PM
interruption
 
damn i cant paste the picture
there are some really fuzzy moths out there
 
we sometimes have these during the summer months: news.wttw.com/sites/default/files/styles/full/public/article/…
 
@PeterVandivier ...and reading is learning. Collation Demo Tool
...and the Unicode Browser
 
I see nothing about moths in there, John
 
@MaxVernon Joan?
 
4:11 PM
hah, my mistake
 
That's my name
 
yah, I got it wrong. That's what I get for trying to be smart.
 
The nearest I could get
 
@Johnakahot2use ahhh, very nice!
I'm watching every episode of The Simpsons on Disney+
I'm thinking it might take a while.
 
@MaxVernon so, you are losing some visual jokes
or so I read...
 
4:20 PM
Unicode examples containing MAX
 
@Lamak really? interesting. I hadn't heard about that.
 
@Lamak ahhh. I was wondering what the hell was going on. Of course, it doesn't really hurt me right now because i'm only really listening to it, and half-watching, lol.
 

« first day (3258 days earlier)      last day (1593 days later) »