The Heap™ – Consultancy ©® - 2017-10-12 (page 2 of 2)

sp_BlitzErik

6:01 PM

no way. deads and ohp are my favorite exercises to i put them on m and f to keep up motivation.

swasheck

@sp_BlitzErik i didnt realize there were variants

wait. maybe i have no idea what you're asking

sp_BlitzErik

i was asking how you have your routine set up

full body, upper lower, push pull legs

Lamak

> i put them on m and f

what does that mean?

sp_BlitzErik

monday and friday you calendarless peasant

:D

Joe Obbish

> lifting weights for fun

sp_BlitzErik

6:07 PM

what other reason is there?

swasheck

monday is chest and tri ... wednesday is biceps and back ... friday (is generally) leg day ....

tuesday is boxing and cardio training
thursday is a random day with cardio and usually a rowing machine

every day is a 25 minute HIIT warmup

gbn

@swasheck I find Prosecco and Wind helps me

swasheck

scotch and sake

sp_BlitzErik

nice.

gbn

@swasheck warm or cold sake?

sp_BlitzErik

6:08 PM

i should probably try cardio someday

bluefeet

@swasheck I'm guessing your knee is all better?

swasheck

@gbn since warm is the rubbish bin of sake ... i like mine cold

gbn

@sp_BlitzErik It's good with tonic, make sure sure you get the 40% stuff

Lamak

@swasheck you exercise quite a lot

swasheck

@bluefeet yeah. it's what precipitated the workout mania for me. i read that people are breaking themselves with crossfit so i'm glad i didnt get into that

gbn

6:09 PM

@swasheck good man, I was worried that you were another uncouth yank barbarian

swasheck

@Lamak i have a lot of adrenaline to expell

@gbn i probably am, but not necessarily for that reason

bluefeet

@swasheck haha, I still do crossfit and haven't broken myself yet

Lamak

but it turned your feet blue

sp_BlitzErik

@gbn i can't be bothered to mix things

Lamak

on the other hand, that's awesome

Joe Obbish

6:10 PM

guy lifts weights for fun

but can't be bothered to mix things

bluefeet

@Lamak they were already that way

sp_BlitzErik

@bluefeet do i need to apoligize for making fun of crossfit in several blog posts?

bluefeet

@sp_BlitzErik nah, it gets made fun of all the time I don't take it personal. It's not for everyone

Lamak

@sp_BlitzErik I don't think she knew

but now you need to

ypercubeᵀᴹ

@bluefeet that's Paul's habbit (breaking himself) and doesn't need crossfit ;)

Joe Obbish

6:12 PM

I'd like an apology

sp_BlitzErik

paul vapes hard

swasheck

crossfit just never really appealed to me.

bluefeet

@ypercubeᵀᴹ then he has other issues, obviously

sp_BlitzErik

@swasheck it's good exercise, just prefer training

bluefeet

@sp_BlitzErik it's all about fitnessing!!! :P

Lamak

6:14 PM

@sp_BlitzErik it's too late to try to save face now

swasheck

well i enjoy playing soccer so i need some time to fit that into my schedule ... so crossfit died on the vine

sp_BlitzErik

swasheck is a real renaissance man

Paul White

@ypercubeᵀᴹ true story

swasheck

@sp_BlitzErik first time i've been called that

@PaulWhite attacked by a hotel table

Paul White

@swasheck brutally attacked in my sleep!

sp_BlitzErik

6:20 PM

city kiwi attacked by furniture

Paul White

a sad tale indeed

swasheck

@PaulWhite was like, "where'd it go?"
and i was like, "where'd whooo go?"

sp_BlitzErik

> with 177 users currently talking in 102 rooms.

seems lopsided

swasheck

which side?

sp_BlitzErik

well

i bet someone is lonely

Lamak

6:26 PM

that's not a very risky bet

sp_BlitzErik

now all i can do is picture bluefeet hobbling around the SO office in knee and elbow braces checking her pulse after opening and closing a desk drawer 500 times

bluefeet

hahaha

Joe Obbish

spicy

swasheck

gotta get the reps in one way or another

Lamak

answering questions seems to be the fastest way

bluefeet

6:29 PM

@sp_BlitzErik I'm definitely not that into crossfit. I'm one of those weirdos that like lifting heavy things, but prefers running over anything.

swasheck

@bluefeet would you run over a porcupine?

bluefeet

why not

:)

prickly punks

On foot or in a car?

yes

6:52 PM

I voted for NZ Bird of the Year

sp_BlitzErik

what's her name?

is your wife mad?

Lamak

@PaulWhite what did those birds do to get in serious trouble?

Paul White

@sp_BlitzErik Kererū

billinkc

I thought burds were off topic for the room

Paul White

@sp_BlitzErik Heap Secret™

@billinkc Just owls!

But that never stopped anyone

billinkc

6:57 PM

I'm not just anyone, I'm someone

Paul White

@Lamak Stealing cars and whatnot

sp_BlitzErik

i'm so confused

Paul White

Probably

sp_BlitzErik

does not look like he's doing okay

Lamak

@sp_BlitzErik who doesn't want more pork?

sp_BlitzErik

6:58 PM

someone keeps calling him pork

your planet is weird.

Paul White

We have a local Morepork. Hear him/her most nights.

Name's Jeff.

sp_BlitzErik

is jeff doing ok?

Paul White

Says so right there

sp_BlitzErik

i thought that was ruru

baby ruru

Paul White

They do look alike I'll give you that

sp_BlitzErik

7:02 PM

perhaps they share a common ancestor

Paul White

I'll ask Jeff if he's tried Ancestry.com

Lamak

I can't believe it's been 8 years since the kiwi won

what are you guys doing?

Paul White

Too obvious

Gets plenty of attention already

sp_BlitzErik

i like that rock penguin

looks like a roadie for rose tattoo

Paul White

Kiwi is the bird of every year already

@sp_BlitzErik You can vote for it!

sp_BlitzErik

7:04 PM

i'd be an outside agitator

Lamak

@PaulWhite but it needs my email

sp_BlitzErik

realsqlkiwi@gmail.com

Paul White

ha ha

@Lamak Yeah but think of the bird man

Lamak

what does the winner get?

Paul White

So materialistic

sp_BlitzErik

7:07 PM

the winner apparently gets to survive

all these sky rats are going extinct

Lamak

@PaulWhite I just want to know what benefit does that privileged bird get

Paul White

Yeah the losers all get shot

Lamak

I would've thought that just the ones in serious trouble

Paul White

I believe they're hoping people will vote along those lines but there are no rules AFAICT

My wife just voted for the whio (blue duck)

Lamak

now I want to know how did I understand correctly "As Far As I Can Tell" from reading it for the first time

or maybe I didn't

Paul White

7:10 PM

Yep

I'm inside your head

Lamak

how terrifying

sp_BlitzErik

i'm writing in bluefeet

it's about time an american won

Paul White

Don't tell me - a Freedom Bird

Lamak

@PaulWhite would that be a bird that's covered in oil?

Joe Obbish

Lamak doesn't understand freedom

Paul White

7:17 PM

Is there an amendment about arming birds? Or is it just bears?

Cue Bill posting a shopp'd picture of Trump's hair on a (previously) bald eagle

I bet he voted for an owl just to spite me

Lamak

@PaulWhite or posting the real freedom bird

Paul White

That still makes me laugh.

"Your argument is invalid - my hair is a bird" or something along those lines.

Lamak

@PaulWhite yup

Paul White

Nice

I got it backwards though

Lamak

well, I get it, with the aging and all that

Paul White

7:29 PM

:)

Lamak

7:40 PM

interesting....

amiunique.org/fp

Paul White

@SQL_Kiwi Kakapo - no contest! And we've been on a trip with Heritage Expeditions - great outfit.

Tweeted by PaulRandal on October 12, 2017 at 7:42 PM in reply to SQL_Kiwi

Bird voting continues!

sp_BlitzErik

who are these extravagant people with bird opinions

Joe Obbish

I'd vote for the most edible one

sp_BlitzErik

you'll never be a top postgres man with your meat eating

Lamak

@JoeObbish it's clear, then

2

Joe Obbish

7:52 PM

@sp_BlitzErik good

Paul White

8:04 PM

Sep 16 '14 at 15:09, by Paul White

I'm vegetarian. KFC doesn't appeal.

Joe Obbish

KFC doesn't appeal to me either

sp_BlitzErik

0 kfc interest

Joe Obbish

how many days per week do you eat chicken?

Paul White

@Lamak I am unique. Were you?

sp_BlitzErik

@JoeObbish eight

Joe Obbish

8:06 PM

I knew it

Paul White

JEAML: Bill's nickname is KFC

sp_BlitzErik

bill who?

Paul White

billinkc

billinkfc see

Joe Obbish

is that name supposed to be bill in kc?

Paul White

Yes

Joe Obbish

8:08 PM

I never put that together until now

thought it was just nonsense

Paul White

Every day is a school day in The Heap

Lamak

@PaulWhite I was too

and it isn't good, apparently

Paul White

Meh.

I sort of gave up on privacy when I got a smart (ish) phone.

Lamak

@JoeObbish who can blame you

@PaulWhite yeah, me too

Paul White

@Lamak everyone!

sp_BlitzErik

8:14 PM

i thought it was a football club

billink f.c.

Paul White

you mean soccer? ha ha no let's not go there again

sp_BlitzErik

i'm not even sure what soccer is anymore

in brooklyn it's mostly what uncoordinated kids do while their parents drink in the park

Lamak

isn't that baseball?

sp_BlitzErik

no that's the american business responsible for 90% of the cash flow into your part of the world

Lamak

@sp_BlitzErik don't get it

sp_BlitzErik

8:22 PM

okie dokie

Lamak

:'(

sp_BlitzErik

9:16 PM

New goal: have a higher reputation than Joe by PASS

Evan Carroll

Why are you editing a question that is almost a year old with a chosen answer? If you still have a question -- ask another question. — Evan Carroll QWER HJKL 21 secs ago

sp_BlitzErik

9:49 PM

why did you add weird stuff to your name

are you trans dvorak or something

Evan Carroll

10:08 PM

They're new Microsoft Certs.

sp_BlitzErik

neither of them start with m

sounds fishy to me, pal

every microsoft cert proudly begins with "microsoft"

Evan Carroll

Prove it.

You see. I asked two questions on SQL Server, so I'm kind of an expert on the subject now.

sp_BlitzErik

gimme a couple weeks, i'll start getting them

Evan Carroll

I guess I have 13 questions on [sql-server]

gold badge incoming.

sp_BlitzErik

traitor

what would mrs. postgres say?

probably send you packing to the clojure user group

Evan Carroll

10:30 PM

0

Q: Why is there a pricing disagreement in SQL Server?

SQL Server pricing says that the 2017 price is supposed to be the low, low, $3,717 USD. However, the checkout page for purchasing SQL Server shows the low, low, low price of $3,189 USD. Which price is right?

so complex.

ypercubeᵀᴹ

> ***Pricing represents open no level (NL) estimated retail price. For your specific pricing, contact your Microsoft reseller.

Evan Carroll

What does that even mean "open no level" and is that all I need, and if it's all I need why doesn't the pricing page even list it?

ypercubeᵀᴹ

List what?

Evan Carroll

the price.

ypercubeᵀᴹ

I have no idea what you are asking.

There is a price, it's an estimate.

There is not a single accurate price. It#s all too complicated.

And I have no idea why.

sp_BlitzErik

10:50 PM

it's like plan costing

even the actuals are estimates

Joe Obbish

the dealer gave me an inconsistent price on a lamborghini

can someone help me? it's very important

sp_BlitzErik

you should try negotiating with the serializable hint

Joe Obbish

@sp_BlitzErik I predict that you have some downvotes in your future

sp_BlitzErik

when you downvote me you downvote yourself

2

Joe Obbish

how so

sp_BlitzErik

10:58 PM

we are all one in the great columnstore

even the postgres heathbrins

Joe Obbish

if only there were chat downvotes

Evan Carroll

"We charge a lot of money for our products and sell them online. We're not exactly sure how much. 3kish. tias"

sp_BlitzErik

@JoeObbish i've been saying that for months

Joe Obbish

me too

I called them black holes

sp_BlitzErik

sounds racist tbh

Joe Obbish

11:03 PM

take it up with scientists

sp_BlitzErik

it's not like there's a science stack exchange

so are we allowed to have code challenges on here or what?

what's up with your meta?

Joe Obbish

doesn't feel like it

sp_BlitzErik

lame

Joe Obbish

I'm pretty disappointed overall in the community

sp_BlitzErik

rotten to the core

Joe Obbish

11:05 PM

if the question sucks then just downvote it

the main concern seemed to be around silly questions getting asked

sp_BlitzErik

voting rings, no code challenges, complacent mods

mods who SLEEP

the nerve

Joe Obbish

I mean, it's almost always possible to think of some made-up scenario for a question

so you can just do that and it'll be on topic

sp_BlitzErik

i think i have a fun one

i'll have to think of a good way to ask it

Joe Obbish

feel free to email it to me if you need a scenario

you might have to pretend to have a real job in the question though. is that ok?

sp_BlitzErik

maybe i'll have my sock puppet do it

Joe Obbish

11:10 PM

"I'd like to speed up my query by 4X and I have a MAXDOP 1 hint"

maybe he's roleplaying as a postgres developer

sp_BlitzErik

larping real hard

Joe Obbish

can that guy really do anything? 188313

Evan Carroll

I wonder how many people do non-purchase mail in entries of Sweepstakes.

Microsoft has one going now once a week. It has some nice prizes. You can either buy their software, or because of regulations -- mail in a card with your information and be entered to win.

sp_BlitzErik

send an email to pgsql-sweepstakes

Evan Carroll

Why doesn't Pg bribe people to use their stuff?!?!

sp_BlitzErik

11:22 PM

no money?

Joe Obbish

does TF 4199 even do anything on that version?

sp_BlitzErik

you're rambling

wombling?

Joe Obbish

me?

talking about this question, like I said

4

Q: TSQL Improve Query Performance Help Required

TSQL MSSQL2008r2 I have been tasked to improve the performance of the query (within a proc) shown in the query execution plan link below. It currently executes in around 7 seconds and this is needs to complete in 1-2 seconds if possible. The results of the query trickle through. The tables be...