Computers were a mistake?

@SeanGallardy yeah that

A chairde - Morning all!

morning

> I didn't know you were Gaelic

You could call me a "Gael" which means a descendant of those who speak/spoke a Gaelic language - i.e. Irish, Scots Gallic or Manx! Gaelic (football - often abbreviated to GAA - pron. "gaah" - "I've GAA (or "football") training this evening...") is also a word we use to describe the variety of football played in Ireland.

It's v. similar to Australian rules (which derived from Gaelic (football)), except that it is played with a round ball. There have been tests played between the two codes (20 test series). It's a testament to the Irish players (amateurs) - we can hold our own against (10 series each) the Aussies (professionals) - indeed, AFL teams regularly "poach" GAA players to go to Australia!

@Vérace I usually map some combinations (like äöü) onto a UK keymap, there are enough free points for the most often used ones

Someone thinks QUOTENAME has problematic performance, and also returns a nvarchar(258) instead of nvarchar(130) which is also a problem somehow? And therefore it's better just bash a couple of [] in manually??

What a jerk.

> I am not use to see so much stupidities from developer, perhaps because my age (62) and my experience in RDBMS since 1982 is however too poor compare to your own one ! – SQLpro 7 mins ago

that user has posted a bunch of really bad answers over here too

seems as bad at arguing as at sql

A right menace

French, ofc

@ErikDarling I feel like there's a joke I am missing here 🤔

lol their profile is pretty great,

@Vérace Yeah, I meant it as a generic for the places where Gaelic languages are spoke

@SeanGallardy no joke, josh fixed my site to have twitter cards so that post previews show up rather than just a URL

see the difference?

@ErikDarling Ah, I see, basically not for twitter per se but for URL preview help

no they're specifically called twitter cards

so you get the preview thing in tweets

That's what was throwing me :)

I was like, you know I don't do twitter

Hence why I thought there was a good joke in there

JEAGL non-joke

just trying to get you some credibility

(at microsoft)

:D

> If the Gods of post scheduling cooperate, this should publish on October 3rd.

From today's blog post @ErikDarling 😄

The Gods are cruel.

oh yeah i had to swap it for something

good job there

maybe it's a great joke now though

think i'll leave it

It made me chuckle, I wouldn't change it haha.

@ErikDarling like this gem:

(question tagged with sql server)

what the flippity floppity heck is he talking about

Are you disagreeing with a 15 year MVP?

always

that's a real gem

perhaps someone should ask him what PFS pages are for

Look, Paul. In 40 years of working with DBMSs, he's never had to know what a PFS page was for.

So, you know. How dare you, etc.

i'm 84 and invented databases and look how dumb you are

All excellent points.

I'm off to replace all my QUOTENAMEs with square bracket concatenations

Good triumphs over evil.

Hm. Well that's interesting.

SQL Server never ceases to surprise me.

If I figure out that strange thing that just happened, I think I'll write it up.

Anyway. Started seeing edited posts today on the bird app.

can you describe the strange thing

Doesn't seem like a big deal. Has the obvious implementation.

Wonder why there was so much delay & resistance.

@ErikDarling It's to do with simple parameterization. Something I thought I knew well. An apparently impossible thing just happened. I don't yet know how or why.

Putting 'simple' in the name is really starting to take the piss

@PaulWhite seems like parameters were a mistake

no kidding

sniff

OPerators are standing by

so, changing from an int to a bigint, using a copy of the table

the insert has a sort even though both tables have pks

alarming

v. alarming

[StackOverflow2013].[dbo].[Votes_bigint].[Id] = [Expr1003]

@ErikDarling did you not add indexes? ;)

ha ha ha

ho ho ho

And a couple of tra-la-la's

columnstore reorgs don't clean up deleted rows?

a lot of singing, not much chess playing

You never sent me a game

@PaulWhite Makes you wonder if people change things just so you don't get comfortable ;)

oh, I was watching the game with Zikato. invitation sent

You're watching him win, yes

I like to move right before I have to talk in a meeting, good decisions

アルコール

Your new tattoo?

not your worst idea

That's either a down the arm or down the spine one for sure

You'll have something in common with the young girls!

I might write a blog post for this T-SQL Tuesday: T-SQL Tuesday #155 – The Dynamic Code Invitation

@JoshDarnell "Anything that relates to code producing code" and you don't want to do EF?

@SeanGallardy Oh, it would definitely be about EF 😁

@ypercubeᵀᴹ kicked my butt

@JoshDarnell nice! I'm hosting the next one.

What’s your topic going to be

It was supposed to be "what's in your toolbox" but Brent got ahead of me with the September thing

so now I'm thinking "What makes code production-grade?"

Brent got ahead of you with that one too

brentozar.com/archive/2020/08/…

Why is it so hard to have an original thought?

But I don't mind that someone blogged about it as long as it's the whole community

@Zikato If it's running in production 🙃

🔥🔥🔥

Just ask the Stack Overflow devs re: their database design.

Those responses were so cringey

Holier than thou

Hahaha it’s totally normalized except the parts that aren’t

Dunces

@Zikato Haha good callback.

I'll plan on responding to your T-SQL Tuesday as well, @Zikato. If I can think of anything.

@SeanGallardy I suspect trolling by Microsoft yeah