@swasheck hey nice to see you!

@JamesLupolt hellloooo!

@JamesLupolt Hello James

Welcome Back.

Morning;

Morning

@Zikato That ain't NoSQL statement

It's practice

Morning

@jcolebrand @mustaccio I 'voted' to close at the time because the OP had already asked the same question twice on SO, asking the same question again after getting no responses the first time, then asking a third time on our site. There were three live copies across the network at the time. I saw this as taking the piss.

A chairde - Morning all!

@jcolebrand I see the SO copies have now been removed so the cross-posting issue is resolved. I don't have an opinion on it being off-topic or not so I'll defer to your judgement.

Gawd almighty! People are complaining about a 30km speed limit in the Phoenix Park saying that "their cars can't go that slowly..." - IMHO, if you can't drive your car at 30km/h, you shouldn't be on the road! What happens when they're in a housing estate and there are children playing - do you continue at 50km/h or reduce speed?

@PaulWhite the two SO questions are closed/deleted now, too.

@ypercubeᵀᴹ Yep

just saying. I have no opinion on reopening/keeping it closed

@ypercubeᵀᴹ same

@Zikato By "quote" are you referring to:

Or the thing I just did to quote my own message in a onebox?

But yeah the chat FAQ isn't very comprehensive or well-maintained

When you quoted your own message

@Zikato That's formed by a permalink to the message alone on its own line

You can get the permalink from the drop-down menu associated with each message

Right-click on the drop-down arrow and choose 'copy link' also works

https://chat.stackexchange.com/transcript/message/61428204#61428204

gives:

Ahh, so it's just a "card" for a permalink. I've tried the small reply icon in the top right corner of the message, but that only does @mention

@Zikato yep

balpha, the creator of chat rejoined Stack Overflow in May 2022, having left in March 2019

hm

I'm tired

yeah tell me about it

10x tired

@PaulWhite I'm tired

😴💤

send in the clones

@PaulWhite that reminded me of big numbers ;)

z^z
z^z^z
z^z^z^z ...

and the little known (really exploding) function TREE(n)

So, I'm not sure what I find more difficult, RegEx or XPath queries in SQL Server.

ok, its XPath for the win.

and like, why do all the Microsoft Docs pages for XML querying quote the AdventureWorks database - Would it be so hard to just have the source XML on the page, right before the XPath query, with the resulting output right after the query?

XPATH of course. It is designed to be impenetrable.

I have a book on XML written by a pre-eminent author that I have read cover-to-cover and referred to on many occasions. I still do not have a working knowledge of it.

All I remember about XPATH is that anything useful isn't implemented in SQL Server.

Thanks for confirming that it's not just me. XPath is so dense.

I've been parsing query plans (hence the XPath) looking for warnings, and came across an UnmatchedIndexes warning. Never seen that before.

apparently there is a filtered index that the optimizer would have liked to use, but couldn't because of the filter.

@HannahVernon just look in blitzcache, i wrote most anything you'd wanna check query plan xml for in there

e.g. query_plan.exist('/p:QueryPlan/p:Warnings/p:PlanAffectingConvert/@Expression[contains(., "CONVERT_IMPLICIT")]') = 1

@ErikDarling I keep thinking one day I'm going to download your procs :-)

=|

why is @PaulWhite deliberately ignoring my grade a tweet

lol

personally I'm ignoring it because I ditched Twitter

busy re-inventing plan cache queries

oy vey

Paul's probably sleeping

@ErikDarling personally I can't really learn anything without working through the stuff myself.

but I get the point - it's a "solved problem" so why re-invent it lol

are you actually learning anything doing it yourself

personally i forget everything about xpath until i need to write it again, and then i copy the last thing i did

as for XPath, no I agree I'm not really learning it. Although it is nice to have something to refer to, as you noted. I'm mostly learning useful things about the showplan xml as it relates to our workload.