« first day (4515 days earlier)      last day (649 days later) » 

mustaccio
mustaccio
02:17
good for you, two squares Hades
ah, ChatGPT to the rescue
> 冥王 (Méiwáng) is a Chinese term that translates to "Hades" or "King of the Underworld" in English
what brings you here, the king of the king of the underworld?
or is it the king of the underworld of the kings of the underworlds...
Can you be kind and welcoming, as the TeRmS oF sErViCe demand?
 
4 hours later…
Zikato
Zikato
06:23
Morning

Wordle 696 2/6*

⬛🟨🟨🟩🟩
🟩🟩🟩🟩🟩
Paul White
Paul White
06:45
Wordle 696 3/6*

⬛⬛🟨⬛🟨
🟩🟩🟩🟨⬛
🟩🟩🟩🟩🟩
John K. N.
John K. N.
Wordle 696 4/6*

⬛⬛🟨🟨⬛
🟩🟨🟨⬛🟨
🟩🟩🟩⬛🟩
🟩🟩🟩🟩🟩
 
2 hours later…
ConcernedOfTunbridgeWells
ConcernedOfTunbridgeWells
09:10
Seen on the interwebs today . . .
user image
 
1 hour later…
Paul White
Paul White
10:35
53
Q: We're regenerating all identicons

Cesar MWe've recently discovered a vulnerability in our identicon generation process. To remedy it, we have changed how we approach generating them and regenerated all identicons. We do not have any indication that any personally identifiable information (PII) was leaked as part of this vulnerability. S...

discussion profile-picture security gravatar identicon
FYI
Hannah Vernon
Hannah Vernon
11:27
Wordle 696 6/6*

⬛🟨🟨⬛🟨
🟨🟩🟩⬛⬛
⬛🟩🟩⬛🟩
⬛🟩🟩🟩🟩
⬛🟩🟩🟩🟩
🟩🟩🟩🟩🟩
Paul White
Paul White
You've really mastered the phew element
Erik Darling
Erik Darling
12:06
@PaulWhite you look the same
Hannah Vernon
Hannah Vernon
12:34
@PaulWhite yes, I have.
Seems I prefer uncommon words
Paul White
Paul White
12:51
@ErikDarling so do u
@HannahVernon and wrong ones too, it seems
Erik Darling
Erik Darling
whew we survived
James
James
Is it ok to ask for some SQL help in here?
Erik Darling
Erik Darling
you would probably be better off asking an actual question on main
James
James
hmm its not really worthy of a Q tbh, I dont need a full blown answer just pointer as to what approach or function to use. cheers
Erik Darling
Erik Darling
well okay, you can always ask, but don't be disappointed if we deem it worthy of an actual question
James
James
13:06
I have a table with column "surname" (string not unique) and column "credits" (tinyint for bool).
I want to select ALL rows which have duplicate surnames but only if at least one of them has "credits=1". If there are dupe surnames but all credits=0 return nothing
I've tried all sorts of sub queries and EXISTS. I can get the logic working but due to the clause "if credits=1" I can only get the rows where credits=1
Erik Darling
Erik Darling
yeah, that's an actual question. you should follow the directions here: Help me write this query in SQL
Hannah Vernon
Hannah Vernon
@PaulWhite very droll
Paul White
Paul White
what an unusual word
James
James
thanks. I shall leave this place of general chat void of help :)
Paul White
Paul White
@James No column that uniquely identifies a row? Just surname and credits?
@James For SQL Server: dbfiddle.uk/FmJ-c1ff pretty generic tho
General idea being to group by surname and check there is more than one in each group (so, a dupe) with at least one of them having credit = 1 using MAX
@James Translated for MySQL: dbfiddle.uk/EBnbdCDR
Lamak
Lamak
13:44
Wordle 696 3/6

⬜🟨🟨⬜🟩
🟩🟩🟩⬜🟩
🟩🟩🟩🟩🟩
James
James
@PaulWhite Thank you very much. That is working for me adapted to my code. And waay beyond my level of SQL. Dammit Jim I'm a dev not a DBA
Paul White
Paul White
14:09
yw
 
2 hours later…
Erik Darling
Erik Darling
15:51
0
Q: Long script never compiles unless number of characters reduced

SE1986I have a script which appears to never compile. The script is quite long and I have found that reducing the number of lines (or maybe characters?) allows the script to work I have created a repro below (the real script is more useful obviously but even on the fairly simple script below I can repl...

sql-server sql-server-2019
@_@
 
1 hour later…
J.D.
J.D.
16:51
@ErikDarling What's Swart's 10% rule on script length? ;)
Josh Darnell
Josh Darnell
17:17
I can't repeat that problem.
J.D.
J.D.
17:29
Sounds a bit localized to me. Especially the bit about the sysadmin logins. Seems more likely dependent on whatever else is going on with their server at the time and how it's configured perhaps.
Josh Darnell
Josh Darnell
17:52
EF Core 8 Preview 4: Primitive collections and improved Contains
That's an...interesting solution to the "in list" problem with EF generated queries. 
-- Current state
SELECT [b].[Id], [b].[Name]
FROM [Blogs] AS [b]
WHERE [b].[Name] IN (N'Blog1', N'Blog2')
-- new stuff
SELECT [b].[Id], [b].[Name]
FROM [Blogs] AS [b]
WHERE EXISTS (
    SELECT 1
    FROM OpenJson(@__names_0) AS [n]
    WHERE [n].[value] = [b].[Name])
They are trying to solve the plan cache pollution problem. I wonder how that ends up performance / query plan wise.
I haven't looked (yet, growth mindset).
Erik Darling
Erik Darling
18:22
@JoshDarnell terrible i'm sure
@J.D. remove 10% of the characters
OH MY GOD 
SELECT [b].[Id], [b].[Name], [b].[Tags]
FROM [Blogs] AS [b]
WHERE EXISTS (
    SELECT 1
    FROM (VALUES (CAST(N'a%' AS nvarchar(max))), (N'b%')) AS [v]([Value]) -- inline collection
    WHERE EXISTS (
        SELECT 1
        FROM OpenJson([b].[Tags]) AS [t] -- column collection
        WHERE [t].[value] LIKE [v].[Value]))
i absolutely can't with these people
pooch, screwed
i used to think that shay rojansky was just dumb, now i think he's malicious
Josh Darnell
Josh Darnell
18:45
Time to make more friends? 🤣
Erik Darling
Erik Darling
yes i believe it is
J.D.
J.D.
19:03
Love it.
Erik Darling
Erik Darling
19:33
user image
J.D.
J.D.
@ErikDarling Disagree.
Erik Darling
Erik Darling
take it up with the chalkboard
 
2 hours later…
Paul White
Paul White
21:56
The E in EF stands for Entirely
Josh Darnell
Josh Darnell
Entirely Functional?
😜
Erik Darling
Erik Darling
22:18
Finally, a comment I want preserved
I'm embarassed. Perhaps I should delete the question. — grahamj42 2 hours ago
Erik Darling
Erik Darling
22:54
twitter.com/erikdarlingdata/status/…
Forrest
Forrest
23:25
@ErikDarling 1000 row table for testing
wow
Erik Darling
Erik Darling
Quite meaningful
EFfortless

« first day (4515 days earlier)      last day (649 days later) »