« first day (4469 days earlier)      last day (392 days later) » 

1:56 AM
> This has been documented in a bunch of places for a long time
But not very easy to find. Second page on Google turns up this sqlity.net/en/2351/gam
On another note: it's always annoyed me that DBCC PAGE isn't more consumable. what about sys.dm_page_data() or something?
 
 
3 hours later…
4:35 AM
0
A: What is the stride of a GAM interval

comment-answersThis info can can also be gleaned in newer versions from sys.dm_db_page_info. Here's a brute-force method on a test database: SELECT * FROM sys.database_files AS df CROSS APPLY generate_series(0, df.size-1) AS series CROSS APPLY sys.dm_db_page_info(DB_ID(), df.file_id, series.value, 'DETAILED'...

@ErikDarling Yes, I think it's more about documenting the journey and the basis for the number, which itself is reasonably well-known.
@SeanGallardy Yes, but do we have a Q & A for on here. Many things are available elsewhere on the internet. If it were that easy to find - including why that number applies - I doubt Michael would have asked and self-answered the question.
@Zikato There is, and thank you.
@J.D. There's only one timezone for New Zealand. We do observe DST though.
 
5:36 AM
"but I cannot figure out how to break that down further" - What do you mean by this? At quick glance your query and description appears to match your example table. (Though I think you might have one too many parameters in the DATEDIFF() function?) — J.D. yesterday
@J.D. Are you missing a word from that comment?
 
 
1 hour later…
6:47 AM
@JohnK.N. Minor corrections? dba.stackexchange.com/revisions/325437/3 You rewrote the answer!
 
:-)
Morning
Wordle 650 4/6

⬛⬛⬛🟨⬛
⬛🟨🟩⬛⬛
⬛⬛🟩🟩🟩
🟩🟩🟩🟩🟩
I initially just coded the code. And then thought I'd rename fields to columns and continued from there...
 
7:02 AM
Morning

Wordle 650 5/6*

⬛🟨⬛⬛🟨
⬛⬛⬛🟨🟨
⬛🟨⬛🟩⬛
🟩⬛🟩🟩⬛
🟩🟩🟩🟩🟩
 
Wordle 650 4/6*

⬛⬛⬛🟩🟨
⬛⬛🟩🟩⬛
⬛⬛🟩🟩🟩
🟩🟩🟩🟩🟩
 
I have a hunch what this guess was for both of you
⬛⬛🟩🟩🟩
 
An on topic guess for sure
 
very much so
 
 
1 hour later…
8:17 AM
@ErikDarling I can confirm it is much better known now than it was a week ago; locally anyway, I can't speak for the internet.
 
😀
 
I am Coax. I speak for the internet
 
@SeanGallardy if you could point me towards a more direct approach I'd appreciate it.
 
Perhaps Sean was referring to a place in the documentation (sorry, learn) where it is described correctly. I can't find it yet, but the learns are tough to search these days.
 
> It's documented

I did look. MS-published pages mentioned 4GB and 64000 pages. Neither of which are the actual number. So I started hunting.
 
8:27 AM
Yes. Hence my saying, "described correctly".
It might be described correctly in the learns somewhere, but I can't see it.
 
"A web search away"
Now that I know the answer I can find it. Back then my google-fu was weak. Nothing that came my way gave a value that I could plug into DBCC PAGE.
 
Have you tried being a Microsoft Support Engineer for 20 years before thinking of questions
 
@Charlieface That page did come up in my search. I found the invocation of the magic hex value 0x381f and the assertion of its meaning .. unsatisfactory. I considered adding it as background to the post but forgot. :-(
I've tried bugging Microsoft Support Engineers over the last 20 years. Does that count?
 
Little bit
 
@MichaelGreen true
Hidden knowledge? Not allowed to disclose?
 
8:40 AM
More likely an educated guess
 
@PaulWhite In other news, we have our own exclusion now, because we're special snowflakes. If anyone is interested in a repro, the instance has to be installed with Latin1_General_BIN2, not just the replicated table or the database that holds it.
2
 
Nothing about Azure interests me, sadly. Replication doubly so.
 
I've searched my local copy of documentation and didn't find any reference to numbers 63904 or 511232
 
Perhaps Microsoft use a special internal-only ROUND function
 
@PaulWhite Very sensible.
 
8:50 AM
Just self-interest and self-preservation really
 
It should have been "If anyone is interested" but now it's too late to edit.
 
Instead of, "If you're interested..."? I can fix that for you if so
I suppose it's a bit like how some people enjoy working out all the incantations needed to drive github. Not for me.
 
yes please for the fix
I wasn't targetting you; just chat back-references and English second person pronouns colliding.
 
@MichaelGreen Changed "repo" to "repro" while I was at it
The context for anyone who needs it
The chat edit window really is a bit short
I imagine an instance collation of Latin1_General_BIN2 can lead to an interesting life
 
BIN2 certainly affords plenty of learning opportunities. As in "you'd have thought I'd have learnt by now not to do that thing!"
 
9:03 AM
It's a perfectly valid choice if that's what you need, of course. Just one of the more interesting ones.
ha!
 
 
1 hour later…
10:18 AM
@PaulWhite I know, but it only gives the page header. You would think there would be an option to actually retrieve the raw payload data, but no, that's classified apparently. I suppose we should be thankful that This function replaces the need to use DBCC PAGE in most cases.
 
Sorry wrong side of bed and all that
 
No, it's fine. I wasn't sure you were aware of sys.dm_db_page_info is all.
 
It actually slipped my mind when I wrote the comment, but I wasn't referring to page headers anyway.
 
10:55 AM
I suppose there is always WITH TABLERESULTS
By the way anyone got any thoughts on my median solution dbfiddle.uk/H45OoNrS It seems to be pretty performant for cases where the value has a lot of duplicates
It's the second batch, the first one is Aaron and Itzik's OFFSET trick
 
The OFFSET solution was created by Peter Larsson wasn't it?
mcs is a daft abbreviation
 
11:14 AM
Couldn't be bothered writing the whole thing out, it's weird enough that you wouldn't mistake it for month or millisecond, but yeah in real code I prob would write it out.
@PaulWhite Point being? Looks the same apart from PAGLOCK?
I find the timings not very accurate, they seem to swing around quite a lot on dbfiddle.
 
@Charlieface It's very much faster. See sqlperformance.com/2015/07/sql-plan/locking-and-performance for why.
 
@PaulWhite Hmm, I guess the same applies for my solution, which also has a TOP. But for outright perf I would probably just do TABLOCK and be done with it. Any other thoughts? I used that trick I mentioned to get the previous running count: instead of using AND 1 PRECEDING I just subtract the current val
 
11:29 AM
@PaulWhite nice, I haven't read this one yet
 
@PaulWhite Aaron credits Itzik sqlperformance.com/2012/08/t-sql-queries/median but I'm afraid I wasn't in the game that far back, no idea.
 
@Charlieface Let me put it another way then. Peter Larsson wrote it 😀
 
@Zikato I'd read Paul's article a while back but completely forgotten it. I think my solution should work with grouped medians also.
@PaulWhite Guess you'd better ping Aaron then...
 
@Charlieface No
 
does he bite?
Asking for a friend :-)
 
11:32 AM
@Charlieface I just wanted to let you know, in case you were interested in crediting the right person
 
Good thing I don't blog... Scary DBAs coming round late at night to beat you up, risky...
 
@Charlieface You might want to try a HASH GROUP hint to see if that goes a little bit faster.
 
What a great write-up
 
Oh and don't name a column 'lag' or 'count'
 
name it 'Iag' to confuse people
 
11:34 AM
No the whole point was to get an ordered read, hashing is going to mess that up.
Woz tired and naming is hard.
 
I strive to be as eloquent as Paul
 
Annoying thing is, you can't use the result of a windowed count to inject into the TOP which would have made Peter's faster
 
Too bad I'm not making any steps to improve in that area.
 
I like Aaron's naming " 2005_A – dueling row numbers" hmmm two row-numbers walked into a bar, one pulled out his over and shot the other, who responded with a reverse dense_rank dropping him on the floor.
 
@Charlieface You'll get a batch mode hash agg and batch sort
It's a bit faster for me. I wouldn't have suggested it otherwise.
The @Median variable is unused.
It seems to produce correct results though, so that's good.
 
11:40 AM
@PaulWhite Yeah was copied straight out of the article and wanted to see the actual results to check.
 
For a direct comparison, we'd need a nice way to get Peter's solution to use a batch mode scan. That's not easy though.
 
Correct results is iffy with this, there's a lot of edge cases with overlapping ranges and negative modulos
Couldn't get a batch mode on it either
 
The median problem is famous for edge cases, yes.
Well, I didn't say I couldn't do it, I said it wasn't easy.
 
Continuing the story: count walked in and said over ()!
running_sum shouted back "I was preceding you"
 
Why did you add the MIN_GRANT_PERCENT = 5 hint?
 
11:45 AM
Then group by "rolled up" and told everyone to hash off
@PaulWhite Got a batch spill. I'm surprised it works in such a locked down environment. I managed to get 730Mb.
 
@Charlieface On which operator?
 
Think it was one of the Window Aggregate but not sure anymore, was working on it a few days ago, so might be irrelevant now.
 
@Zikato Thank you
 
12:08 PM
@PaulWhite Morning. I don't believe so, but which word do you think I'm missing?
 
@J.D. I thought maybe a "not" in "At quick glance your query and description appears to match your example table."
 
Wordle 650 5/6

⬜🟨🟩⬜⬜
⬜⬜🟩🟩⬜
⬜⬜🟩🟩⬜
⬜⬜🟩🟩🟨
🟩🟩🟩🟩🟩
dammit
 
@J.D. I couldn't really correlate the comment with the VtC as unclear
But if it is as you intended, then ok. The question does have an answer now though.
 
@PaulWhite apparently Chatham Island has a different timezone?...and is one of those odd places in the world whose timezones is offset by a fraction of an hour.
But I guess it's safe to assume you don't live there lol. I didn't read that far when I was looking up timezones yesterday though.
 
Oh yes there are a few outliers and technically part of NZ bits that have other timezones.
But the two main islands have the same zone all year.
 
12:12 PM
Gotcha gotcha.
I never understood why some places make it more complex by offsetting by a fraction of an hour. Sri Lanka does the same, they're offset by a half hour.
 
Don't look at Australia
 
@PaulWhite Fair, probably would end up injured somehow just by doing so.
 
> the first country to legally have a unified time zone was New Zealand, which adopted a single time zone in 1868.
I did not know that
 
Arizona is like Russia: They don't change between summertime and wintertime
How's that for confusion?
 
Also China has a single time zone
> If you cross the border from China to Afghanistan, there is a 3 ½ hour time change, the largest for any border crossing in the world.
and
> Nepal has its own special time zone which is plus five hours and 45 minutes from GMT
 
12:20 PM
chile changes to summer light saving time, which leaves us at GMT-3, then we go back to our "normal" time GMT-4, when our geographic time zone should be GMT-5
 
The town of Eucla in Australia is UTC +8:45
 
Wordle 650 5/6*

⬜⬜⬜⬜⬜
⬜⬜⬜⬜🟨
⬜🟨🟩⬜⬜
🟨🟨🟩⬜🟩
🟩🟩🟩🟩🟩
@PaulWhite Just the town?!
Madness.
 
@JoshDarnell Yeah
> The small town of Eucla, Western Australia is on the border of South Australia. They have their own little time zone where they split the difference between Perth and Adelaide and are offset by forty-five minutes from each.
 
Arizona just refuses to partake in daylights savings time while the rest of the US country does. So at different parts of the year, the time differential between the rest of the country and Arizona changes. E.g. NY is ahead of Arizona by 2 hours right now, but it'll increase to 3 when we push the clocks back in the Fall.
Time was a mistake?
 
> For most of human history we didn’t have time zones nor did we have a need for time zones. The distances between places and the speed people could travel meant that small differences in time between communities really didn’t matter, so each Community could have their own local time based on solar noon and no one was any the wiser.
 
12:28 PM
@PaulWhite Another place using fractional time offsets. 🫠
 
Ah the meting face emoji
 
@J.D. I would rather not having daylights saving time
 
I'd prefer summer all year
Short days and long nights are the problem here
 
@PaulWhite I prefer our "normal" time
 
@Lamak Oh agreed. I wasn't trying to imply Arizona are the wrong ones. It's just interesting how 1 of the 50 states gets to rebel.
 
12:30 PM
Who ever thought elliptical orbits were a good idea
 
I hope they do agree to nationally stop Daylight Savings Time.
 
And a tilted earth axis, what's that all about
 
@PaulWhite what are typical sunrise and sunset times over there?
 
 
@Lamak Depends on the time of year 🤣
 
12:31 PM
ChatGPT is listening?
 
@J.D. It's never heard of Eucia, obv
 
I guess there's a small list of places it could've answered with, but that's still a little spoopy to me, given that's what started this conversation lol
 
If we didn't have DST:

Winter: sunrise 7:45am, sunset 5pm
Summer: sunrise 4:45am, sunset 8pm
Add an hour to the summer times for DST
 
4:45 till 8pm is quite the day
 
12:47 PM
Yea that's pretty cool actually. One could spend their entire waking day in mostly daylight in the summer, eh?
 
@J.D. more so with DST
 
Yes and also because it's light longer than sunrise to sunset
It gets light about 5am (DST) and dark-ish about 10pm here on the longest day
 
@PaulWhite doesn't seem like there's really a need for "Day lights SAVING time" though
 
@Lamak It's a stupid name. It does make the evenings lighter in summer, which is popular
Sunset at 9pm is nicer than 8pm
Sunrise before 5am just makes life harder
You've missed a good chunk of useful day before you wake up
Unless you're a dairy farmer or sthg
It's tough to get a decent sleep in summer regardless, I suppose
 
what's that with elliptical orbit and tilt? How can a flat earth be tilted?
 
12:53 PM
I propose a system of longer working days in summer and shorter in winter
@JohnK.N. Can you tilt a plate
 
Doesn't work in space or we'd all fall off
</irony off>
 
Turtle with longer legs on one side
 
It's turtles all the way down. Or so I heard.
 
More so on one side than the other
Luckily, the angle is not so severe people fall off
 
Wordle 650 4/6*

⬛⬛⬛⬛⬛
⬛⬛⬛⬛🟨
⬛🟨🟩🟨⬛
🟩🟩🟩🟩🟩
Not so lucky today lol
Although I suppose eliminating 35% of the alphabet in the first two rows helps
 
1:17 PM
@JohnK.N. Of course it can, there is nothing to stop a flat earth orbiting anything or being on slant? And it's not just tilted on the rotational spin, the whole orbit is also tilted. It's also eccentric so we move faster in the orbit and are closer to the sun at different times in the year, which doesn't correlate with the seasons (which are caused by the tilt)
Earth's orbit is an ellipse with the Earth-Sun barycenter as one focus and a current eccentricity of 0.0167. Since this value is close to zero, the center of the orbit is relatively close to the center of the Sun (relative to the size of the orbit). Earth orbits the Sun at an average distance of 149.60 million km (92.96 million mi) in a counterclockwise direction as viewed from above the Northern Hemisphere. One complete orbit takes 365.249 days (1 sidereal year), during which time Earth has traveled 940 million km (584 million mi).As seen from Earth, the planet's orbital prograde motion makes...
Discworld is a comic fantasy book series written by the English author Terry Pratchett, set on the Discworld, a flat planet balanced on the backs of four elephants which in turn stand on the back of a giant turtle. The series began in 1983 with The Colour of Magic and continued until the final novel The Shepherd's Crown, which was published in 2015, following Pratchett's death. The books frequently parody or take inspiration from classic works, usually fantasy or science fiction, as well as mythology, folklore and fairy tales, and often use them for satirical parallels with cultural, political...
 
Discworld sounds like fun, best bit is the benevolent dictatorship. Better than Hungary any day.
 
@Charlieface Did you know planet Earth is the only place fire is known to exist and capable of existing in our Solar System?
 
1:35 PM
What about the big bright part in the middle?
 
1:46 PM
@JoshDarnell I said that too when I learned the above, and then I learned it's not actually on fire, it's just hot gas.
Commonplace image portrayals of the Sun and stars are somewhat misleading, I suppose.
 
Seems kind of pedantic.
 
Nasa can probs articulate it better: "The Sun does not "burn", like we think of logs in a fire or paper burning. The Sun glows because it is a very big ball of gas, and a process called nuclear fusion is taking place in its core."
 
WeLl AcKsHuWaLlY
4
 
@JoshDarnell Idk, I guess it's a minute difference. But I found it interesting, because when I used to think of Sun I thought of fire.
 
For what it's worth, that quote doesn't say the sun doesn't burn, or that there is no fire there.
If we're going to continue being pedantic 😀
It says it doesn't burn like paper or logs.
 
1:53 PM
it is interesting
> the concept of fire as we know it on Earth is unlikely to occur elsewhere in the same way. Fire requires oxygen to combust, and the vast majority of the universe is composed of vacuum or environments with low concentrations of oxygen.

However, if we consider the broader definition of fire as a release of energy through exothermic chemical reactions, there are certainly processes in the universe that can be likened to fire. For instance, stars like our Sun generate energy through nuclear fusion, which is an exothermic reaction that converts hydrogen into helium at extremely high temperatu
 
@J.D. If you define fire as a hot combustion gas made from a rapidly oxygenated material then yes you're right. I believe there may be many other atmospheres that can do other types of combustion
 
I guess what I gather from all of this, is it just comes down to how one wants to define what fire is.
@Lamak At least I'm not the only one who thought so lol.
 
The most interesting fire thing I learnt was the difference between deflagration and detonation, eg a Molotov cocktail doesn't detonate, but a "banger" in a kid's toy gun might do so.
 
oOo
 
@J.D. I also thought it was interesting 😀 I was just being antagonistic. For fun, you know.
@Lamak So nuanced!
 
2:11 PM
Happy WE everybody
 
you know what I love about SolarWinds DPA?
nothing.
@J.D. fire requires oxygen. There are only trace amounts of oxygen in the sun, therefore "fire" would be virtually impossible.
 
2:27 PM
@JoshDarnell heh I know. 🙂
@HannahVernon Exactly though! lol
@HannahVernon ah so you've been caught in the SolarWinds too eh?
 
they're the best, aren't they
 
@HannahVernon haven't used other solutions to be qualified to rank them, so unfortunately they're the only for me. But I only have to touch their SQL Sentry Client, which isn't too bad. The infrastructure team here gets to have fun with the rest of the storm.
 
@HannahVernon It's funny to see the word "trace amounts" used to refer to such an immense quantity of something.
Astronomy is weird.
 
for sure
like a very small nebula where the central star is 20x the mass of our sun takes light 60 years to traverse
 
According to Google searches I'm doing, the mass of the sun is equivalent to 330,000 Earths. And oxygen atoms make up close to .1 % of solar mass. Which means "trace amounts" of oxygen is equivalent to the mass of 333 Earths 😅
My definition of fire is "can you use it to toast a marshmallow?"
 
2:36 PM
lol pretty sure you'd have a tough time getting exactly the right distance away from the sun to toast a marshmallow but not you at the end of the stick - it would have to be a very long stick
2
@JoshDarnell it's a big place aint it
 
Bit like the event horizon of a black hole: you don't know it's coming til you're gone.
 
I would venture to guess that for certain black holes, such as the ultramassive black hole NGC 4889, you'd not know you were inside the event horizon for a long time
its so big it makes our solar system seem pretty small
 
@Charlieface i'm not sure what you searched for, but i got much better results on page 1
 
@HannahVernon LOL. Hey, with a magnifying glass, I might be able to toast one right here on the Earth's surface with the "fire" from the sun.
 
well, if you can cook a chicken by slapping it...
 
2:49 PM
@JoshDarnell lol
@Lamak pardon
stop slapping your chicken
 
you've got to be kidding lol
 
lol...using @JoshDarnell's definition, slaps might be fire too
 
friction has been known to cause a little fire once in a while lol
 
What the hell are you all talking about. The Sun is obviously on fire
 
2:52 PM
🔥🔥🔥
 
i was reading the transcript and too many other things happened
i feel all out of sorts
 
Very readable code, I blame @JoshDarnell
> <<lambda_79e93c6b465e0b6b5171920a99d09057>,<lambda_c5a5b6b1e051acac7b3d30b8e578eac8> >
followed by
<lambda_c5a5b6b1e051acac7b3d30b8e578eac8>::operator()
 
For future reference, this website is primarily focussed on database centric questions, which your above problem is not. Application related issues are more likely better served on StackOverflow.com. Also, even on the most appropriate site, you'll probably still need to add more details to your question such as an example set of code where the issue occurs around and the stack trace and / or other details related specifically to the error. — J.D. 59 mins ago
 
@SeanGallardy I hate all that nonsense
 
@PaulWhite I have no clue, from this dump, WTF is going on
 
3:05 PM
I'm sure the source code is mightily elegant
 
I get the whole "it's easier for me as a dev to just write an inline lambda, look how awesome" until you have to debug it
syntactic sugar, rots the brain
2
 
Reminds of the discussion about await recently
 
@PaulWhite I'm going to look at it now, but assuming the number of lambdas on this stack... I'm betting it's uglier than Erik after Tequila
I've been told everything runs faster if you just await/async everything
 
In modern times, I often have to scroll several screen widths just to see the parameter declarations
 
that's a lot of tabs
 
3:07 PM
The current thinking seems to be: type as few characters as possible and let the compiler sort it out
 
@SeanGallardy this is why Visual Basic will never die lol
 
await/async must be one of the constructs with the highest characters:code generated ratios
Also, the Sun is definitely on fire
2
I don't know if you all heard me before
Sun = Fire
p basic stuff, people
@ErikDarling Did you count the pages yourself? You do recall maths not being your strongest suit?
 
@Lamak lol meat beater 9000
 
@MichaelGreen Looks like someone beat me to the page DMF. I also sometimes forget I work with this stuff all the time so it's common for me (and those in this chat) to know it off hand.
 
3:33 PM
@PaulWhite no, there was a helpful indicator on the webpage
 
Can't believe everything you see on the internet
Google especially is quite unreliable
 
are you sure?
 
nope
 
saw it on the internet
 
3:37 PM
on page 511232
2
 
well it was rounded to 512,000 but yeah
oh maybe that was bing
 
3:52 PM
@PaulWhite Idk mate, Nasa seems to disagree.
Which StackExchange site be best for the following scenario: A failing CLR function, that errors on trying to update Active Directory with an "Access is denied" error, but the C# code works just fine locally, it's only failing on the deployed SQL Server server.
I can think of like 4 that sites that intersect in that context. :/
 
@PaulWhite probably ChatGPT
@J.D. maybe you should consult your System Administrator
 
closed as too localized
 
@HannahVernon I wish lol.
@ErikDarling heh, perhaps.
 
hannah@mvct.com
Which StackExchange site be best for the following scenario: A failing CLR function, that errors on trying to update Active Directory with an "Access is denied" error, but the C# code works just fine locally, it's only failing on the deployed SQL Server server.

Based on your scenario, I would suggest posting your question on the Stack Overflow site (https://stackoverflow.com/).

Stack Overflow is a popular community-driven question and answer site for programmers and developers, where you can ask technical questions related to programming and software development. It has a
 
That's ChatGPT's response?
 
3:59 PM
hth
 
I'm apparently not on the up-and-up with acronyms lol. hth?
 
had to google it too, "hope it helps" it seems
 
oh lol.
I'm about to just hit ChatGPT up for the answer to the problem itself. Maybe it'll point me towards Service Broker. :)
 
@J.D. Sound like the account doesn't have permissions :D
 
@SeanGallardy It does, doesn't it?...except using the same account locally works. The CLR function actually takes in the credentials as parameters for the account to use to connect to AD. Passing them in to the deployed CLR function results in that error, passing them locally doesn't and actually updates AD.
 
4:06 PM
@J.D. Did you dump the thread token and see if it actually is impersonated correctly?
 
@SeanGallardy I feel like I dump enough hot trash in this chatroom lol. Want to discuss separately?
 
@J.D. yes. Be sure to include the link here so we can help
 
@HannahVernon sure. thanks! - chat.stackexchange.com/rooms/145009/…
 
@J.D. lol nice
 
@HannahVernon lol gotcha
 
4:13 PM
Obvs I'm just joshing you
 
yea haha
 
5:05 PM
canonical pronunciation of "jeagl" is "jiggle"
yw
 
5:24 PM
@J.D. lol "The Trash Heap"
 
😆
 
@HannahVernon ahem
@SeanGallardy Hahaha that's good.
I do enjoy a good lambda, although I don't feel like it jacks up C# stack traces as much.
 
@JoshDarnell thought you might enjoy that
I wonder if they're a spammer
 
Hard to tell.
 
6:17 PM
@HannahVernon i love this
 
7:03 PM
we seem to be lousy with them
a titan returns
he didn't get his old UserID though? 🤔 but some of his old questions got re-assigned to his new ID. i wonder what happened there
 
@PeterVandivier lol, seems a cleanup is in order
 
@PeterVandivier i thought it was yaegle
 
@HannahVernon 🔥
does data.se let you query the dba.se posts table or is it only SO proper?
herrrrp derp
if only it were like... the first button you click on the home page 🤦‍♂️
 
yea, i was just looking for Shawn's old posts. I didn't realize burninating your account did a hard-delete of the User record data.stackexchange.com/dba/query/edit/1728390
i thought i remembered something where high rep/very active users only got their user records obfuscated
 
7:20 PM
from what i recall all the content got left behind and the user name was disassociated from them
 
ahhhhh, the displayname still shows user507, but the ID is toasted dba.stackexchange.com/questions/11299/…
 
yeah, i went looking because i know shawn had answered a really old question of mine: dba.stackexchange.com/a/76268/32281
 
this is fine dot gif
 
7:25 PM
all is well
 
@PeterVandivier well, there's only 75 pages of spammer users now lol
I wish I had a bit more skill with javascript because I'd just wipe them all out programmatically lol
 
7:40 PM
@PeterVandivier Literally France right now
 
@SeanGallardy 🔥🍷🥖🧀
@HannahVernon once every year or two i'll get my dander up about doing something with the SO API and I always give up after a couple hours ¯\_(ツ)_/¯
 
you should try moisturizing instead
 
8:04 PM
@ErikDarling do you want to delete the trailing whitespace on all files or just the files updated by the commit?
 
8:27 PM
@Zikato all files should be cleaned wrt tabs, crlf, and trailing spaces beforehand, so only new commits would need to be checked
 
9:06 PM
I think I have all necessary pieces. If time permits, I could have something tomorrow
 
thanks, that's really cool. no rush at all, so don't beat yourself up on a weekend over it.
might even make a good blog post :D
 

« first day (4469 days earlier)      last day (392 days later) »