The Heap™ – Consultancy ©®

7:20 AM

morning

7:52 AM

Morning

Morning

8:10 AM

Morning

@Zane The question you answered ended up in the HNQ

8:21 AM

Morning

Philᵀᴹ

9:01 AM

Morning, data da Vincis

@Philᵀᴹ Hahahaha. I didn't think there'd be THAT few jokes in that barrel

What's next?

I prefer data bach(up)s

@ypercubeᵀᴹ but then it doesn't fit op requirements: if it's not set on insert dbfiddle.uk/…

9:17 AM

@McNets Ah I ddn't notice that.

What do they want to happen if one row is set and the others not?

@Zane You could add a link to Erland Sommarskog'r article Slow in the Application, Fast in SSMS?. The article also goes into the specifics of parameterization and how program and SSMS performance will vary.

@ypercubeᵀᴹ update only those where group_id is null. Instead, what I was hoping for was that all the rows in a given INSERT statement would get the same group_id.

@McNets I commented with an improvement.

@ypercubeᵀᴹ I see, thanks

Oh, you already edited your answer, nice ;)

9:24 AM

I suppose in the meanwhile I was editing the answer you edited the fiddle

BTW, yesterday I attended this concert. palaumusica.cat/en/…

I'd rather suggest you, Daniel Hope is a really good director.

9:47 AM

I wonder if "director" should be replaced with "conductor" on that page. Could be a case of false cognates, since all three languages (English, Spanish, Catalan) have the word "director" but the meaning is not always the same in all three.

@AndriyM music director

Royal Philharmonic Orchestra announces new music director

@hot2use Ah, I see, thank you!

Equally interesting the various meanings of conductor

Conductor

Conductor or conduction may refer to: == Human roles == Conductor (music), a person who leads a musical ensemble The visible gestures of a conductor are known as conducting Conductor (rail), a member of the crew of a train or tram Bus conductor, a person who checks passengers' tickets on a bus Conductor (military appointment), a senior Warrant Officer appointment in the Royal Logistic Corps and its predecessors == Mathematics == Conductor (ring theory), an ideal of a ring that measures how far it is from being integrally closed Conductor of an abelian variety, a description of its bad reduction...

@TomV how did you get the Duck?

10:07 AM

@ypercubeᵀᴹ it's in the meta post

it's a bit silly really

start typing an question and then discard the draft

@PaulWhite RAC is a shared-disk architecture. You can scale out writes (to a certain extent) by partitioning storage across multiple SAN controllers though.

Paul White

Thanks

Back in the Jurassic period, Sun used to make two storage units: T3 and A5100/5200. A T3 had a SAN controller local to the shelf and some disks. A5100s/A5200s were fibre channel JBODs. Solaris had very good software RAID.

There was also a logical volume manager called Veritas that folks used to use on this setup. Between this tech you could wrangle a large number of slices of data across storage controllers fairly easily.

Third party SANs - typically EMC Symmetrix although some others were used - were also quite popular on this type of setup.

You couldn't use JBODs as shared storage - they only supported FCAL, which is not switchable. However, they were quite widely used on data warehousing applications as they were much faster than SAN controllers, and the software RAID, partitioning functionality on Oracle and logical volume management features of Veritas made it feasible to wrangle a large number of disks bareback across an estate of JBODs.

I think Sun also used to sell re-badged Hitachi(?) SAN systems under their own label.

However, this is all a bit dimly remembered as this was current tech about 15 or 20 years ago.

Back in the days of 4.5GB or 9GB disks it wasn't uncommon to have estates with many hundreds of spindles on these setups. I remember reading somewhere about a setup with 6,000 disks on it.

Colin 't Hart

Haha, I'm now wearing the Still Fresh hat here :-)

@ConcernedOfTunbridgeWells I vaguely remember installing and configuring both Veritas file system and Veritas volume manager.

10:22 AM

I'm pretty sure if you wind the clock back a bit further you can find similar tech being used on VMS and IBM mainframes.

Colin 't Hart

One of the storage boxes had the ability to be split into two. We rackmounted them between pairs of development servers and shared half to each.

@Colin'tHart A lot of fibre channel JBODs can split the backplane into two separate loops.

Colin 't Hart

(Y)

I used to own a distressingly large number of fibre channel JBODs.

They turned out to be fairly useless as I moved from working with Oracle to SQL Server, and software RAID is pants on Windows.

After that I could do what I needed by stuffing some SCSI disks onto a HP workstation. Then i could do what I needed on a laptop with a SSD.

Now I can build a useable ETL development box out of a secondhand thinkpad you can buy for a few hundred quid off Ebay and a SSD.

@ConcernedOfTunbridgeWells I find the MSDN license I get via work very useful. Free Azure credit and all that

10:34 AM

@George.Palacios I did have an MSDN subscription until a couple of years ago. At one point I upgraded it to premium, which was a colossal waste of money. For a while I was working as a perm, so I cancelled the subscription. Now I'm back contracting again I might spin up a MSDN pro subscription but I haven't needed it yet.

11:14 AM

@ConcernedOfTunbridgeWells pro comes with a $50 monthly credit on Azure

12:08 PM

> And then there is the Linux jumper, which comes in the form of a ball of wool and some knitting needles because you do know how to knit, right? Proper Linux fans will simply get given the sheep and be forced to knit the thing with their teeth, because anything easier is for noobs.

theregister.co.uk/AMP/2018/12/14/…

@MaxVernon Hahahah that is a wonderful article

1:48 PM

@jadarnel27 gotcha. Thanks that makes sense as to why I couldn't push it over there.

@TomV cool

2:16 PM

@ypercubeᵀᴹ I'm torn about that question

On one hand it's very low quality and the user clearly hasn't got the pre-requisite knowledge

On the other hand it could be easily turned into "How many rows can SQL Server Process in a single INSERT statement"

The answer to which would be "Limited by available local resources"

@George.Palacios yeah.

I'm gonna add an answer on that basis

If it isn't relevant I'll just delete it

Santa Claus is coming to town (Children version)

►

For some inknown reason, that question made think of this song ...

@George.Palacios It's more limited by time I think

Even with few resources the query will complete

at some ponit

point

Not if theres not enough disk space

I assume local resources include that

2:23 PM

a combination maybe, it could error out if tempdb is full yes

Well or you fill the data file for the database table you're inserting into and autogrowth isn't enabled

On another note - 2k rep :)

@George.Palacios We'll I'll look forward to reading it

@Zane I've sorted it and editted the original question to give it a bit more usefulness

@George.Palacios Looks like that answered his question as well so that's good..

@Zane Yeah. Good post to mark my move into 2k+ rep :)

I was then immediately able to edit it to improve it too haha

2:30 PM

lol

Basically a detailed version of "huh, what. No there isn't a hard limit on inserts"

@Zane That's the one hahaha

@Zane In fact I might just edit the answer ;)

@Zane Your wording is far better

hahaha

@George.Palacios Do you think it needs to be clarified that the phrase "enough local storage" in your answer includes not only the space needed to store the data but also the space to log the operation? I mean, it's not immediately clear either from the original quote or from your paraphrase, and as the OP is giving 400 million rows as an example, that could be a material point.

@AndriyM Yeah I think you're right. I'll start a list on the answer - feel free to add to it after

@AndriyM Done

Thanks!

2:45 PM

Hey what community members can delete other peoples comments? Is it an earned privilege or is it a moderator function?

@George.Palacios only moderators. The rest can only flag them.

@ypercubeᵀᴹ Okay thanks.

In a way, you can delete someone's comment, precisely by flagging

"No longer needed" can trigger automatic deletion

@AndriyM Do you know when it will/wont?

Q: Who has the power to delete a comment?

Not off the top of my head, but I'll try and see what Meta says about it...

29

I posted a comment on the following question. My comment was: You will have to work on your [accept rate](http://meta.stackexchange.com/questions/5234/how-does-accepting-an-answer-work). Currently it's catastrophic. Zero as in a singularity inside a black hole. This comment was deleted by someo...

support faq comments comment-replies

2:50 PM

159

Q: How do comments work?

Across the Stack Exchange network you may leave comments on a question or answer. How do comments work? Who can post comments? Who can edit comments? How can I format and link in comments? Who can delete comments? When should comments be deleted? What are automatic comments? How can I link to c...

> Comments that are flagged by multiple users are deleted automatically. The number of flags needed is usually based on the comment's score. It currently takes "3 + (Score / 3)" flags (rounded up) to delete a comment. Comments containing certain keywords can be deleted with a single flag.

3:05 PM

Ah excellent.

3:43 PM

@TomV how you got this Mario hat?

Secret hats for the cool kids program

is it mean your own commnets?

@McNets No it means not your own post

Oh dang. I gotta be close on that.

@George.Palacios but does it mean your own comments, I suppose. You cannot delete others comments

3:57 PM

@McNets Oh sorry. Yeah it does

Your own comments on someone elses post.

Not sure how about other sites but that one is a very DBA.SE-friendly hat

I mean, cleaning up your own comments... I know a mod who would certainly approve of that

7

4:22 PM

@AndriyM Who cares about approval - we get a hat for it now!

@George.Palacios yah, I loved it!

@MaxVernon I particularly liked the Linux section. I don't know why they didn't just directly say the second part was for Gentoo users.

I loved the knitting with their teeth bit. I thought that was pretty genius. I've often felt like I needed to become a sheep farmer just so I could figure out how to put on a jumper.

@MaxVernon That's the bit I meant hahaha. They should have said that's for Gentoo or Linux from scratch users

@George.Palacios agreed!

4:27 PM

@MaxVernon The Apple bit was great too

@George.Palacios yah, I lolled out loud. If that's even possible. I mean how do you laugh-out-loud-out-loud?

jadarnel27

5:10 PM

This is probably dumb, but I don't get the connection between the comment cleanup actions and Mario.

I'm also totally stumped as to what got me the "Propel Thyself" secret hat.

5:58 PM

@Zane glad you said cool kids and not special kids

6:12 PM

Has the hyphen-a on it's-a me! any special meaning?

Perhaps the idea is to emulate Italian accent

I'm trying to find the connection between this hat and 'deleting comments'

6:27 PM

Found a problem at work today with a process using the old join syntax causing a cartesian merge in oracle. Good grief I hate that syntax it leads to constant errors.

6:47 PM

@McNets It's pure speculation but here goes. You see a comment of yours and you say, "It's me [who has posted it]". Or you are deleting your own comment and saying, "It's me [deleting my comment]". I guess they wanted a little something that could be associated in any way both with the intended action and with some recognisable hat, so someone thought of the "it's-a me" phrase associated with a famous character with a hat.

Evan Carroll

7:18 PM

I data with free bases. Like serious companies.

Guess what. ANOTHER PROJECT WILL SOON BE IN POSTGRESQL

Dude, Oracle and Microsoft SQL are sooo fucked. I'm going to make PostgreSQL bigger than Jesus in 2019.

8:13 PM

@EvanCarroll I imagine they'll likely do fine for themselves lol

So in sql server i can just type select getdate() and it will return the value is there a way to do this in oracle?

I'm just trying to understand how oracle is handling this date calculation.

8:26 PM

@Zane sysdate?

@Zane in some ways it's better — more explicit. never coming back though

right but if i type select sysdate I get an error asking me to specify a table.

jadarnel27

@Zane You can't do a select on it's own, but there's a special table called "dual" that you can use for stuff like that.

select sysdate from dual

@Zane check the db<>fiddle link in my message…

Thank you!

jadarnel27

Haha I didn't look beyond your link either, @Jack 🤦‍♂️

8:31 PM

:)

lol that's what I get for making assumptions.

I just figured it went to the documentation on sysdate.

it was a pretty lazy comment tbh, not surprised you thought that

@jadarnel27 DUAL is very special

sometimes it has more columns

I have much to learn in the ways of oracle.

It's a foreign land.

Alright folks I'm out.

9:34 PM

@George.Palacios I'm not sure using RTRIM helps in that case. LEN effectively returns the result as though RTRIM had been applied. Now you are applying it explicitly and the result will be the same.

10:11 PM

@AndriyM in that case RTRIM on the column in the first position inside the function should work right?

Trim the column we're applying the function to, before applying for the substring function