The Heap™ – Consultancy ©® - 2017-01-09

« first day (2197 days earlier) ← previous day next day → last day (2686 days later) »

12:08 AM

@MaxVernon Hey, be nice!

2

12:47 AM

@MaxVernon She's pretty awesome. Normally, when she walks in, "I'm like, LOOKS, IT'S EVAN'S GIRLFRIEND, THE LUCKIEST WOMAN EVER."

Luckiest Cobol programmer's girlfriend

TIL SQL 2011 provides for embedded cobol.

postgresql.org/docs/current/static/…

1:24 AM

@ypercubeᵀᴹ That's my line ...

Hey, be nice!

2

Having a CREATE TEMPORARY TABLE in the the sample of a question that requests answers without the use of temporary tables, is rather ironic, isn't it?

@EvanCarroll ^^^^

Perhaps on some really awkward reading, he has a desire output, and I wanted to try for it in a different way. But, I failed. Anyway, it's nice to not have to create sample data.

Unless you're simply asking whether or not the TEMPORARY should be there.

Don't much care to fight that one. I prefer to make sample data temporary so it goes away without me having to delete it.

@EvanCarroll yes

you can yank the temporary term it if you care about it.

gawd, microsoft docs are horrible but they seem to be the only one with the guts to publish anything about the ansi spec. I get the feeling that they're litigious.

msdn.microsoft.com/en-us/library/hh501277(v=sql.105).aspx

1 hour later…

3:08 AM

2

A: How to generate a 1, 2, 3, 3, 2, 1, 1, 2, 3, 3, 2, 1, ... series in standard SQL or T-SQL?

If you need plain SQL. Theoretically it should to work on the most DBMSs (tested on PostgreSQL and SQLite): with recursive s(i,n,z) as ( select * from (values(1,1,1),(3*2,1,2)) as v -- Here 3 is n union all select case z when 1 then i+1 when 2 then i-1 end, n+1, z ...

I like that answer.

3 hours later…

5:52 AM

Hats are gone :(

Dang

How did we do on the official leaderboard?

winterbash2016.stackexchange.com/leaderboard

2 hours later…

7:54 AM

@EvanCarroll recursive way would be the slowest, in most DBMS. That's why I didn't include it in my answer ;)

Try to generate a billion numbers recursively.

or a trillion

7 hours later…

2:40 PM

user image

@MaxVernon Windows, what do you expect...?

@ypercubeᵀᴹ lol. no doubt.

@MaxVernon I had some fun on Saturday

yesterday, by TypoCubeᵀᴹ

after 3 hours, 4 restarts and some internet searches, I managed to update ...

yesterday, by TypoCubeᵀᴹ

the updater

you are @ypercubeᵀᴹ again

@ypercubeᵀᴹ oh right. I saw that. tons of fun!

2:44 PM

@Lamak should really be sad-without-hats-cube !

@MaxVernon After that manual fix, it went rather smoothly, have to admit. Just 2 restarts, only 10-15 mins.

I still have an update that denies all my attempts and can't be installed but that's fine.

@ypercubeᵀᴹ so annoying when that happens

Yeah, something to do with MS essentials / Defender. I rarely use the Win boot, so I wasn't bothered to do any serious config when I bought the machine.

3:22 PM

Hi

2 hours later…

5:19 PM

Hi

5:31 PM

Google Drive is working for you? i.e. you can list/view your files.

For me: "The server encountered an error. Please try again later."

5:48 PM

@PaulVargas Working fine here

But given where I am I suppose I connect to a different datacenter somewhere in Europe

@PaulVargas Ok for me too. Not that I use Google Drive often.

@TomV The ping command shows the IP 216.58.193.46.

@PaulVargas I get 172.217.17.46

The same IP (216.58.193.46) in the last row of tracert command.

OK. I'm going to "try again later". :/

@PaulVargas I'm using opendns as a dns provider, could be a temporary solution?

6:17 PM

It's working now!

\o/

in lieu of hats, @PaulWhite is reduced to ASCII art

Sad isn't it

       .--------.
      /          `.
     |         .-. \
     |         |  `.|
VK   |_________|   /|\
    (___________)  |||

            .
           /:\
          /;:.\
         //;:. \
        ///;:.. \
  __--"////;:... \"--__
--__   "--_____--"   __--
    """--_______--"""

        .e$$$$$$$$$o.  .z+""-eu.      .xu..
     d$$$$$$$$$$$$$$$$$o.    $$$$$u#         ^%s
   u$$$$$$$$$$$$$$$$$$$$$$.  $$$$"              ^s
  u$$$$$$$$$$$$$$$$$$$$$$$$u $$$                  ".
  $$$$$$$$$$$$$$$$$$$$$$$$$$c$$                    'c
 $$$$$$$$$$$$$$$$$$$$$$$$$$$$$               :       k
 $$$$$$$$$$$$$$$$$$$$$$$$$$$$$              :z!      '>
 $$$$$$$$$$$$$$$$$$$$$$$$$$$$EB             R         5
 $$$$$$$$"RR$$$$$$$$$$$$$$$$$E'            :E         9
 $$$$$$P   $$$$$$$$$$$$$$$$$$E k           ' `%       F

ASCIIcube

6:45 PM

Pretty.

We have to wait ~344 days for new hats

Hat's a shame

say farewell

7:35 PM

@ypercubeᵀᴹ I'm still hoping we'll get hats for Winter (in 6 months)

@PaulWhite summer bash

> The most difficult non-secret hat to earn was Maverick, which was awarded only to 17 users.

@PaulWhite seems like it could have been gamed with a voting bloc

@PaulWhite did you get it?

i'm not going to say anything about elections ... but kinda like elections

7:40 PM

@bluefeet I did not.

@bluefeet two other heapers got it (not me either).

> with TypoCube™ being the first to earn 8,243,721 on Database Administrators.

Fame!

:)

seems like a copy-paste issue?

Huh. I could have sworn I hit "Improve Edit" or "Reject and Edit" from Sug.Edits 5 times, but no "They Live". Hm, guess I didn't then!

7:45 PM

@PaulWhite where can we find these stats?

No doubt, say it all you want. I would take SQL Server over MySQL any day. It's worth saying too when it's relevant. Just having rank/window functions would make this easier too. — Evan Carroll 1 min ago

@ypercubeᵀᴹ say farewell on the star board

Farewell!

@bluefeet The Eric and Ernie hats are much more awesome than I suspected. Also, Like Clockwork.

Thanks, I thought they were good triggers

like an emotional trigger?

7:51 PM

@bluefeet Yes very good. Hats for doing good things.

@PaulWhite clockwork was great

Eric & Ernie:

> These two hats worked hand in hand. If you commented on 6 posts, the owner edited them, and you deleted the comments, you'd earn both hats.

@PaulWhite I won one of those

So awesome @ypercubeᵀᴹ got the first Eric one anywhere on the network.

@PaulWhite we really try to come up with things that are for doing positive behavior.

7:55 PM

it was @typocube though

@bluefeet Yes indeed. Those two just particularly appeal to me.

@PaulWhite and @MaxVernon featured a real life clockwork hat, that was awesome

True

@bluefeet was I the first to earn both? I think not because I got the 6, long time after the first one.

> Jaromanda X was the first to earn 6 on Stack Overflow,

7:57 PM

@ypercubeᵀᴹ nope, you were the first to get 8,243,721

@ypercubeᵀᴹ Have you not read the link yet?

@PaulWhite I just did.

I wondered if I was the first that got both hats. Not the first to get Eric hat and the first to get the Ernie hat.

@ypercubeᵀᴹ Perhaps your reading suffers from typos too.

@PaulWhite @dyslexiatube?

It's probably all those dimensions

7:59 PM

yeah, must be hard to keep focus

Sep 7 '15 at 17:15, by ypercube

@Kermit I walk through walls. I'm a 6th dimensional object ;)

8:28 PM

maybe I should change my name again

15

A: Walking through solid rock - title of old story?

“Rock Diver” This was written by Harry Harrison during the early 1950s, so indeed during the Cold War. In this story, there’s a "walk-through" that allows the user to move through solid stone: Pete had been a rock diver for eleven years, yet the sight of this incredible environment neve...

1 hour later…

9:40 PM

IT IS I, EVAN CARROLL

9:58 PM

Evan Carrol is an anagram of Carnal Lover

2

@billinkc I'm nit sure what's more disturbing; that you recognized that, or that you recognized that.

It's also an anagram of Not Credulous.

@MaxVernon Alas, I am not that insightful but the interblags is anagram.wordsmith.org/anagram/…

Not that A Craven Roll wasn't compelling...

is that like, "DO A BARREL ROLL!"?

« first day (2197 days earlier) ← previous day next day → last day (2686 days later) »

Transcript for

Jan '179

The Heap™ – Consultancy ©®

General on- and off-site discussion for dba.stackexchange.com....

frogs mysql nosql oracle postgresql sqlite sql-server

join this room
about this room

00:00

06:00

12:00

18:00

all times are UTC

site design / logo © 2024 Stack Exchange Inc; legal

mobile