« first day (4536 days earlier)      last day (324 days later) » 

Zikato
Zikato
6:30 AM
Morning
 
 
1 hour later…
John K. N.
John K. N.
7:48 AM
morning
Wordle 717 6/6*

🟩🟨⬛⬛⬛
🟩⬛🟨🟩⬛
🟩⬛🟩🟩🟩
🟩⬛🟩🟩🟩
🟩⬛🟩🟩🟩
🟩🟩🟩🟩🟩
 
Paul White
Paul White
8:42 AM
Wordle 717 5/6*

⬛⬛⬛⬛⬛
⬛🟨🟩🟨⬛
🟩⬛🟩🟩🟩
🟩⬛🟩🟩🟩
🟩🟩🟩🟩🟩
 
 
1 hour later…
John K. N.
John K. N.
9:51 AM
in Charcoal HQ, 54 mins ago, by VLAZ -on strike-
Oh no, an API error has come to light,
A glitch occurred, causing quite a fright.
The server stumbled upon an unforeseen plight,
Leaving your request in a sorry state, out of sight.

Internal Server Error, it sadly exclaims,
A hiccup in the system, with no one to blame.
The details are scarce, as the logs hold the claim,
To troubleshoot this issue, it's not a simple game.

Please be patient, try again at a later hour,
Or seek support from those with technical power.
The error's origin, like a wilting flower,
190
Q: Dear SE, please stop disparaging the moderators in the press

Mad Scientist - on strikeThe VP of Community for SE gave the following statement to the press: Stack Overflow ran an analysis and the ChatGPT detection tools that moderators were previously using have an alarmingly high rate of false positives. Usage of these tools correlated to a dramatic upswing in suspensions of user...

support status-review moderation
 
 
2 hours later…
Hannah Vernon
Hannah Vernon
11:30 AM
Wordle 717 3/6*

⬛⬛⬛⬛🟩
🟩⬛🟩⬛🟩
🟩🟩🟩🟩🟩
 
 
2 hours later…
Lamak
Lamak
1:15 PM
Wordle 717 4/6

🟩🟨⬜⬜⬜
🟩⬜⬜⬜🟩
🟩⬜🟩⬜🟩
🟩🟩🟩🟩🟩
 
Hannah Vernon
Hannah Vernon
1:29 PM
> 06/06/2023 8:00 AM: 102 moderators covering 74 sites, 15 former moderators and 645 curators - 762 total.
 
Josh Darnell
Josh Darnell
That's approaching the number of signatures from the previous open letter.
During the Monica Incident.
 
Hannah Vernon
Hannah Vernon
I have a feeling this will last quite a lot longer and be a much larger list eventually, but who knows.
I've had the main moderator chat open in a tab since yesterday (last checked it around 16 hours ago), and there has been over 1300 new messages... I thought our transcript was hard to read sometimes.
 
Lamak
Lamak
lots of 5 letter words though, you guys have it too easy
 
Hannah Vernon
Hannah Vernon
hahahah
 
Hannah Vernon
Hannah Vernon
1:52 PM
If I had to venture a guess on how long the strike will last, I'd have to go with 6-8 weeks.
(sorry)
 
Lamak
Lamak
jokes aside, I think it will be far shorter
 
Hannah Vernon
Hannah Vernon
hopefully
then the poor remaining Stack Employees/CMs won't have to do our jobs for us
wait, did I say job? I meant unpaid schlepping.
 
Erik Darling
Erik Darling
2:55 PM
Hey you nominated yourself
 
Lamak
Lamak
did it for clout
 
Sean Gallardy
Sean Gallardy
3:53 PM
chosen for those with ESL
 
Hannah Vernon
Hannah Vernon
4:15 PM
this made it to the HNQ and is #1 ranked network wide:
201
Q: Moderation strike

StrongBadThere is currently a moderation strike on this site Academia.SE Moderation Strike And network wide https://meta.stackexchange.com/questions/389811/moderation-strike-stack-overflow-inc-cannot-consistently-ignore-mistreat-an Normally this type of key information about AC.SE would be posted in meta ...

moderation
 
Paul White
Paul White
🤣
 
mustaccio
mustaccio
4:37 PM
Scientists
Academics, even
 
Hannah Vernon
Hannah Vernon
right!
 
 
2 hours later…
Hannah Vernon
Hannah Vernon
6:35 PM
so amazing that they've removed the Hot Meta Posts section from site's home page.
 
Lamak
Lamak
yup, was reading about it
 
Hannah Vernon
Hannah Vernon
and I was about to post something on our meta about the strike 👀💩🤷‍♀️😐
 
Hannah Vernon
Hannah Vernon
6:49 PM
17
Q: Featured posts are missing across the network

CDROn all sites, the questions featured on Meta are no longer being displayed, even though the tag remains on the two questions. (Seems the same thing is happening with Hot Meta posts, though I and some other users can still see them for whatever reasons.) Both of the questions have been heavily dow...

support status-review featured-tag
 
Paul White
Paul White
7:21 PM
What an amazing coincidence
 
Sean Gallardy
Sean Gallardy
inconceivable
 
Hannah Vernon
Hannah Vernon
7:48 PM
And apparently its back, but I'm on mobile right now
 
Sean Gallardy
Sean Gallardy
8:07 PM
sounds like you have tons of cache
 
Cade Roux
Cade Roux
8:38 PM
Is DROP any more efficient than TRUNCATE for really large tables? I have a 1.5TB table of clickstream data, and I want it purged out of this database, and I just TRUNCATEd another table of data I need to purge and that was 1/10th of this size and it took 90 minutes.
 
Master Database
Master Database
0
Q: Ongoing Moderation Strike

Hannah VernonSince Monday, June 5th, 2023, moderators and content curators (that's you, dear reader) from across the Stack Exchange Network, including the moderation team on this site, have decided to protest recent statements taken by the Stack Overflow corporate team. The protest consists primarily of not r...

discussion featured
 
Hannah Vernon
Hannah Vernon
TL/DR is that drop and truncate are very similar
except with truncate you still have a table at the end
obvs
 
Paul White
Paul White
9:42 PM
For TRUNCATE to be that slow I imagine you're struggling with I/O to get metadata pages in for modification. I suppose DROP could conceivably be a bit faster though probably not much? Not aware of any real testing in this area.
If the table is suitable for SWITCH you might find it better to switch the data out then drop the target whenever that's convenient
Depends on your priorities of course
Turning off deferred drop might also help a bit
 
Cade Roux
Cade Roux
Is there any benefit of SWITCH over sp_rename for a non-partitioned table? The database doesn't have anything but primary filegroup. It's meant to send this data to us every night, so it's only supposed to be a store and forward for a night's worth of data, or a week's on small sites, but due to some customer site issues, it hasn't delivered data for several weeks. I was hoping to reclaim the space fairly quickly and shrink the database before resuming nightly operations.
I guess, given the non-instantaneous nature of the TRUNCATE that it's probably related to the XML data columns holding the application data stream.
 
Hannah Vernon
Hannah Vernon
@PaulWhite pretty certain I've never heard of that. How does that work? A trace flag?
 
Paul White
Paul White
@HannahVernon Yes 671
@CadeRoux Only that you don't need to recreate the table
@CadeRoux Yeah heaps of off row LOB data would do it
Log might be a bottleneck too
Good luck with the shrink
Big data was a mistake
 
Cade Roux
Cade Roux
10:15 PM
Indeed
The data is tremendously valuable about 4 weeks either side of a change in customer workflow design. Outside that, it really is a waste.
 
Hannah Vernon
Hannah Vernon
-12
Q: AI Generated Answers Counter Petition

Sims Studios LLCThis is completely ridiculous. AI is not going to make StackOverflow useless, it's going to enhance it by giving yet another tool answers can potentially come from. AI Doesn't always give the correct answer, it also doesn't always factor in everything it needs to factor. How could having all this...

discussion site-recommendation community-user robots
Someone wants to be downvoted into oblivion, apparently.
 
Cade Roux
Cade Roux
10:31 PM
ChatGPT, how big is the largest negative number allowed on Stack Overflow?
 

« first day (4536 days earlier)      last day (324 days later) »