The Heap™ – Consultancy ©®

ypercube

06:56

@MarinaDunst It has answered your question. And added a few more points for you (and others that may ask a similar question) to be aware of. Nothing mean or arrogant, the opposite I'd say. (the last sentence advising to change the question was removed) — ypercube 1 min ago

Tried to kind of lower the heat there...

Tom V

09:52

@ypercube I had a go at addressing the questions :)

Tom V

10:13

and it's gone :)

Jack Douglas

"To be honest, a lot of mean and arrogant people here." not at all: this site has a great reputation for being one of the most friendly an welcoming, and exceptions are rare. This is simply not a good question for this site — and your attitude so far is also not a good fit for our site, so please consider whether you a) want to stop contributing, or b) whether you want to change your attitude. The basic issue is that the folk here are experts and you obviously (from your question) are not, and that you don't recognize that. — Jack Douglas ♦ 1 min ago

2

Colin 't Hart

@JackDouglas Dang, the question is gone already!

Jack Douglas

@Colin'tHart yes, no-one flagged it but I thought it was unlikely to produce a useful outcome

Colin 't Hart

(Y)

Tom V

10:35

too bad it wasn't deleted 15 minutes earlier, could've saved me 5 minutes of typing :)

dezso

11:07

@JackDouglas that's possibly the harshest comment I've ever seen from you, Jack

James Lupolt

11:29

I'm wonder what's driving the perception that mean and arrogant people are here. I hope I haven't contributed.

Maybe comments like this?

Forgive my French, but I need to know as it is important for how detailed my answer will be: You don't have the slightest clue about system administration and use a Windows system ? — Markus W Mahlberg 2 hours ago

dezso

@JamesLupolt flagged it as offensive

Jack Douglas

12:30

@dezso too harsh?

dezso

12:55

@JackDouglas that's impossible, considering it's your comment ;)

Jack Douglas

oh good!

ypercube

13:49

@dezso how did you guys setup replication with Docker?

I'm stomped at the moment

dezso

@ypercube github.com/zalando/patroni

and some other stuff, the whole ecosystem is quite complex

at least, it provides automatic failover and whatever

github.com/zalando/spilo is possibly a better starting point

and Docker is just a side effect

(I'm not that much into the technical details on these, but can ask the guys)

ypercube

14:14

@dezso thnx

both look quite complicated

Tom V

14:43

@JamesLupolt remember the 3PAR with the write performance? I got a chance to have a look at it

They weren't lying when they said 'all flash', all four disks yes :D

not sure why they would be running that setup

dezso

@MarkusWMahlberg in the optimal case, you should write an answer that is detailed enough to answer the question, and if there are other points which should be noted but would render the answer too long, include links to relevant resources. Also, I'd suggest being careful with your wording - your question implicates the answer in a slightly unfriendly manner. (In the latter point I might be wrong as I am no native speaker of English.) — dezso 10 secs ago

Tom V

15:21

@Phrancis I think he should be good to go

James Lupolt

@TomV Do you know the models for the disks? My guess is they are 'enterprise-grade' flash and quite expensive, like 3-6k EUR each.

Good to know you got more info about the setup

Tom V

@JamesLupolt Most likely, I don't know the models but they got them from the HP partner that sold them the stuff, so they must be HP 'officially approved' I suppose

James Lupolt

@dezso Thanks for trying to address that. In this case I can't tell that the person asking the question was offended, but I can see why someone might have been.

It certainly sounds unfriendly, and far more indelicate than necessary.

Tom V

@JamesLupolt I think they will be surprised the setup actually has slower writes than their old EVA

I got the chance to test that one over the weekend

James Lupolt

Did they already buy this, or is it just for evaluation?

Tom V

15:36

They bought it

James Lupolt

Oops.

Tom V

to be honest, I don't understand that customer, they spend cash like it's nothing and don't do any thinking upfront

James Lupolt

It's a little strange that they didn't get something better if they are just throwing money around.

Vendor relationships I guess.

dezso

15:48

@TomV I have some stuff for them to sell

Tom V

@dezso Everybody does :)

dezso

@TomV OK, then I send my stuff to you, you sell it to them and you get 20%, deal?

Tom V

I joined them on a trip to DELL in Paris where they got some demonstrations and presentations and managed to empty the DELL sales guy's AMEX that evening

Max Vernon

oh man, this takes "row by agonizing row" to a whole new level. Step through the records one at a time, creating a Word document for each.

dezso

@dezso I don't see the point in hiding facts behind friendly words – while it might sound friendly, it isn't really helpful. Writing an answer based on the knowledge of the OP on the other hand is, and it does not help at all if I had to assume wrong preconditions. You might want to have a look at my profile – I am fully aware of how to write answers, some of them were even deemed helpful enough. Since Dmytro on the other hand already wrote an answer (I suspect based on the information given by OP in answer to my question), I do not see the point in reinventing the wheel. — Markus W Mahlberg 1 min ago

Tom V

15:53

@MaxVernon yeah I saw (and edited that)

I think he should go for mail merge

Phil

I think he should move away from the keyboard and go to the pub

Tom V

@Phil Unless he just got back from the pub and got his idea there

James Lupolt

16:10

@dezso Yeah, I saw that. Thought your reply was nice.

He does have a lot of useful answers on MongoDB questions, in many cases answers with 0-2 votes on questions with 0-2 votes.

There actually seems to be a lot of useful Mongo content on the site with few votes.

dezso

@JamesLupolt it's possibly because even its users don't consider Mongo a DB :D

Erik

@JackDouglas Yeah I probably should have been more aggressive about flagging that one. I had high hopes the OP would see the light. I was probably one of the jerks or the jerk, she was talking about too. Live and learn....

dezso

I cannot even tell if a MongoDB post is useful or not, therefore have no chance to vote

Erik

or maybe I'm thinking about a different question....

@dezso same here I can only filter out blatant garbage.

James Lupolt

On some of them I have no idea. I've never worked with it, just taken a few MongoDB classes online and read some things.

swasheck

16:23

> Go numeric constants have arbitrary precision.

dezso

@swasheck sure

ConcernedOfTunbridgeWells

16:40

4

Zane

Hey @MaxVernon could you include this from BOL in your answer" TRUNCATEONLY
Releases all free space at the end of the file to the operating system but does not perform any page movement inside the file. The data file is shrunk only to the last allocated extent. target_percent is ignored if specified with TRUNCATEONLY.
TRUNCATEONLY affects the log file. To truncate only the data file, use DBCC SHRINKFILE."

Max Vernon

@Zane yah, good point.

Zane

Or maybe just the link to BOL msdn.microsoft.com/en-us/library/ms190488.aspx

dezso

@ConcernedOfTunbridgeWells I've already ordered both of them

jcolebrand

enterprisecraftsmanship.com/2015/11/11/… straight out of my DBWeekly email .. when will people understand that SQL is a 4GL, not a 3GL like C# or F#

Mark Sinkinson

16:57

@jcolebrand There is so much wrong with that code...

Max Vernon

@jcolebrand omg - could this be any more wrong?

> Imagine how hard it would be to encode this business rule using SQL: “If the person is a teacher and their class is the best in the school, then increase their salary by 20% and assign 2 other teachers for mentorship”.

I’m not saying it’s impossible (it surely is!), but the level of effort required to implement and, more importantly, to support and maintain such a solution is much higher than it is using regular OO (or FP) languages.

jcolebrand

@MaxVernon yes, it could be :p

Max Vernon

@jcolebrand true dat. He could be advocating using a key:value store instead of an RDBMS.

jcolebrand

lol

Zane

@jcolebrand this person is a knob.

It's not SQL's fault his query sucks.

jcolebrand

16:59

No, a doorknob would be much more useful

@Zane it's also not the fault of most of the inventors of software languages that he doesn't understand set theory at all, but ya know ..

Zane

"The reason for that is simple: SQL is not designed for the work with individual rows." Yeah because I can apply my logic to an entire set. I don't want to do things one at a time.

Gah! that article made me angry.

Max Vernon

I love how Greg Jorgensen literally flayed his post.

@Zane me too.

I wonder if he actually thinks that way, or if he's trolling for traffic.

Max Vernon

17:24

this makes me think I'm missing something

Max Vernon

17:40

that is one strange pivoted unpivot. very weird.

mmarie

17:58

Hi, Heap

How is everyone?

Lamak

hi mmarie

Tom V

18:52

@MaxVernon I was trying a hammer because the screw didn't go in

I was converting because a "cannot convert varchar to int" error, and I made that to see if it would fix. But the error was the 3rd line ( now using * it runs great ) because we are receiving Invalid column name 'descQuestao'. Thank you very much. A little attention problem by my part. — Rafael Piccinelli 1 hour ago

James Lupolt

@jcolebrand Was that in last week's?

jcolebrand

@JamesLupolt pretty sure it was today's ... I just thumbed through it today, I'll check my bin

James Lupolt

Ah OK

I didn't know there was one today

Are you talking about the Database Weekly newsletter that Redgate and SQLServerCentral put out?

jcolebrand

dbweekly.com/issues/79

James Lupolt

Thanks, I didn't know about this thing

'SQL is about OLAP' seems like a really odd perspective

I've never seen this claim before

Does that mean that we need to start calling RDBMSs 'NoOLTP databases'?

Zane

19:23

@mmarie Fantastic. Other than work.

Max Vernon

@mmarie Absolutely Fantastic. Friday Afternoon. You?!

@TomV I still don't understand what he's trying to do. Even though I keep looking at it expecting to understand it, I just don't. Not sure if that makes me stupid, or not.

Tom V

@MaxVernon On friday evening I'm not even trying to parse that :)

Zane

@MaxVernon his article on SQL vs NOSQL is equally infuriating.

Max Vernon

@Zane I immediately closed that tab, refusing to read any more.

Zane

Drawback for RDBMS Not scalable. Bull Shit.

Max Vernon

19:39

@Zane yah, tell it to StackExchange that SQL Server is not scalable.

Zane

@MaxVernon Exactly.

Also clearly define what that means or GTFO. Don't just throw around some buzzwords. Scalability is different to every single user.

Max Vernon

A little Friday Afternoon Metal. At War With Satan, by Venom. 1992. YAH!

Zane

It's especially annoying because at some point in my career somebody is going to cite this yahoo as the reason they don't keep any "Business Logic" in their DB and they are looping through every single row to make a basic calculation.

Max Vernon

@Zane yah. He's going to become the defacto go-to guy for those RBAR morons.

"I do it in code because I am betterz than the RDBMS"

mmarie

@MaxVernon I'm good. I was in Toledo all week for a client and getting @billinkc initiated to our company.

Now I'm home and the maid service just finished cleaning my house

Max Vernon

19:47

@mmarie Gotta love coming home to a clean house. How was Mr. inkc? Well, I trust?

or I suppose that might be better said as "Mr. inkfc"

billinkc

Just Mr KFC. In is my middle name

2

Max Vernon

@billinkc Nice!

billinkc

It's a Lush channel from soma.fm afternoon on this end

Zane

It's like that article my boss read about using GUIDS. They ended up using them for all keys in their OLTP and it was a disaster.

billinkc

Caught someone clustering on varbinary(20)

mmarie

19:50

@billinkc :-)

This will be an adventure

billinkc

Fortunately, we were at the point where I could say nope nope nope nope

mmarie

I'm counting on you to stop the dumb

billinkc

Stop, in the name of KFC. Before you break my database

Think it oooooh-ver

Lamak

@mmarie that sounds contraproducent

mmarie

@Lamak In this case, it is not counterproductive

billinkc

19:55

Contraceptive?

Lamak

@mmarie yeah, I like to make up words when talking about @billinkc

bluefeet

hi heapers

billinkc

Don't make me espan~olize on tu

@bluefeet Howdy

Lamak

@bluefeet hi

@billinkc ñ

I like that letter

billinkc

Nyop

mmarie

19:56

Hi, @bluefeet

Max Vernon

@bluefeet Yo! Blue One!

bluefeet

did my saying hi scare everyone away?

mmarie

I'm here, just busy executing BIML

James Lupolt

@MaxVernon Nice one, one of my favorite albums around 1995

I'm looking at questions and eating dinner

Max Vernon

20:12

@JamesLupolt I'm looking at dinner and eating questions.

(not really; just thought it sounds cool)

billinkc

20:35

I'm looking at eating and questioning dinner

mmarie

liar

Hi, @swasheck. I see you haven't died from a blood clot yet

billinkc

Mores the pity

swasheck

not for lack of trying

billinkc

attaboy

swasheck

you're such an encourager

Tom V

20:43

in The 2nd Monitor, 4 mins ago, by Tom V

I mostly pitied Mats mug since his hobby is reviewing vba, I mean What The F*ck

gneheheh

Max Vernon

lol.

Switching gears now to Green River by Credence Clearwater Revival, from 1969.

some people. just want to know all the answers:

how can I show the min distance as a column from the new function? — user3347256 3 mins ago

:-)

Tom V

@Phrancis crazy people over there :)

swasheck

Given the upload speeds of #OneDrive those whom uploaded 75TB should be applauded for their patience. They must be #SharePoint devs

Tweeted by toddca on November 4, 2015 at 1:47 AM

2

Max Vernon

@swasheck golf-clap

Phrancis

21:08

@TomV That's how we like it on Code Review, chat is usually pretty lively there :)

Tom V

@Phrancis Here I was thinking dba's were weird :)

3

billinkc

21:47

anyone brave enough to accept this download? stackoverflow.com/a/21790038/181965

Tom V

@billinkc using fedora & openoffice I'll try

billinkc

In nomine patris, et fili...

Tom V

@billinkc not rocket science actually

billinkc

Computing md5 hash sum using Excel or accepting the download?

Tom V

both

=$CALC.$B$1

billinkc

21:52

that gives me an invalid formula

Tom V

b1 contains a string

but I'm no vba dev, I don't understand how it works

download it in a trial window/trial office vm and see what happens?

@billinkc but your comment is more than appropriate

billinkc

Fair enough and thank you

Max Vernon

anyone else want some unicorn points? I can't figure out how to explain backups to this guy: dba.stackexchange.com/a/121039/10832

Tom V

@MaxVernon I miss 2 things, RTO/RPO and tail backups (last log backup isn't necessarily the last possible recovery point)

Max Vernon

@TomV I nominate you to explain that to him.

Tom V

22:05

Thanks but no thanks

Max Vernon

@TomV d'oh!

Tom V

links to the rescue

sqlservercentral.com/stairway/73776

Oh and downvote me on any occasion lest I'll be able to vote to close, you don't want me having new superpowers

Max Vernon

@TomV lol... 3k incoming.

Tom V

@MaxVernon not sure if that's deserved, the world might not need me using that priviledge

Max Vernon

@TomV hah, too late.

Tom V

22:24

@MaxVernon not sure what you did but I have a new review queue available :)

Phrancis

I don't understand why this is happening... ^^

Max Vernon

@TomV sweet! I just upvoted a couple of your answers that I hadn't upvoted before. However, I did it in a "natural" way, so as to avoid the serial upvote recognition algorithm.

Phrancis

Does commit transaction drop a temp table that was created during it?

Max Vernon

@Phrancis you've changed the background color of SSMS.

Phrancis

That I have, indeed

Max Vernon

22:26

:-)

Phrancis

I also changed the font to Monaco because I'm an Apple nerd like that :)

Ah, apparently it does. Good to know.

Max Vernon

@Phrancis I was just going to comment on that font. Almost as bad as Comic Sans.

Phrancis

LOL

It's Comic Sans for coders. :)

Max Vernon

@Phrancis NICE!

it's saying Line 41. However, I don't see any ref to that table on line 41. If you double-click the error message, it might highlight the error line.

Phrancis

Max Vernon

22:31

nice comment

Phrancis

Just for you

Tom V

reminds me of a song again, won't bother you

Tom V

23:02

shit ijn paris is going mad

billinkc

^^^

Tom V

40 killed, president in the neighborhood, obama speech coming up

special reports on telly

we'll see, but it's a mess so far

Transcript for

The Heap™ – Consultancy ©®