« first day (2884 days earlier)      last day (2281 days later) » 

jadarnel27
jadarnel27
00:13
Have you tried not asking poorly received questions?
Evan Carroll
Evan Carroll
They weren't poorly received...
 
8 hours later…
George.Palacios
George.Palacios
08:08
Morning
McNets
McNets
08:33
Morning
Peter Vandivier
Peter Vandivier
08:56
Morning
hot2use
hot2use
Morning
@McNets Do you still think it's a duplicate?
0
Q: SQL SELECT Parent-Child with SORT

Petr ŠimůnekI have a simple, one level parent child relation table, with following columns: ID_Asset| Parent_ID_Asset | ProductTitle I need output grouped by Parent followed by children, and also sorted by Parent and Children Name. My attempts in the fiddle. The parent must be first. See here for details...

t-sql order-by
McNets
McNets
@hot2use No, I retracted my vote to close
Andriy M
Andriy M
Morning
Philᵀᴹ
Philᵀᴹ
@EvanCarroll Banned where?
McNets
McNets
09:33
Hi McNets, thank you for your time. I have already tested using COALESCE, the problem is the ProductTitle column needs to be sorted alphabetically as well, the ADONIS group needs to be on top. — Petr Šimůnek 4 mins ago
@hot2use not clear enough ^^^^
ConcernedOfTunbridgeWells
ConcernedOfTunbridgeWells
09:44
Morning all
Andriy M
Andriy M
@McNets The link in your answer is the same as in the question. Rextester doesn't generate a new link automatically, so you may have tested your solution but ended up copying the same link and thus your answer is referencing the OP's fiddle. That could be what confused the OP, although I'm not entirely sure.
ypercubeᵀᴹ
ypercubeᵀᴹ
@McNets I think they want this: rextester.com/edit/PPCHG20007
McNets
McNets
10:05
@AndriyM Sorry, I haven't used rextester for a long time
@ypercubeᵀᴹ will you post an answer?
Andriy M
Andriy M
@ypercubeᵀᴹ It doesn't show the right sorting order for the fragment the OP specified in their question.
I think McNets's solution should work. Only there's no need to do COALESCE(Parent_ID_Asset, '') in the ORDER BY, simply Parent_ID_Asset can do just as well. Also the CASE can be replaced with the equivalent COALESCE expression for conciseness 
SELECT
    ID_Asset,
    Parent_ID_Asset,
    ProductTitle
FROM
    Test
ORDER BY
    COALESCE(Parent_ID_Asset, ID_Asset),
    Parent_ID_Asset,
    ProductTitle;
I'm not posting it because it's the same solution, just two expressions slightly modified without changing the result.
McNets
McNets
dbfiddle.uk/…
But I think OP expects to be ordered by Parent's title
Andriy M
Andriy M
10:22
They shouldn't have limited their example output to just "the relevant part". The actual relevant part is apparently the entire output.
MAX(CASE WHEN Parent_ID_Asset IS NULL THEN ProductTitle END) OVER (PARTITION BY COALESCE(Parent_ID_Asset, ID_Asset)) as the first sorting term, keeping all the others too.
McNets
McNets
@AndriyM dbfiddle.uk/…
Andriy M
Andriy M
10:42
@McNets dbfiddle.uk/…
or this, to avoid the warning: dbfiddle.uk/…
McNets
McNets
@AndriyM which better?
hot2use
hot2use
@McNets Yeah. Looks like it might take a lot of grooming until it works. Question is: Is it worth it?
McNets
McNets
@hot2use that's true
Andriy M
Andriy M
@McNets You are doing an extra table scan to get the parent titles. My understanding is that using window aggregation you can avoid that.
McNets
McNets
@AndriyM Ok, would you mind if I post your solution?
Andriy M
Andriy M
10:51
@McNets If I felt a little bit more authoritative, I would actually insist that you do :)
McNets
McNets
@AndriyM ;-)
 
2 hours later…
hot2use
hot2use
13:04
@MaxVernon still happy with pi-hole?
Andriy M
Andriy M
Thank you Paul, that was really nice.
Max Vernon
Max Vernon
13:52
@hot2use let's just say I'm glad I know how to turn wi-fi off on my phone. But, overall, it works really well, and is super easy to setup. We've noticed some issues with certain sites not working as expected, presumably due to some scripts being DNS blackholed by Pi-Hole - it can be a little difficult to determine which urls need to be whitelisted to fix those issues. Overall, it feels like being behind a somewhat restrictive proxy.
Paul White
Paul White
@AndriyM no worries 🙂
 
2 hours later…
McNets
McNets
15:50
kill it ^^^^
George.Palacios
George.Palacios
Oh Gav.
Zane
Zane
16:03
Gonna have to start using some Oracle. Excited to expand my knowledge into that pool
Evan Carroll
Evan Carroll
16:29
@Philᵀᴹ SuperUser.
Philᵀᴹ
Philᵀᴹ
"This account is temporarily suspended because of low-quality contributions. The suspension period ends in 6 days.". Oh dear
-5
Q: How can I render a Clippy with text using Radare?

Evan CarrollFrom the Radare.Org Facebook page Clippy is now available in r2! But the link to radare.tv is broke. I was talking to someone else at the Walmart checkout aisle and they were telling me about this too. How can I use Clippy in Radare?

radare
Max Vernon
Max Vernon
"Walmart checkout aisle" - nice.
George.Palacios
George.Palacios
HAhahahaha the walmart checkout isle
that's just the best post
@EvanCarroll Is posting the code once not good enough for you Evan?
Sometimes when I'm feeling naughty I like to post the code 3 times
Evan Carroll
Evan Carroll
17:00
That guy just likes to attack me.
do you see something different between both executions?
Clearly there is!
perhaps there was something else I was demonstrating... hrm...?
you can edit that, I unfortuantely can't yet, because I'm banned.
But to answer the question, Radare's Clippy has emotions, and you can't control them. So if you get the wrong emotion, you just gottra reroll and do it again
And, yes, I use this. My MOTD is set with Radare.
Also, is "In addition, you should provide a link to back up your answer." even fair. I provided actual code, what is my link supposed to be to?
I don't know how the SU mods make it. SU and AU has the biggest jerks on the network moderating those sites.
I need an to create a site www.letmediffthatforyou.com =) like lmgtfy
Paul White
Paul White
17
Q: Time for some more swag!

JNatOn occasion of our anniversary celebrations, we offered some cheese boards a while back. If you were late for that, though, no sweat! You’re just in time for another limited edition super special swag contest! This is the bit where you go “It’s about time, isn’t it?” To which I’ll reply with “we...

discussion featured fun 10th-anniversary
Evan Carroll
Evan Carroll
@PaulWhite meta.stackexchange.com/a/318642/157251
Paul White
Paul White
@EvanCarroll ha!
amazing that didn't get widespread support
Evan Carroll
Evan Carroll
I know. Haters gunna hate.
Evan Carroll
Evan Carroll
17:35
@PaulWhite meta.stackexchange.com/a/318927/157251
hot2use
hot2use
Hi Evan. I just wanted to wish you a Happy Christmas before you are left. :-)
Evan Carroll
Evan Carroll
hahahah merry happy Christmas to you too.
 
1 hour later…
Zane
Zane
18:52
yikes first problem here is this hosed availability group.
Forrest
Forrest
sounds fun
Zane
Zane
Something has messed up the cluster service on one of the boxes and someone has just tried to shut down the AG and blow away the clustering in general. This is making the AG throw a major fit since it doesn't know where it stands due to the server never returning.
Tom V
Tom V
23 hours ago, by Zane
I'm even going to get to solve an AG problem on day 1
Famous last words
3
jadarnel27
jadarnel27
Classic availability groups.
JzInqXc9Dg
JzInqXc9Dg
19:17
@billinkc can you elaborate any on the "nightmare" that was caused by that server that was renamed?
I'm going to do the fix tonight and both I and my Euro colleague believe there should be little to no other systems effected. hoping that is actually true :)
billinkc
billinkc
@JzInqXc9Dg Nothing specific. It was a decade and 7(?) employers ago. All I remember was there was how things worked on every other box in the organization and then there was that box. Which was, of course, production
JzInqXc9Dg
JzInqXc9Dg
hahah
ok cool
good ole "that box"
Master Database
Master Database
0
Q: Huge number of visits

Rick JamesIn the first 24 hours after posting Identity column re-seed: when it is necessary? , garnered about 700 Visits. Was it real? Was it some form of hacking? (I'm not complaining; my Answer got a lot of upvotes at the same time.)

discussion moderation up-votes
jadarnel27
jadarnel27
@JzInqXc9Dg I can't remember all the details about your situation, but I had a client that renamed their Windows Server that was hosting a SQL Server instance, and they had lots of problems with it until they followed the steps in this MS Docs article.
Max Vernon
Max Vernon
in DROP QUESTION queue;, 3 hours ago, by Max Vernon
anyone have an opinion on this - decent number of views, and probably an answer could be added to show how to use DBCC PAGE with the page number, but what help is that likely to be for a future visitor? I mean, other than sending them down the path of looking at something they ostensibly have no idea about.
jadarnel27
jadarnel27
19:30
In particular, running the sp_dropserver / sp_addserver commands and then restarting the instance.
JzInqXc9Dg
JzInqXc9Dg
^ yes that is precisely what I'm going to do
Zane
Zane
@TomV bwahahaha. I got it. Just hadn't worked with AG's before. Both sides needed to know it was over in order for the DB's to move on.
@billinkc what's up homie!
jadarnel27
jadarnel27
@JzInqXc9Dg Okay, awesome. The only issues they had during that process were with remote logins / replication - and the solutions were covered in that same article.
billinkc
billinkc
@Zane Nada. Congrats on the new gig, I hope it's more enjoyable than the last
jadarnel27
jadarnel27
To be more specific about "lots of problems," they had linked servers and were using "four part names" to refer to objects in different instances / databases. And resolution was failing because of the mismatch.
JzInqXc9Dg
JzInqXc9Dg
19:37
got it, that makes sense
that is generally what i'm expecting..
Max Vernon
Max Vernon
@jadarnel27 DNS CNAME entries might help alleviate that pain.
JzInqXc9Dg
JzInqXc9Dg
im just not physically there to remedy anything and ill be doing it at about 4am their time - but they have been tipped off and will be ready to firefight if need be! :)
Zane
Zane
@billinkc well I'm able to use the internet effectively enough that I can come here again.
billinkc
billinkc
I'll talk to your supervisor, see if we can't clear up that glitch
Zane
Zane
Ha! lol from what I've noticed the culture here isn't as evil as the one at well.s
However it is only my second day.
jadarnel27
jadarnel27
19:50
@MaxVernon Heh, that's what they did for the first server rename a year or so prior! When they needed to do another rename (god knows why), they didn't want to support multiple CNAME entries all going to the new (third) name.
Andriy M
Andriy M
23 hours ago, by Zane
> However it is only my second day.
Zane
Zane
lol
Andriy M
Andriy M
inb4 :)
Tom V
Tom V
@JzInqXc9Dg I'm physically close enough but 4 am our time... Nah thanks
jadarnel27
jadarnel27
Slacker.
Tom V
Tom V
19:58
Sounds like it's Brussels which is an hour extra commute
I could recommend people though not in a public chat
jadarnel27
jadarnel27
@Zane in case you haven't seen this, since you're supporting AGs now, this is a pretty neat sounding new tool offered by Microsoft support: Failover Detection Utility – Availability Group Failover Analysis Made Easy
JzInqXc9Dg
JzInqXc9Dg
@TomV all good Tom. they are able to handle anything that happens on site
and yes, near brussels
Max Vernon
Max Vernon
20:13
any chance of a re-open ?
there is an answer
Andriy M
Andriy M
On a different note:
Not only is this link-only, it's also irrelevant, because the question is about SQL Server, not MySQL. Are you here to just promote your site? — Andriy M 1 min ago
The user is sort of active on SO but their latest SO answer is very similar
-1
A: sql server trigger

Abhishek SharmaYou can check triggers in mysql

Tom V
Tom V
20:33
@MaxVernon the op comment doesn't encourage me
JzInqXc9Dg
JzInqXc9Dg
" any connections that used the old computer name must connect by using the new name." -> well, as far as I can tell the original renaming of the server must have been done before anything else was connected. everything seems to already be using the "new name"
that seems really weird compared to all the documentation I've read - but maybe also indicates this should be a smooth operation???
maybe all the docs are assuming you are renaming a server in which connections have already been made to what will become the old name
Andriy M
Andriy M
20:47
@MaxVernon Re-opened
It's curious how it took only four votes to delete the SO answer I linked above. Even curiouser is that only one of them (mine) was a Delete vote, the other three were Recommend Deletion.
Something to do with the answer score at the time of voting, perhaps
Max Vernon
Max Vernon
21:08
@TomV yah, I flagged that comment. It's not very friendly. ;-)
@AndriyM cheers
McNets
McNets
user image
It seems the test has started
McNets
McNets
22:06
0
Q: What are the origins of the Identity Column?

BobWho were the first creators of the Identity column? What problem were those creators originally trying to solve? Is there a story behind it?

database-design identity
And another one, all new contributors
@PaulWhite are you there?
billinkc
billinkc
Are you there Paul? It's me, McNets
3
Are You There God? It's Me, Margaret.
Are You There God? It's Me, Margaret is a 1970 book by Judy Blume, typically categorized as a young adult novel, about a sixth-grade girl who has grown up without a religious affiliation, due to her parents' interfaith marriage. The novel explores her quest for a single religion. Margaret also confronts typical issues faced by early adolescent girls going through puberty, such as buying her first bra, having her first period, and feeling attracted to certain boys. The novel has been frequently challenged since the 1980s due to its frank discussions of sexual and religious topics. == Background... ==

« first day (2884 days earlier)      last day (2281 days later) »