Tavern on the Meta

user315433

1:52 AM

... but don't you step on my cheap Jordan shoes

user315433

3:52 AM

A snapshot of modern world.

user315433

> Stupid question? No such thing. #AskAStupidQuestionDay pic.twitter.com/COUlRtLjVV -- Google at 10:28 AM - 28 Sep 2017

user315433

Also known as "a day that ends in y" on Stack Exchange.

Journeyman Geek

4:41 AM

@Michelle needs moar spamflags

Journeyman Geek

6:27 AM

that was almost clever.

redhand

A new generation of iPhone. Available now. https://t.co/oEqZ9JzGMa

Tweeted by Apple on September 28, 2017 at 11:19 AM

Journeyman Geek

6:42 AM

But... does it blend?

redhand

@JourneymanGeek previously a fan made video shows it has some built in gas tanks(rocket boosters) whenever it fall down, it will position to fall on backside automatically

Journeyman Geek

I think you're confusing it with Elon Musk's new product

redhand

@JourneymanGeek no. I can give you the link. may be later. TL is watching me. can't youtube now

Journeyman Geek

also, the backside is more expensive to fix than the front.

redhand

@JourneymanGeek but it is scratch resistant. I think it can prevent accidental damages too.

rene

7:00 AM

→ 18 messages moved to Chimney

redhand

7:41 AM

cool!!! isn't it (the title)

Journeyman Geek

it looks like someone messed up and overlaid text ;p

redhand

if you check the address bar, you can find the someone

Journeyman Geek

"localhost"

I DIDN'T DO NUFFIN!!!!!!

"Coder? I ardly knew 'er"

redhand

I can find a margin-top:100px in window.getComputedStyle but can't find it in the css file. Checking a bug on another one's code

Derpy

8:50 AM

@JourneymanGeek Muffin?

redhand

It's really confusing in SO Jobs. It's the second time I am opening job tagged with saas by thinking that the tag is sass

Journeyman Geek

9:04 AM

nuffin

redhand

**nuffin**

**_nʌfɪn_**

_pronoun, adjective, & adverb_

>non-standard spelling of nothing, representing informal speech.

now what the heck is that? all my markdowns..... fuuuuuu
h͊̾͋̀ͤ̍̉̔iͥ̾̿ͪ́̍̀ͫ̾̍̈́̉̍̒̒̚̚d͆ͩ͊̉̐̐̈́͑̓̎͗͛ͨ̇͑̅iͤ̊̌̒ͩͭ̿ͧ̂̄̈́̈́ͯn̉͆̈̃͑́̉̿̔̎͐g̀̒̓̂ ͦ̐͌̔h͂ͬ͛ͣ̄͋͋̒ì̋͌̌͐̄̈́̆ͧͣͧ̀̒̽ͥ͋̽ͭdͫ̂̏̚ǐͭ͑̐ͩ̔̆n̍̂̐͑ͨͧͨ̈̇͊̒̃̐g͆ͫ̌̐̓̀͋ ̄̊̾ͩ͊̿ͯͫ̅͑̎̒̎̄̓̏̾̚a̾͒ͣͥ̀ͧ̽ͣ̎̐̂͑n̅͐̏̉ͩ͗ͨ͐ͮͫ̈́͑̚d̅͆̿́̈ͫͯͨͣͨ͂̈́̋̂ ̿̍ͩͦ̈͊͂̚ḱ̉͊ͤ̾ͦͭ͂ͥ̈́ͪ̈́ë́̊̆ͬ͗͛̈́̇̌͗͋̊ͤ̏̈̒ͥ̊̚e̿ͧ͗̑̽̿ͦͭ̐̀͂̏p͂̔̔ͦ̌̒ͪͣ ͬͮ̓͊̈ḣ͆ͫ͛̉̔ͭ̔̑͋ͭͯ͌ͤi̔̎̅͆ͮ̈́̌́ͦͧ̽̉̎̇͐̍d͆ͫ̑͐̿̄̋͊ͪ̒̈ͦ̅̿ͣiͪ͋́ͭͩ̈́͌̆ͮ͒̾̃̊͛̃ͫñ́̄͛̓ͭ̋͌͒̓͋͆̾̅̅̊g̒́̅͆̀͑

h͊̾͋̀ͤ̍̉̔iͥ̾̿ͪ́̍̀ͫ̾̍̈́̉̍̒̒̚̚d͆ͩ͊̉̐̐̈́͑̓̎͗͛ͨ̇͑̅iͤ̊̌̒ͩͭ̿ͧ̂̄̈́̈́ͯn̉͆̈̃͑́̉̿̔̎͐g̀̒̓̂ ͦ̐͌̔h͂ͬ͛ͣ̄͋͋̒ì̋͌̌͐̄̈́̆ͧͣͧ̀̒̽ͥ͋̽ͭdͫ̂̏̚ǐͭ͑̐ͩ̔̆n̍̂̐͑ͨͧͨ̈̇͊̒̃̐g͆ͫ̌̐̓̀͋ ̄̊̾ͩ͊̿ͯͫ̅͑̎̒̎̄̓̏̾̚a̾͒ͣͥ̀ͧ̽ͣ̎̐̂͑n̅͐̏̉ͩ͗ͨ͐ͮͫ̈́͑̚d̅͆̿́̈ͫͯͨͣͨ͂̈́̋̂ ̿̍ͩͦ̈͊͂̚ḱ̉͊ͤ̾ͦͭ͂ͥ̈́ͪ̈́ë́̊̆ͬ͗͛̈́̇̌͗͋̊ͤ̏̈̒ͥ̊̚e̿ͧ͗̑̽̿ͦͭ̐̀͂̏p͂̔̔ͦ̌̒ͪͣ ͬͮ̓͊̈ḣ͆ͫ͛̉̔ͭ̔̑͋ͭͯ͌ͤi̔̎̅͆ͮ̈́̌́ͦͧ̽̉̎̇͐̍d͆ͫ̑͐̿̄̋͊ͪ̒̈ͦ̅̿ͣiͪ͋́ͭͩ̈́͌̆ͮ͒̾̃̊͛̃ͫñ́̄͛̓ͭ̋͌͒‌̓͋͆̾̅̅̊g̒́̅͆̀͑

Journeyman Geek

eidritch unspeakable horror like typing detected

redhand

how many dogs are there that moderating atleast one se site?

1. undo
2. geek
3. ?

Magisch

9:19 AM

tfw you have a stored procedure with a cursor within a cursor within 2 parallel cursors within a cursor within a cursor

Journeyman Geek

ChrisF

Magisch

Oded's nightmare

rene

He'll suspend you, just for that reason alone ...

redhand

The only cursor I know is..... whoops it won't appear in screenshot

Magisch

@rene to be fair it did cut the 3000 some line stored procedure down to 970 lines

and it also runs three times as fast now

I refactored it today

rene

9:22 AM

@Magisch nice!

Magisch

@rene Before it used the select count then iterate through every row using ROWNUM() select queries in a while loop method

There are still a couple dozen SPs in this company written by my coworkers that I'll have to refactor this way

Also using insensitive cursors is very nice when you're working with views as data basis that change depending on what you do in the SP

rene

@Magisch oh boy ... but ... It Worked™

redhand

3. ChrisF
4. ?

Magisch

@rene next up: the query that creates dummy orders from formal offers in the DB. That's 8000+ lines of TSQL goodness :D

rene

Ouch

Oded

9:30 AM

Magisch

@Oded This cursor is 5 deep

This is like a 4 times nested version of that meme

Oded

Nested cursors are the best way to melt the DB CPU :P

Magisch

@Oded And abusing ROWNUM() to emulate cursors doesn't?

Oded

And I hear ya. I've seen systems where stored procedures called other stored procedures (some 7k lines long). Systems where the code called the DB in order to find out how to call other parts of the DB.

ROWNUM and other windowing functions are better. The engine is better optimized for them, usually.

Magisch

mhm

the SP I rewrote runs in 1/3 of what it used to

not sure if that's due to cursors or other refactoring, tbh

rene

9:36 AM

I once worked on a system that we had to migrate from Oracle to SqlServer. The oracle packages were unmaintainable already and the so called super handy migration tool did its job the resulting SP was so big, SqlServer refused to compile it. Also because it left 20% of the Oracle code in it because the tool didn't know how to handle those statements.

Oded

lol

Magisch

@Oded Real talk though, if I'm forced into using iterative loops in SPs, would you recommend rownum trickery or cursors?

I know this is a plague or smallpox question but still :p

Oded

Better go with rownum - you are giving the optimizer a fighting chance that way.

Magisch

I understand that making subqueries is better then using loops at all, isn't it?

Like if you're doing a INSERT INTO with select as values it's better then to make a loop and issue single-file inserts

Oded

Basically, yes. Again - because the optimizer can actually act on them - it has statistics and other data.

Using temp tables helps.

redhand

10:08 AM

It should be reversed

& it'll be. in near future

Derpy

10:19 AM

Today Is: Ask A Stupid Question Day

Should we show Meta what we are capable of?

Journeyman Geek

lol

@Derpy people have already started.

redhand

@JourneymanGeek It's not started today or yesterday. It's started years before

Journeyman Geek

It started in september ;p

redhand

@Derpy for SO, all 365 days are stupid question day. (366 in leap years as well)

@JourneymanGeek which year?

Journeyman Geek

@redhand almost the right question.

Eternal September

Eternal September or the September that never ended is Usenet slang for a period beginning in September 1993, the month that Internet service provider America Online began offering Usenet access to its many users, overwhelming the existing culture for online forums. The influx in Usenet users was also indirectly caused by the aggressive direct mailing campaign by AOL Chief Marketing Officer Jan Brandt in order to beat out CompuServe and Prodigy, which most notably involved distributing millions of floppy disks and CD-ROMs with free trials of AOL. Before then, Usenet was largely restricted to colleges...

SmokeDetector

10:30 AM

[ SmokeDetector | MS ] Bad NS for domain in answer: How are whatsapp calls banned even with VPN in countries like UAE by Ann on security.SE

Feeds

11:04 AM

Contains the active ingredients from all competing cold medicines, plus the medicines for headaches, arthritis, insomnia, indigestion, and more, because who wants THOSE things?

SmokeDetector

11:18 AM

[ SmokeDetector | MS ] Link at end of answer: Qual a melhor forma de centralizar um elemento vertical e horizontalmente? by Maiza Rocha on pt.stackoverflow.com

user315433

12:05 PM

Electrical Engineering is 7 years old today. As an imported site chiphacker.com, it did not have a private beta on SE 2.0 platform. Top question of the year: Batteries. Why use 9V?

Transcript for