« first day (4535 days earlier)      last day (325 days later) » 

12:00 AM
@PaulWhite mistakes were a mistake
 
12:13 AM
Wordle 715 1/6

🟩🟩🟩🟩🟩
Cheers.
 
That’s a six letter word sir
 
12:38 AM
Cheer? Is that better?
 
12:51 AM
That’s definitely fewer letters
The grammar kinda falls off though
 
1:18 AM
Four is the only number with the same number of letters.
 
 
5 hours later…
6:37 AM
Morning
 
 
1 hour later…
7:38 AM
Wordle 716 3/6*

⬛⬛🟨⬛⬛
🟨🟩⬛🟨⬛
🟩🟩🟩🟩🟩
 
Morning
 
 
2 hours later…
9:19 AM
174
Q: Moderation strike: Stack Overflow, Inc. cannot consistently ignore, mistreat, and malign its volunteers

Mithical Introduction As of today, June 5th, 2023, a large number of moderators, curators, contributors, and users from around Stack Overflow and the Stack Exchange network are initiating a general moderation strike. This strike is in protest of recent and upcoming changes to policy and the platform that...

4
 
🍿
 
 
3 hours later…
12:17 PM
> The knowledge sharing of the Community is the platform's foundation. To ensure the highest quality repository of information, we have adopted quality standards that apply to all answers on our network. Read more on how to write a good answer.
No room for AI there....
 
1:07 PM
@Charlieface i'm surprised you didn't chastise that op a bit for leaving where conditions out of the exists subqiery
 
1:20 PM
Looks like an AI answer tbh
 
Wordle 716 5/6*

⬛⬛🟨⬛⬛
⬛🟨⬛⬛⬛
⬛⬛🟨🟨⬛
⬛🟨🟩⬛🟨
🟩🟩🟩🟩🟩
 
does a bit, yes
 
Wonder if policy will change to allow AI comments next ;)
 
We definitely need more good comments
Otherwise world consumption of popcorn will falter
Maybe it's all a ruse by Paul because he's shorted popcorn stocks
 
1:37 PM
@ErikDarling Wasn't concentrating on it, could just see it was joined too many times. Doesn't matter though because that's doubly nested in the except where the junction table is already being queried
 
@SeanGallardy makes total sense why he's always deleting my comments :)
 
@Charlieface i saw it before i fell asleep last night and had a dream about writing an answer, which makes me seriously question my mental health tbh
 
I believe there is a special place in hell for people who make protocols which require forward and backward knowledge guesswork to properly operate
 
@ErikDarling On a serious note, can I suggest taking a break from Stack Exchange completely for a month? I did that and it did me good, might do it again soon. Otherwise just get obsessed.
@SeanGallardy In reference to which protocol
 
@Charlieface HADR
I rarely have to go to the protocol level for stuff, but when I do I am reminded just how much I dislike it
 
1:44 PM
High availability solutions are always hard
 
Also.. uh... don't install CU20 if you're using AGs and Hekaton
or install it on ALL replicas at the same time
 
How about: don't use AGs or Hekaton
5
 
That's just crazy talk
 
Sacrilege!
 
^ This guy gets it
 
1:47 PM
Hekaton got so many other memory leak and crash duming issues I wouldn't touch it anyway
 
There are some issues for sure, but I would say the main parts of it works very well without any major issues
 
Same for AGs. Nice idea, poor implementation. Sorry, I know you work for them, no empathy though.
 
AGs downfall is bad infrastructure
They weren't made to go over your MPLS line to Japan
There's definitely things which could be done better for AGs as well, I agree
 
Hah more like a 3G backup dongle
 
I hear SO have very fast networking and zero AG problems over the years
 
1:49 PM
Always with your ear to the ground!
 
@PaulWhite I know some good ear specialists
 
Heaps of misinformation out there
 
> I hear SO have very fast networking and zero G problems over the years
 
What is it if AI generates it and then trains other AI on it?
 
FTFY. They're in freefall now
 
1:50 PM
Also I love how, ahem, broad the "AI" meaning is these days
 
@Charlieface eh, i like chat. it's good for me because i work alone and feel somewhat isolated at times.
 
@ErikDarling Have another kid! You'll never be alone.
 
Luckily, the misinformation problem has been recently solved dba.stackexchange.com/conduct/misleading-information
 
@SeanGallardy takes too long for them to be able to talk about anything useful
 
Their AI takes years to train, true
 
1:54 PM
@PaulWhite Wow. I had not come across that page yet.
 
what brand of devilry is this
Or use the Dedicated Admin Connection and maybe single-user mode to hack the system tables. — NedOtter 2 hours ago
commenting on your own answer instead of editing it
 
lol
I feel like Ned's defense of Hekaton on this site is always "maybe try this" and "this might work I'm not sure."
 
he is the leading expert
apparently he's vice president of databases at his job
 
Wordle 716 3/6

⬜⬜⬜🟨🟨
⬜🟩⬜🟨⬜
🟩🟩🟩🟩🟩
 
How can I hack the system stables? — dcop7 1 min ago
those poor horses.
 
1:58 PM
@ErikDarling What about the next comment
How can I hack the system stables? — dcop7 3 mins ago
Always wanted some system stables, to keep my system horses in.
 
@ErikDarling I had to reply
@Charlieface Look who is too good to use system hamsters
 
Aggh you replied same time I did
 
@SeanGallardy you may want to give that a proof read quickly, because the edit window expires. a couple types.
 
@ErikDarling yeah I suck at the typing
@Charlieface The more people the better
 
Seems like a problem easily solved by giving Azure more money
 
2:02 PM
apparently money can't buy removing hekaton filegroups
 
Well. Enough money would.
 
Let's hedge some of that popcorn short money you have
 
But I meant spending enough money so Hekaton was supported on the target.
You don't have to use it, just pay for it.
 
here's what i'd do
 
2:03 PM
MI support hekaton AFAIK
 
migrate into a mi tier that supports hekaton
and then demand microsoft support fix it so they can use a different tier
 
Demand
 
sev aaa
 
Crikey
 
sev aardvark
 
2:04 PM
clearly deserving of a sev-1
 
Main turning into chat
 
It's a clever move to write the dumb, dangerous part of your answer as a comment so it can't be downvoted.
 
@dcop7 you don't have any good choices, which is the basic point here. You're kinda screwed unless you a) don't use MI, or b) use a tier of MI that supports IMOLTP. — Erik Darling 3 mins ago
 
business justification: We'd like to not give MS more money by needing a higher MI tier
 
Can only lead to tiers
 
2:06 PM
> (whether initially or not)
intentionally?
 
Is there any reason to actually turn Hekaton on in the main DB and not in its own DB?
 
Aren't cross-database queries a challenge?
 
i forget if cross database stuff is supported for all the doodads with it
 
Especially if you're only using DURABILITY=SCHEMAONLY
 
It's really hard to care about Hekaton
 
2:08 PM
@PaulWhite yeah not supported with HK
 
In memory TVPs looked interesting though. I wish there was a FROM OPENROWSET(@myTVP operator so you could just stream the thing straight in. Would probably need a complete rewrite of TDS to allow concurrent streaming of multiple TVPs and the resultset.
 
2:36 PM
just an FYI, I signed the Letter
 
@HannahVernon Yeah, I've been thinking about it too
 
I can no longer just sit by idly when I see misjudgment on a grand scale.
 
@HannahVernon more importantly, I signed it too
 
it doesn't seem to really affect us on DBA.se too much, in my opinion primarily because @PaulWhite does such an incredible job of managing content here.
@Lamak yay! I saw your name on the list over the weekend.
 
I didn't think much of the CEO's response in devclass.com/2023/06/05/…
 
2:40 PM
yah, that's what pushed me over the edge
 
> In a statement sent to Dev Class, Stack Overflow’s CEO Prashanth Chandrasekar told us:

“A small number of moderators (11%) across the Stack Overflow network have stopped engaging in several activities, including moderating content. The primary reason for this action is dissatisfaction with our position on detection tools regarding AI-generated content.

“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 users with litt
 
he's clearly misinformed or an idiot, and I would lean towards the first since I don't know him personally.
2
 
Oh I see Shog9 signed too
Well then
 
yah, a bunch of ex mods have signed, and while it looks like the "11%" quoted in that article isn't that much, it's actually about 50% of SO mods, and most of the others are not active apparently.
> it looks like SE is following their usual strategy of doubling down when wrong
2
 
I cannot believe the CEO really thinks this is about using detection tools 🙄
 
2:44 PM
lol, as I said, misinformed or stupid
 
@JoshDarnell That's one of my main premises on why people prefer commenting instead of posting answers, in general, lol.
 
@HannahVernon you seem to think those are mutually exclusive, on the contrary they usually coincide. Sometimes one causes the other, sometimes the other way round
 
hahahaha touché
 
@PaulWhite putting Azure SQL Managed Instances aside, how would one normally best handle this situation if they were remaining in their same SQL Server instance?...presumably they can't just restore a backup after they drop the database? Would they need to use a hacky alternative to recreate their database schema and import the data?
 
@J.D. Create a new database and copy everything you want to keep across
 
2:49 PM
Yea so a hacky solution eh? Doesn't sound like fun lol.
 
Not really hacky. Scripting and export/import is standard.
 
Yea but the process is kind of hacky, IMO, especially if you have a larger database either in number of objects or raw data size.
But I get'ya.
 
Tedious, yes.
 
Perhaps error prone too.
 
As everyone knows, SQL Server still hasn't implemented its top voted Feedback to be able to restore only some tables of a database.
 
2:52 PM
There was a time when MS were so keen to sell MI they'd bump you up to the tier needed while you pay the lower price.
 
@PaulWhite ah, so one solution for OP is to build a time machine. Not sure that's any worse than what's been provided so far.
 
I don't know if that's still the case or not.
I care less about MI than I do Hekaton
 
@Charlieface and it seems like it wouldn't even be that difficult to do.
 
that used to be in there in sql server 2000, right
question mark
 
I don't think so
 
2:54 PM
Don't one of the other modern RDBMS offer that feature natively?
 
You might be thinking of DBCC PINTABLE
 
@PaulWhite heh, hekaton before hekaton.
 
@PaulWhite That's the only excuse they have. They can't openly say they only care about the number of new users, no matter the quality
 
Sort of. People always misunderstood PINTABLE.
@mustaccio They don't seem capable of 'openly saying' much atm. I can't fully work out what their position is.
 
> dramatic upswing in suspensions of users with little or no prior content contributions; people with original questions and answers were summarily suspended from participating on the platform. These unnecessary suspensions and their outsize impact on new users run counter to our mission
they clearly care about attracting people with no prior content contribution -- it's their mission
 
3:00 PM
🤷‍♂️
 
what a time to be a new user
 
3:15 PM
@HannahVernon Given pg-restore has had this since forever, and MS' new penchant for "whatever they are doing" we might get it soon. Hopefully it will allow a restore over an existing database, which would neatly solve this problem.
 
Go Ukraine style: reveal the true villain via social media, and let the world nuke that villain. I prefer to see SE shut down in disgrace than watch it being rotten to the core like now. — Shadow Wizard Strikes Back 19 mins ago
That comment is 😬
 
@mustaccio It's the usual issue of misaligned incentives. The CEOs have an incentive to increase the market value of the company in order to get bonuses, the market value increases proportionate to new users because of the way market share and board level reports, means the current situation is entirely forseeable. The CEO is not wrong by the mandate they are given, this is a problem of the stock market's making.
 
@JoshDarnell ouch
 
Is that the cringe emoji?
Signed the letter btw
 
3:30 PM
@PaulWhite That is what I meant by it, yeah.
 
Very good
 
I flagged it. Honestly, talking about nuking real people in a real situation, and relating that to this stupid website is absolutely insane.
 
agreed
 
It would need four flags I think
 
@PaulWhite sweet, does that mean you're on moderation strike now too?...should I go get my comment fix in. :)
 
3:32 PM
@J.D. Yep, go nuts
 
@JoshDarnell agreed as well.
@PaulWhite kinda takes all the fun out of it, with your permission now, lol.
 
@JoshDarnell it appears to be gone
 
@HannahVernon \o/
 
Who needs mods anyway
 
Not SE apparently
 
3:35 PM
🤣
 
 
It's all such a stupid and unnecessary distraction. SO have a real problem on their hands with AI eating their lunch. They don't need to be alienating their free workers.
3
 
3:42 PM
hahahah
 
stole it from meta
 
4:16 PM
@HannahVernon I think I'm pretty close to figuring this out
@PaulWhite then the AI will give them an answer that they didn't eat their lunch :D
 
4:29 PM
@SeanGallardy awesome!
does it look like something more interesting or less interesting 😁
 
4:46 PM
what is getting figured out
> free to contact Jan at Jan@all-in-line.com
 
just a prediction but no one but an SE employee is going to touch that
 
5:07 PM
Just added a possible solution in the OP. Can you check it out? — dcop7 2 hours ago
 
@ErikDarling Lol answers everywhere on that Post except in the answers themselves, really.
Aptly timed I suppose.
 
5:24 PM
@HannahVernon 100% a bug
Grabbed some XE's and here's what it seems to be is a lack of logic for out of order processing on filestream with multiple circuits being used.
Short explanation: FS works in AGs differently. FS data needs to be sent before the log blocks, which is fine when you have a single tcp connection, all is done in order. SQL 2016 allowed out of order processing for distributed AGs but only for log blocks, not for FS data. Adding a second connection now allows for log blocks to be sent on a different connection which could potentially arrive before the filestream data has all been written.
That in of itself doesn't cause a problem
 
@J.D. good times all around
 
The problem is only when there is a local secondary on the forwarder side because a forwarder is a primary replica
Which is why the scenario seems to be hit
 
5:58 PM
@SeanGallardy thanks for the explanation!
 
6:44 PM
0
Q: How should I handle index maintenance on partitioned tables in Azure SQL DB?

Grasbalet's start saying that i have no experience with partitioned tables and i'm not quite sure how to handle index maintenance (Rebuild / Reorganize). Consider my scenario: we have 3 tables partitioned by year-month on the same PRIMARY filegroup, as Azure forces you to do, containing historical data...

Trifecta of things we don't like.
 
7:01 PM
😫
 
7:31 PM
in Charcoal HQ, 10 mins ago, by Slate
Hi folks. We have temporarily lowered the number of spam flags required to remove posts from the network from 6 to 4, except on The Workplace and English Language & Usage which remain at 3 due to previous overrides. Please factor this into operations as needed, and let me know if you need further information.
Wait, spam is suddenly a problem for the network? Say it ain't so.
2
 
7:46 PM
SpAIm
 
> Thanks for finding the optimal configuration for those deck chairs on the Titanic. :-)
Charcoal HQ is on fire
 
8:15 PM
That conversation is hilarious
@SeanGallardy What the hell are you talking about
3 hours ago, by Sean Gallardy
The problem is only when there is a local secondary on the forwarder side because a forwarder is a primary replica
Can this be expressed in English?
 
ummm that is English as far as I can tell. 😁
What I want to know is did Gallardy reboot Windows as the first step in troubleshooting this
@PaulWhite what he means is the problem with the AG I was having is only manifested when there is a Distributed AG with a Filestream database. And the problem only shows up on 2022, with its default of multiple mirroring streams between the participant SQL Servers.
 
8:31 PM
That much I understood
 
so, the primary AG works all the time. i.e. if the forwarder is the only server on its side of the Distributed AG, then all is good.
If the Forwarder has a secondary the problem can manifest itself between the Forwarder and its secondary.
it's never a problem on the primary side of the Distributed AG, and only a problem if the secondary side has a Forwarder and a listener.
and only on SQL Server 2022
 
I see
 
Our production AG has two servers on the primary side, and only a single server on the secondary side of the Distributed AG, so regardless of the fact we're running on 2019, it'll never manifest itself in that environment. My home lab network however has four servers, two on the Primary side and two on the Secondary side of the Distributed AG.
 
And you're using Hekaton with DAGs?
 
actually no, just Filestream.
when I say "just" Filestream, I mean "hey we're using Filestream!!!"
:-D
 
8:38 PM
Have you tried not using Filestream?
 
This is the first time I've ran into it being used so much. But for what it does, it does it very well.
 
What are you using it for?
 
storing large legal documents that must be referentially valid against rows in the database
 
@PaulWhite I reckon that was darn gud english
What, no service broker?
Hekaton, Service Broker, FilesStream, the unholy trifecta
 
@SeanGallardy oh did I forget to mention that 👀👀👀👀👀
lets not forget CDC, as well
 
8:44 PM
why not have tran repl too
then you optimize with only 1 log reader agent
 
funny you mention it
 
add in datasync
because cloud
throw in a synapse link as well
over your polybase data
 
the Analytics team asked us to provide access to tran repl, but assured us they weren't going to use it.
 
If you don't need it then you won't need access to it
 
> signatories to the letter as of 06/05/2023 3:00 PM: 86 moderators covering 69 sites, 13 former moderators and 469 curators - 568 total.
@SeanGallardy pretty much
 
8:54 PM
@HannahVernon I never understand this. Why not just use a filename/URL only, and make that referentially valid.
 
because we need assurances that the file itself hasn't been modified outside of the context of the database; it being part of the database provides that assurance (admittedly not perfectly).
we only provide access to the file via the SQL Server APIs
also, being able to backup and restore the entire database, with all documents is of critical importance legally
 
And you use raw file stream rather than file tables?
 
yes, no filetables
 
Any special reason?
 
its always been that way
:-)
 
9:02 PM
Ah
 
well, since way before my advice was needed
 
@SeanGallardy hey don't be pulling in a perfectly stable, age-old, beauty of a feature with those other heathens.
 
So Wordle Saturday and Sunday took me 6 tries each - those words were horrible (NANNY and BEAST).
Wordle 716 4/6

⬛⬛⬛⬛🟨
⬛⬛🟨⬛⬛
⬛🟨🟩⬛⬛
🟩🟩🟩🟩🟩
 
I hated NANNY
 
The triple N's got me. But BEAST I was lucky enough to knock out on my first guess. :D
 
9:14 PM
I mean THREE Ns!
crazy
 
After 3 is was FANNY, MANGY, NANNY, but I must have tried something else that's also valid but not an answer
JANKY
JANKY, MANGY, NANNY were my 3 guesses - JANKY isn't even in the dictionary my analyzer uses, but they must have added it
 
I wonder why they have 2 lists of words.
I do use janky fairly regularly in conversation.
 
The old dictionary I have lists FANNY, JANNY, MANGY, MANKY, NANNY, WANKY as valid guesses.
 
Isn't Manky a pokemon?
 
I'm still miffed about JAZZY
 
9:17 PM
Hah such an excellent Scrabble word though. 30+ points without any score modifiers.
 
Are we talking about Scrabble tho
 
Technically we are now, since you responded about it. :)
 
And then for BEAST, analyzer says: BEAST, FEAST, *TEAKS, *TEAMS, *TWAES (where * are not allowed as answers) - I did TEAMS, FEAST, BEAST
Not sure why it excludes TEAMS as an answer
 
Bold starting word
 
Do you start with Z from now on in case Jazzy comes up again?
Squaredle has a lot of words that go in the bonus category that I think are pretty common
 
9:21 PM
It was a factor 🤣
@CadeRoux No plurals?
 
Today, eave and eaved were bonus words in Squaredle. And in Squaredle Express brad and bready were bonus words.
@PaulWhite I think so, I'm browsing all the words that end in S and BABES, BOOBS, C*NTS, DICKS, ARSES, ASSES are all not answers (in the original dictionary I have). But also ABETS, ACIDS, AIDES, ACRES, ALOES, ASHES, AUNTS, AURAS, AXELS, AXLES are also not allowed as answers.
Wow, there are only 36 words ending in S allowed.
And of those 21 end in SS
Like CLASS
Definitely no plurals
The single S ending words are all things like REBUS, TORUS, VIRUS, CHAOS
Nearly 4000 other words ending in S not allowed. This is a huge finding (although they may have fixed it after purchase)
 
@PaulWhite me too dammit
 
9:39 PM
@J.D. I know you're not talking about tran repl here which has more issues than AGs
 
@SeanGallardy <3 tran repl, wish to become tran repl one day...
In all seriousness, there are gotchas that can trip you up with tran repl, but I've never ran into anything that made me appreciate everyone else's hate for it, and I've been using it for almost a decade at this point.
I've used it in so many different ways too, I feel like a Dr. Seuss book could be written about it.
 
@J.D. I can probably help you with that; just don't ask me to jeagl
 
hahaha
 
too riské for SE probably
 
I've used heterogenous tran repl, with Oracle, MySQL, and PostgreSQL Publishers. I'm currently using it with a case sensitive database Publisher to a non-case sensitive Subscriber, with different Row-Level Security policies being applied on both sides, and schema bound objects on the Subscriber side.
All kinds of ways for things to go horribly wrong. Yet almost every issue is resolved by just turning it off turning it on again with reinitializing a new snapshot. I <3 tran repl.
I like AGs too, but my experience with them was short lived unfortunately. Tried to get them to implement them here but they weren't interesting in the licensing costs, understandably lol.
But the flexibility you get with replication > AGs for sure.
 
9:51 PM
@J.D. You haven't met the other customers, who refuse to ever make a new snapshot or use a backup from lsn.
"Hi, I have a 500 GB table and tran repl had an issue we found 6 months ago but didn't do anything. It's not been working for 6 months, distributor has been offline. We can't take the time to create a new snapshot for various reason. Fix now."
not even joking
 
lol yea but that's a self inflicted problem. If people are going to be dumb and leave their stuff broken for 6 months, that's on them - not replication's fault.
 
you'd think, but YOU'RE customer support and they created a support ticket with that
 
Yea I gotcha, it's sucky to be on that end of the stick.
 
and if you tell them they have to reinit... omg they will call your manager and get it escalated and call the account manager and say they will never use another ms product again
they'll stop their support agreement
all the things
raawr
 
But plenty of esteemed database peoples who don't have to be customer support, seem to strongly dislike the feature for their own reasons of merit I'm sure too. But I don't know why TBH.
 
9:55 PM
I'm not a personal fan, it has its uses, just like every other feature
 
@SeanGallardy yea I mean just more proof people suck lol
@SeanGallardy no doubt.
@SeanGallardy Riddle me this though for the sake of my own curiosity. Are there any other less sucky features of SQL Server that offer near real-time data access from a remote data source that also allows schema modifications? I fear the day MS drops support for replication, and contemplate what I'd do if that time comes lol.
 
@HannahVernon Is that the Canadian spelling
 
I'm not sure; it's likely to be the terrible spelling I just made up to look good
 
I would spell it, "risqué"
 
there you go
thanks for working that out for me
 
10:02 PM
Well you know I live to be helpful
 
and we all love you for it
 
10:52 PM
@J.D. There aren't any other features like that
 
Yea, figured so. It's a somewhat tough problem.
 

« first day (4535 days earlier)      last day (325 days later) »