The Heap™ – Consultancy ©® - 2014-09-02 (page 1 of 2)

12:08 AM

My new favorite person on Stack Overflow

well @AaronBertrand how do you expect to get any sort of relationship going as a community if your not willing to take the time to help people instead of just pushing articles at them, this is a site where people help each other when having difficulty not to push some self proclaimed article at new people. — LoveToys 7 mins ago

Faheem Mitha

@AaronBertrand I think Mr. LoveToys wants to be your friend. :-) See the mention of "relationship"?

Aaron Bertrand

He calls me unhelpful for posting a link instead of writing a novel in a comment, then has the nerve to call me ungrateful. WTF is wrong with people?

These are the people who are going to drive Stack Overflow the rest of the way into the toilet.

Faheem Mitha

@AaronBertrand It's called the internet. Why aren't questions about db directed to dba.sx now?

Aaron Bertrand

@FaheemMitha because we don't want to become the janitors for all the shit questions there.

Faheem Mitha

This question for example looks like it would be on-topic here.

@AaronBertrand What about the good questions?

Aaron Bertrand

12:21 AM

@FaheemMitha some of those get migrated, but we're also not in the business of going and stealing all of the good questions from another site, unless it's unlikely they'll get the help they need there.

@FaheemMitha the question above with this guy that's too lazy to read to understand how the case expression works? Oh I disagree with that.

Faheem Mitha

@AaronBertrand personally, if people start being crazy, i drop the conversation/discussion/replies very speedily. like, immediately.

@AaronBertrand It's OT, or just crap?

I commend the same approach to you.

Aaron Bertrand

@FaheemMitha this is mostly just crap.

@FaheemMitha I can handle myself just fine, thanks.

Faheem Mitha

@AaronBertrand ok

@AaronBertrand I wasn't suggesting you couldn't.

Aaron Bertrand

2:18 AM

@user3308043 Oh my gosh, I can't tell you what a horrible, horrible idea that is. Have fun. — Aaron Bertrand 3 mins ago

Simon Righarts

6:41 AM

@AaronBertrand That makes my head hurt. :(

Even aside from the EAV thing (which could arguably be appropriate here) it's like he's managed to corrupt EAV.

Marian

10:27 AM

scontent-b-fra.xx.fbcdn.net/hphotos-xap1/v/t1.0-9/…

ah, that didn't show well

ypercube

10:59 AM

ypercube

11:23 AM

You sure have fun these days. Both at SO and your sites ....

That LoveToys guy is unbelievable

ypercube

11:43 AM

Press the ok button :-) — miracle173 6 hours ago

Aaron Bertrand

@ypercube Indeed. I haven't answered a question on SO in 6 months because of this nonsense, now I can't even leave a comment without getting attacked for one stupid reason or another.

Jack Douglas

11:58 AM

@Aaron that's both hilarious and depressing given the context

btw your blog is really nicely laid out - makes it much easier to follow than some others I know

ypercube

It's surprising how many people just cannot admit they were wrong.

I had seen this when I was a teacher. Many fellow teachers would never admit being wrong. On anything.
That may be a valid approach in a classroom with 6-10 years old children. Not with anyone older.

Jack Douglas

@ypercube there is one guy in the Oracle world who is notorious for it, I wont mention his name because he's also notorious for suing people :S

@Phil will know who I'm talking about...

bluefeet

@AaronBertrand attacked or serially downvoted.

ypercube

@JackDouglas I think I know too. But not sure. You tell me on Friday.

James

1:41 PM

@JackDouglas I think I know who you mean, and I know barely anything about Oracle

I'll confirm Friday : )

ypercube

@JackDouglas This article (i.e. the red footnote disclaimer) hints right about the identity of the alleged notorious suer? hoopercharles.wordpress.com/2011/02/06/…

billinkc

an image search for that person's name returns a picture that screams "I'm a toolbag"

James

Yes, his website has so many warning signs that I knew immediately who you guys were talking about even though I didn't know about the litigiousness

Jack Douglas

@ypercube that is a pretty damning book review - I don't think I'll be buying that book myself ;)

> Page 280 states, “Oracle does not run in a vacuum, and it’s critical to search outside the box and see what is happening with your CPU, RAM, network, and disk I/O subsystems.” While this quote might raise a couple of questions, I would like to know why Oracle (assuming Database) was not designed to function correctly inside a vacuum, and why would the server’s CPU be outside the box?

ha ha ha

in his defense, there are plenty of other books not worth the time to read never mind the money they cost

defence?

James

2:00 PM

@JackDouglas It would make cooling easier I guess

Jack Douglas

hmm, not sure if that is true or not :)

James

Interesting fact: this person's name is not an anagram of any phrase in English

OK, back to business for me now

the-wabbit

2:17 PM

Hi folks.

Oh, hi Jack.

ypercube

@JackDouglas Ha:

> Page 12, when describing examples of poor schema design, suggests that databases using extensive data normalization to minimize data redundancy is a poor design because it forces Oracle to perform unnecessary table joins.

Jack Douglas

all joins are unnecessary, you can put everything in one table if you try

2

the-wabbit

@ypercube This is because computer science is for people on ivory towers. Real developers just intuitively know (or maybe not intuitively but by year-long tinkering with stuff not related to the problem at hand) how to do things right. Just throw away all those nifty theorems and mathematical models, they are of no use anyway.

ypercube

@the-wabbit I assume you are joking - but I can't be sure. You look too tiny from my ivory tower ;)

Jack Douglas

@the-wabbit oh wait, now we have a rabbit and a frog?

the-wabbit

2:22 PM

petting zoo

Jack Douglas

:)

JNK

@JackDouglas and a chimp with a gun

@JackDouglas and a blue-footed booby

Jack Douglas

@the-wabbit I deduce that you are not German, just working in Germany?

@JNK and an alien robot ;)

JNK

@JackDouglas He's an earth-based robot, actually! Created for the military.

the-wabbit

@JackDouglas I live in Germany as well. For long enough to claim that I am German, I suppose.

Jack Douglas

2:27 PM

@the-wabbit ah, OK - your English is so good I didn't think it could be a second language. Are you a Brit or from over the pond originally?

ypercube

@the-wabbit what, like 50 years?

the-wabbit

@JackDouglas my English definitely needs polishing, I was born over in Russia.

Kermit

I like how The Fappening is the top fundraiser at the Prostate Cancer Foundation

the-wabbit

@ypercube no, 25. I'd claim this is quite a while.

Any of you guys doing MySQL with InnoDB?

Kermit

@the-wabbit ha ha ha ha, no. maybe @ypercube

Jack Douglas

2:31 PM

@the-wabbit when I can't avoid it

the-wabbit

(please, anybody, say yes, I need to vent out my frustration)

billinkc

25 years in Germany... so you were there for east/west and given your birth, I'll assume East Germany?

If you're frustrated with MySQL, vent away. It's generally despised in this room

the-wabbit

@billinkc I already suspected so.

billinkc

Extra marks will be awarded if you complain about the non-standard grouping construct

2

swasheck

hhhheeeellllllllllllooooooooooooooooooooooooo nurse

Kermit

2:33 PM

@billinkc SELECT * FROM table GROUP BY name

swasheck

@the-wabbit vent away

ypercube

@the-wabbit what is your issue with innodb?

billinkc

-3

Q: For each loop container not executed

I don't know why it's not executed (for each loop container) at this time, the other components have been executed. thank you

VtC, user too lazy

the-wabbit

How can anybody use a DBMS which is so incredibly hard to get right? Every time I need to deal with it, I have to dig into some ultimately obscure implementation details of the underlying OS's file locking mechanisms, mutex types, page byte orders, in-memory structures or some kind of Voodoo. There are days where I tend to think that writing an own DBMS from scratch in C would be easier than getting this one to do what I want.

And I don't even code C (all that well).

swasheck

have you considered postgresql?

:D

the-wabbit

2:37 PM

@ypercube the latest one? It's locking up.

swasheck

(i am not a troll)

the-wabbit

@swasheck It's not my application, I just get called when it breaks. So I can't just change the DBMS.

ypercube

I never head to deal with anything so low level as mutexes or page byte orders, but MySQL can drive you crazy.

If your problem is with deadlocks, I can't be much help. Please post a question at the site (dba.se).

There are guys like @michael-sqlbot that really know mysql stuff.

2

swasheck

@the-wabbit bummer. sorry to hear it.

Jack Douglas

@the-wabbit good rant :)

I hope you feel better now?

the-wabbit

2:44 PM

@ypercube why oh why do people keep on using it? There are so many beautiful DBMS systems out there.

@JackDouglas a bit. The downside is that my problem is not resolved yet :)

swasheck

@the-wabbit it's just so popular that it must be good, right?

i think it's popular because it's so easy for devs to to use

the-wabbit

@ypercube It's not deadlocks. And it is on the site already:

1

Q: MySQL instance stalling - due to InnoDB log flushes?

An instance of MySQL 5.6.20 running (mostly just) a database with InnoDB tables is exhibiting occasional stalls for all update operations for the duration of 1-4 minutes with all INSERT, UPDATE and DELETE queries remaining in "Query end" state. This obviously is most unfortunate. The MySQL slow q...

mysql innodb mysql-5.6

Jack Douglas

@the-wabbit is the answer any help?

interesting question btw

the-wabbit

@JackDouglas Not yet. I have read the documentation, so I have found this bit already. There must be something I am still missing. When posting the question, I silently hoped that somebody would have seen this already...

Lamak

hey, you guys are back, yesterday was a slow day here

the-wabbit

2:50 PM

Upvotes! Thank you guys :)

BTW, RolandoMySQLDBA seems to be the one answering every single MySQL question on this site

Lamak

@the-wabbit it's a very good question (but I can't help at all though)

Jack Douglas

@the-wabbit so you've tried increasing innodb_log_file_size?

Lamak

@the-wabbit and you already tried turning it off and on again?

Jack Douglas

whats the raw io like on the disk array (seconds/write), does it spike during the stalls?

the-wabbit

@JackDouglas not yet. It is at 2 x 256 MB right now and apparently I am not even close to the logs getting full. At least this is how I interpret the numbers.

Jack Douglas

2:55 PM

@the-wabbit gotcha, the 'difference' figure from the logs

the-wabbit

@JackDouglas it does - the sar output has a granularity of 1 minute, but yes, I do see an increased amount of reads as well as writes during this time. Also, log flushing activity is going on, but log flushing happens at other times, too and not causing any problems.

Aaron Bertrand

tan·gent [ˈtanjənt/] noun

IMHO putting BL in triggers is a bad practice. If you need to get this train anyway and get dificult to consolidate the triggers you can try change then to SPs and make the trigger call the first and the first call the second — jean 3 hours ago

Jack Douglas

@the-wabbit can you get stats for io waits? log flushing at other times might not be contending with scattered io (are the logs written to an independent array?)

mmarie

@Zane I'm coming to your city!

Zane

Yay!

James

2:57 PM

@the-wabbit await also goes up by a factor of close to 10 during the 1417-19 stall. I suppose there's no way there could be I/O coming from some process other than MySQL? Is this on shared storage that could be affected by another system?

Zane

@mmarie For SQL sat?

mmarie

Yes

Zane

I have many brewery's to show you.

mmarie

:-)

the-wabbit

@JackDouglas iowait percentage is above average, but far from being absolutely blocking - I have added the relevant sar stats for the time period to the question.

mmarie

3:05 PM

@Zane I went to one last time I was in Minneapolis... maybe Town Hall Brewery?

the-wabbit

@James yes, I have seen await going up. I can't quite make a full picture out of it as sar is not differentiating between read and write request waits. The underlying storage (an iSCSI device) is not showing any significant peaks in its load except for what is being caused by the MySQL instance.

ConcernedOfTunbridgeWells

i. It's cheap
ii. It comes with most Linux distributions
iii. They've heard of it and read that it's good for web sites somewhere.

@Zane Plus a few grocer's apostrophe's

James

@the-wabbit It's interesting that the request time reported by await is so much higher than svctime, though I'm not sure how to interpret that since svctime is somewhat of a bogus metric. From what I can gather, await is end-to-end service time and svctime is supposed to be service time once the request has gotten outside the OS. That might suggest the request is getting stuck in a queue somewhere, e.g. the kernel I/O scheduler.

There are some reports that await can much lower with noop or deadline scheduler compared to cfq so it might be interesting to see what I/O scheduler that system is running.

That said, I don't know enough MySQL anymore to say whether any of this is related to the problem. :/

@ConcernedOfTunbridgeWells cf. MongoDB

JNK

@ConcernedOfTunbridgeWells I like that name for the pluralizing apostrophe

ConcernedOfTunbridgeWells

@James All together now: WEB SCALE

@JNK Never heard it before? It gets a mention in Wikipedia.

Andriy M

3:15 PM

Really, @Aaron:

Have you no experience with copy and paste haha — LoveToys 2 mins ago

I thought you'd unsubscribed 14 hours ago

ConcernedOfTunbridgeWells

Aaron Bertrand

@AndriyM sadly I keep getting these stupid ahem pings

the-wabbit

@James an interesting aspect nonetheless. /sys/block/sda/queue/scheduler tells that the currently used one is cfq. I have changed it to deadline, let's see how it is going to behave.

Lamak

@LoveToys The thing is, you didn't come here for advice, since you were given advice multiple times and you just dismissed it. You just came here for "GIVE ME THE CODEZ NOW, DON'T WANT TO LEARNZ ANYTHING" — Lamak 25 secs ago

Tim Stone

> ...long gone are the days of planet source code...

What does that even mean? >_>

hacks the earth

Lamak

3:26 PM

aaaw, my comment got deleted?

billinkc

@ConcernedOfTunbridgeWells I think you wanted us to read it so we could click on en.wikipedia.org/wiki/Royal_Tunbridge_Wells

Aaron Bertrand

I guess he would have been happier if I had said:

bluefeet

@Lamak sorry, there are several flags going on there

Aaron Bertrand

> NO, the CASE expression doesn't work that way. Please read Dirty secrets of the CASE expression.

Zane

@mmarie Yeah. They have some pretty good stuff.

Lamak

3:27 PM

@bluefeet no problem. I just got surprised, since it didn't seem offensive. Maybe too chatty?

Aaron Bertrand

@Lamak LoveToys is probably flagging every comment he doesn't like.

bluefeet

@AaronBertrand that doesn't necessarily mean they will be deleted

Lamak

yeah, but well, he didn't come from advice, that's for sure. Just wanted to point the hipocrisy

Aaron Bertrand

@Tim did my f-bomb draw you here? :-)

If so, sorry about that. Getting it from all sides today.

Tim Stone

Yes, but not because of a flag. :P

I tabbed into this room and had to see what was going on, heh.

Lamak

3:30 PM

@TimStone you get pinged everytime someone drops the f-bomb?

Tim Stone

I don't think I could cope with that many pings

Aaron Bertrand

We're actually pretty good about that in here.

Tim Stone

It's confusing that he has time to defend not having time to read the article when reading the article would have been less time than defending that terrible position.

@AaronBertrand The Bridge less so. ;)

Aaron Bertrand

We had a couple of people thinking it was funny to flag every swear word and then we ran into a little trouble. I think we've addressed both issues.

...for the most part.

Lamak

yeah, we behave pretty well

Aaron Bertrand

3:32 PM

@TimStone well yeah, and if I wrote all that as an answer here, why would he suddenly have a bunch of time to read it? Does the URL dictate his reading pace?

billinkc

GIMMIE DA CODEZ!

bluefeet

@AaronBertrand sorry I cleaned up a bunch of those comments ;P

Aaron Bertrand

@bluefeet s'ok, I got my point across, even if he's too f'ing dense to get it yet

Lamak

now @TimStone got pinged again ;-)

ConcernedOfTunbridgeWells

@billinkc You mean Royal Tunbridge Wells?

Kermit

3:34 PM

@Lamak define "pretty well"

Lamak

well, you are mostly no longer here, so....

billinkc

Something like that

ConcernedOfTunbridgeWells

@billinkc I'm concerned about you.

Zane

@Lamak ouch.

Kermit

@Lamak i see what you did there

billinkc

3:37 PM

@ConcernedOfTunbridgeWells Well, I royally appreciate the concern

Lamak

@Kermit you know I miss you

Tim Stone

@AaronBertrand Maybe he wasn't sure if the CASE expression's dirty secrets were safe for work.

swasheck

@mikefal ... you around?

billinkc

@Lamak You should really learn to aim better

Kermit

@Lamak i know because you told me in my dreams last night

Lamak

3:38 PM

@TimStone ahem, CASE expression

@Kermit boy, that escalated quickly

Tim Stone

@Lamak Hmmmm?

Aaron Bertrand

@TimStone phew, I'm glad you fixed that

It was about to get pretty tense up in here

Kermit

@TimStone close call

Tim Stone

I'm only half awake, please forgive me.

Lamak

@TimStone Oh, sorry, I don't know what I read ;-)

swasheck

3:39 PM

CASE queries are just ... the worst

Aaron Bertrand

Why does someone suddenly unaccept an answer they accepted almost a year ago? It worked for them for 11 months but now it's no good?

Woe is me, 15 rep, I just don't understand the behavior.

If someone had posted a new answer or there was other activity on the post (like Aaron's answer sucks because <foo>)...

Kermit

@AaronBertrand duh, you didn't get the memo that their requirements changed?

Tim Stone

@AaronBertrand The timeline is even more amusing

Kermit

TIL timeline

JNK

nothing like investigating an issue and finding a 2.5 year old Q you asked and @PaulWhite answered

Lamak

3:41 PM

@TimStone I had completely forgot about timeline

the-wabbit

@AaronBertrand he may be considering posting an answer on his own and accept this one.

Aaron Bertrand

@Kermit I try to keep track but I've had a busy day

Kermit

@AaronBertrand don't let it happen again, cause 15 rep

JNK

@AaronBertrand is it possible to configure what events are captured in a QuickTrace?

Aaron Bertrand

@the-wabbit well Tim's post leads me to believe he's just jerking people around - three unaccepts and three accepts.

swasheck

3:45 PM

blog.bigml.com/2014/09/02/did-germany-cheat-in-world-cup-2014

the-wabbit

This is crazy: on SO, I don't even have enough reputation to view the number of up-/downvotes for a specific post, but I am allowed to look at the timeline?

@swasheck heh, this is nice.

swasheck

nevermind. i like SAP. i was thinking of SAS

Aaron Bertrand

@JNK can you give me more details (e.g. what are you specifically trying to leave out)?

JNK

@AaronBertrand I want to add hash warnings

looking into my perf issues some more and I think a big part of it could be related to hash spills

Aaron Bertrand

Or just spills in general?

JNK

3:53 PM

yeah in general too

but specifically hash spills

Aaron Bertrand

Let me have a chat (office is crazy due to return from long weekend, so not sure how long it will take)

JNK

no problem this is non-urgent, and I can set up a normal trace if I need to

but I like the quick trace and the way it stores everything for you

Lamak

@swasheck I don't buy it

Aaron Bertrand

Yeah QuickTrace is nice. Adding events has to be possible, just not sure how intrusive it is, and whether the change would be environment-wide.

swasheck

@Lamak apparently you can't buy it yet. you have to wait for the german side to get a few more dominating tournament wins :)

Aaron Bertrand

3:59 PM

@JNK sad trombone. From the developer:

> the trace events are hardcoded into the source

Lamak

@swasheck true. Anyway, I wouldn't even really care if they were actually using it

Aaron Bertrand

> in short, i can add them, but its not end-user customizable in any way at the current time

So looks like for now you'll have to use your own trace. I'm not sure if there's an easy way to pull your trace data into the repository - I'm guessing the database, too, will expect only the events and columns pulled by QT.

Mike Fal

@swasheck What do you need?

swasheck

@MikeFal i need to tell you that we need links to the eventbrite thing on the denversql site. i finally found the email but just didnt know if it was possible to put that on the main site itself (going forward)

Mike Fal

l

k

billinkc

4:07 PM

This amuses me greatly

Zane

Nice.

Aaron Bertrand

4:18 PM

@JNK <sorry I was wrong>

JNK

@AaronBertrand it's fine

and it makes sense to hard code that since if the user adds their own (expensive) trace events suddenly SQL Sentry is crashing the production server

you need to make it hard for people to shoot themselves in the foot

ypercube

4:34 PM

@billinkc It's correct. In MySQL.

swasheck

@ypercube define "correct."

Aaron Bertrand

Correct in MySQL is just "didn't generate an error"

ypercube

@swasheck Like trying using a view that has a join between two other views. except the most recent versions of optimizer, it's like forcing mysql to do harakiri.

swasheck

@ypercube hm. ok.

►

Zane

bbc.com/news/technology-29012038

I wonder how this will effect my co-workers who are stuck on IE 10 at the moment.

oh wow look at that, it is different.

G+ black bar at the top.

Aaron Bertrand

4:50 PM

Oh noes! Not the G+ black bar!

What are these people complaining about? Can they still perform searches?

Zane

It's kind of interesting.

swasheck

the vast majority of end-users have presuppositions about the "way things should be" without any actual understanding of the problems being solved under the hoods in order to satisfy their desires/wishes.

Aaron Bertrand

I don't blame them. I don't want to have to test my shit in Safari 5 either. Seriously.

Do you know how complicated the test matrix becomes even for current and current-1?

swasheck

yeah

it's full of suck

Aaron Bertrand

Especially when you start having to add customizations for every single version, since IE for example loves to change the way they follow the standards with every release

Zane

4:54 PM

It's weird how the corporate standard takes so long to update.

Aaron Bertrand

Even CSS on a simple site like that can be a royal PITA to keep the same appearance across the board, never mind the JavaScript stuff they must do for some of the advanced features. Much easier to just use something already tried and true on those old browsers, than introduce them to the testing matrix every. frigging. time.

James

@the-wabbit Yes, I'm curious to see if the problem will go away or change now. I'll probably check the question in the future and see if you updated.

swasheck

@Zane so many things are coded do a specific release and corp is so sensitive to breaking changes. they'd rather stay unsupported on the their platform than have to invest the person-hours to test/update internal apps

Aaron Bertrand

@Zane for the browser, I don't understand, except in cases where some home-grown or vendor app absolutely breaks on the next version. For the OS, I understand too (that has more to do with $ in a lot of cases). But in most scenarios I just don't understand. Like why SSMS 2014 has to undergo separate conformance testing than SSMS 2012. Uh, why?

swasheck

@AaronBertrand yeah. that's a dumb, dumb case. the problem is that MS releases SSMS with SQL Server so there's the perception of "oh crap what's that going to break"

Aaron Bertrand

4:56 PM

SSIS packages

allegedly

billinkc

My group is very important. If we don't test this, a bombbomb might go off

swasheck

@billinkc mariowiki.com/Bob-omb

billinkc

I hang my head in shame

I could only hear the girl from Scott Pilgrim yelling "We are sex bob-omb!" without closed captioning to assist me

swasheck

i am unfamiliar

billinkc

Scott Pilgrim vs. the World

Scott Pilgrim vs. the World is a 2010 comedy film co-written, produced and directed by Edgar Wright, based on the graphic novel series Scott Pilgrim by Bryan Lee O'Malley. It stars Michael Cera as musician Scott Pilgrim, who must battle his girlfriend Ramona's seven evil exes, who are coming to kill him. Scott Pilgrim vs. the World was planned as a film after the first volume of the comic was released. Wright became attached to the project and filming began in March 2009 in Toronto. Scott Pilgrim vs. the World premiered after a panel discussion at the San Diego Comic-Con International on July 22...

Aaron Bertrand

5:01 PM

@swasheck who the hell has time to write all that? I seriously hope it was on Nintendo's dime. Jesus.

swasheck

@AaronBertrand i actually didnt read it (it's blocked for me) :)

Aaron Bertrand

@swasheck it's about 30 screens worth of useless trivia about the Bob-omb character. Wow.

swasheck

what a waste of bits

JNK

@AaronBertrand read the mario brothers movie page

The plot summary is likely longer than the script for the film

swasheck

@JNK there was a plot?

bluefeet

5:15 PM

someone tried to page me

@Bluefeet: PIVOT question! :-) — marc_s 23 mins ago

Lamak

hey, it's marc_s

he edits a lot of badly formatted questions and leaves a lot of comments about tagging correctly, etc

ypercube

SO is down it seems.

JNK

marc is great

he loves to correct MSSQL to SQL Server

Aaron Bertrand

Well very sluggish at least. Took about a minute to get a comment through

@JNK As he should! There's no such thing

ypercube

All sites affected

Aaron Bertrand

5:24 PM

Oh but then I got "an error occurred while voting"

Boom shakalaka

All SQL Server's fault, I'm sure

Nothing here yet

JNK

just checked that

and nick's handle

ypercube

Up again. Just 1 or 2 minutes thing.

Aaron Bertrand

IMAGINE ALL THE LOST PRODUCTIVITY

WON'T SOMEBODY THINK OF THE PRODUCTIVITY

JNK

Lakhs of rupees are disappearing.

Also the various currencies of Eastern Europe

Aaron Bertrand

lakhs and lakhs

Lamak

5:28 PM

@JNK you cheched nicks' handle?, eww

Aaron Bertrand

Funny nobody has made a joke like SELECT ... WITH (NOLAKH)

JNK

looks to be back up

lol

"CPU Usage is through the roof!"

its SE so I presume they have a CLR for that

Aaron Bertrand

Actually, maybe it just tried to find the most recent version.

JNK

...and timed out reading a hundred page SSC thread?

Aaron Bertrand

5:44 PM

Precisely

All the chest-thumping I guess

jynus

@ypercube LOL at the last comment: dba.stackexchange.com/questions/75502/…

ypercube

@jynus Ha, yeah. How could anyone think that having duplicate indexes be of any improvement, is beyond me...

JNK

I know SSC is a valuable resource for some things but to me it embodies all the things I love about the SE/SO model instead of a forum

I do not have the patience to read through 30 pages of comments and asides to get to good info

Lamak

it's not that hard to understand:

Sure. Your result ordered the half with the maximum length all first (in this case the lengths 10, 9, 8, 7, 6), and then the other half. But op said s/he wants the largests in top and bottom, not the largest on top, and the rest on the bottom — Lamak 1 min ago

ypercube

6:01 PM

@Lamak I don't even understand the question...

Kermit

@Lamak way to boom them

Aaron Bertrand

Cleaning up

Just the one comment I guess

Lamak

@ypercube How I understand it, op wants to order like this: sqlfiddle.com/#!3/f3fbe/1

Kermit

@AaronBertrand i. want. to. see

Lamak

@ypercube like a pyramid for the length. M. Ali is half way there, since the order is like a pyramid, but the first half has all the rows with the largest strings

ypercube

6:06 PM

@Lamak Ah, I hadn't seen you answered. That makes more sense, yes.

You should make it parametrized, so it can produce all possible pyramid outputs, from yours up to and including M.Ali's and anything like.

Lamak

@ypercube ah, yeah, that would be great. Have I explained to you that I'm a lazy guy?

billinkc

You would have, if you weren't so lazy

3

Lamak

true

Zane

6:34 PM

@swasheck Great book and movie. Highly recomend.

@AaronBertrand You'd be amazed by the amount of items out there the people put out for free.

Go to gamefaqs.com it's amazing the amount of detailed walkthroughs there are for even the most obscure games.

Zane

6:50 PM

There is a dude in my office with his sound cranked. Every time he get's and e-mail or a lync message it makes a loud ping. It's driving me crazy.

JNK

@Zane tell him

Zane

@JNK You're right I should go punch him in the head.

JNK

The passive-aggressive way to handle it if he doesn't turn it down is to have a foghorn sound effect you can play yourself manually whenever his dings

Or the sound of an active sonar ping

I did that once

not my proudest moment but it worked

Max Vernon

@JNK Nothing like a nice bit of passive aggressiveness once in a while!

billinkc

You should lync them every time their alert goes off "You have Mail" "Somebody wants to chat with you"

Kermit

6:59 PM

redeem your free dominos pizza at MLB.COM/DOMINOS

Max Vernon

"Harvard Business Review, which reminds us that “It Depends™” is by no means a sneaky side step. Rather, it is “The answer to every strategic business question”, and the trick is knowing what ‘it’ depends on."

billinkc

redeem your free gastrointestinal illness at mlb.com/dominos too

Kermit

@billinkc i redeemed that at mcdonalds a few years ago

billinkc

No limit on quantity

Kermit

#truth

swasheck

7:01 PM

@MaxVernon i prefer outright aggression

Max Vernon

@swasheck "walk softly, and carry a big stick"?

Zane

@MaxVernon Run screaming loudly and waving around a big stick.

Max Vernon

@Zane preferably an aluminum baseball bat.

or a ball-peen hammer

Zane

7:32 PM

@JNK If I'm going to go passive aggressive on him it will be with whisky farts for sure.

Mike Fal

7:45 PM

Whisky...farts....?

No, never mind

I don't want to know

billinkc

Data.SE explorers, I have an Id for an answer. How do I translate that back to a URL? I see the format looks like stackoverflow/a/25627767/181965 but neither of those numbers ties to the question id

data.stackexchange.com/stackoverflow/revision/222135/291556/…

Relevant query to my question

Lamak

@billinkc Alias the id column with [Post Link]

bluefeet

@billinkc dude read the help -- data.stackexchange.com/help

billinkc

The fine manuals are for suckers

Besides, I have answers to dv and flag ;)

Thanks melak

Lamak

that's a new one

bluefeet

7:54 PM

here @billinkc data.stackexchange.com/stackoverflow/query/222149/…

billinkc

Yup, evaluating my results

ypercube

It shows this answer: stackoverflow.com/questions/23126848/…

One line, contains ("not enough rep to comment"). And it was accepted :)

billinkc

Yeah, it's not fool proof. Probably need to factor is that it wasn't accepted as an answer but figured I'd try to get something to find low hanging fruit

Lamak

I used a query to find some "too chatty" comments, but stopped doing so to not bother the mods

bluefeet

@Lamak and we appreciate that

Lamak

7:59 PM

:-)

Transcript for

The Heap™ – Consultancy ©®