The Heap™ – Consultancy ©®

« first day (4188 days earlier) ← previous day next day → last day (978 days later) »

Hannah Vernon

04:56

@swasheck hey nice to see you!

@JamesLupolt hellloooo!

John K. N.

05:46

@JamesLupolt Hello James

Welcome Back.

Zikato

Morning;

John K. N.

Morning

@Zikato That ain't NoSQL statement

Zikato

It's practice

McNets

06:41

Morning

1 hour later…

Paul White

07:50

@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.

Vérace - Слава Україні

08:04

A chairde - Morning all!

Paul White

08:16

@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.

Vérace - Слава Україні

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?

ypercubeᵀᴹ

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

Paul White

@ypercubeᵀᴹ Yep

ypercubeᵀᴹ

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

Paul White

12 mins ago, by Paul White

@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.

@ypercubeᵀᴹ same

Zikato

08:33

Is there any documentation for Stack chat? For example, how do you quote?
I only found this https://chat.stackexchange.com/faq

Paul White

@Zikato By "quote" are you referring to:

Q: Add "> text" quote markup to chat FAQ

It's possible to quote a block of text in chat by preceding it with a greater-than sign and a space: > I've got a lovely bunch of coconuts This produces a nice vertical dotted line in the message. However, that's not specified in the chat FAQ. I think it should be added.

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

Zikato

08:53

When you quoted your own message

Paul White

09:09

@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:

16 mins ago, by Zikato

When you quoted your own message

Zikato

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

Paul White

@Zikato yep

Paul White

09:35

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

balpha, Berlin, Germany

152k 41 480 651

status-completed bug chat feature-request support discussion markdown

Zikato

That's around the time I've started using the chat.
Coincidence? I think not!

Paul White

4 hours later…

John K. N.

13:48

I'm tired

Paul White

yeah tell me about it

Erik Darling

14:00

10x tired

Lamak

@PaulWhite I'm tired

Paul White

😴💤

Erik Darling

send in the clones

2 hours later…

ypercubeᵀᴹ

15:35

@PaulWhite that reminded me of big numbers ;)

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

ypercubeᵀᴹ

16:13

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

3 hours later…

Hannah Vernon

18:52

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?

Paul White

19:33

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.

Hannah Vernon

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.

Erik Darling

20:06

@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

Hannah Vernon

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

Erik Darling

why is @PaulWhite deliberately ignoring my grade a tweet

Hannah Vernon

lol

personally I'm ignoring it because I ditched Twitter

Erik Darling

busy re-inventing plan cache queries

oy vey

Hannah Vernon

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

Erik Darling

20:13

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

Hannah Vernon

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.

« first day (4188 days earlier) ← previous day next day → last day (978 days later) »

all rooms