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

Aaron Bertrand

6:00 PM

HA

FreshPrinceOfSO

execution time: 275 minutes

Aaron Bertrand

@Zane do you want updates or no spoilers?

Zane

@AaronBertrand I heard you scored while trying to dink around and pirate the game on my phone.

Aaron Bertrand

@Zane yes it was pretty

Zane

I got the audio to work.

This is sad.

I'm pirating the game on a flash enable browser on some malware filled shit site.

20 years ago it would have been easy to just find an AM radio station.

ypercube

6:07 PM

@Zane What are you looking for?

The Olympics?

Zane

@ypercube Yeah.

Hockey game.

swasheck

nbc was so generous ... they gave me 4 minutes of live preview

Zane

@swasheck NBC radio talking NBC all star game and the end of the trade deadline.

I'm going to write them the biggest fuck you letter of all time.

swasheck

@Zane toolbags

nothing says "North America" like rampant greed .. i mean ... ahem ... leveraging the free market for the benefit of the consumer

Zane

I have a meeting at 1 or I would be at the TGI Fridays across the street.

@swasheck The idea that there is a free market in cable service is a joke. It's abismal.

ypercube

6:11 PM

Does any of these links work for you? sportcategory.com/c-11.html

Zane

Sounds like the ice is crap.

swasheck

the winter surfaces have been crap during the entirety of the games

Zane

@ypercube Big add I can't get rid of.

Have audio good enough.

swasheck

@ypercube i have to get off the corp vpn

Zane

F this noise I'm getting lunch.

billinkc

6:46 PM

0

Q: Being naughty - any tricks to "select * into" existing table using SSIS or another tool? (MSSQL Enterprise Ed. 2012)

Normally, you're not supposed to do this. I do have a good reason, which I'll explain: TableA contains some time dependent data. TableB is created programmatically by calling "Select * from TableA into TableB", given some customizable parameters about what time interval to select from Table A. T...

swasheck

not looking good

haha. flop.

Cougar9000

@ShawnMelton it is a popular tool that is referenced quite often, thought the general community might benefit from it. No biggie

bluefeet

@swasheck prob good you deleted that comment :)

swasheck

7:01 PM

:D

i'd be surprised if us's passing % is over 30%

one shot. retreat.

Zane

We don't deserve to win that game.

swasheck

we'll still protect you and let you be our hat, canada

billinkc

The 90s are calling, is anyone aware of a anonymous ftp sites?

bluefeet

heapers you are slacking on vtc this one

0

Q: Pivot Table, client server solution

I am looking for a pivot table which is able to deal with big data(it can be a commercial library). I have about of 24 mln of records which require about 6GB of RAM. I need a client server solution, to specify criteria on client side compute cube on server side were I have up to 30GB of RAM a...

data pivot

billinkc

I had found ... ftp-sites.org which purports to have a list of all the public sites but I was hoping for something a little less sketchy

Government site would be ideal

Nevermind, seems I wasn't specific enough census.gov/acs/www/data_documentation/data_via_ftp

FreshPrinceOfSO

7:18 PM

vtc

-1

Q: Editing finished mysql table

I'm new to mysql and I want to edit my Table. My primary key should be auto generated. So where can I get the option to edit my table? thanks

mysql sql editing

Zane

7:33 PM

@AaronBertrand if it weren't for Jonathan Quick that would have been a 7 nothing game.

swasheck

@Zane that's generous. i only watched the 3rd period and counted Quick robbing 5 amazing chances. based on the commentary, canada should have been up 3-2 after 1

bluefeet

um, wow

►

Lamak

@bluefeet I am now one of the guys that has most videos and images blocked from work. So, what is it?

Zane

@swasheck The only goal he let it would have been impossible to stop.

bluefeet

@Lamak cats throwing up hairballs to techno music

Lamak

7:40 PM

oh.....ok

bluefeet

you can't unsee it

Zane

@bluefeet Classy lady.

:)

bluefeet

it is in sync with the music

Zane

I'm going for it. For some reason.

On my phone.

Where did you find this? Why did someone make it? Why do people film their cats throwing up?

bluefeet

@Zane i saw it on huffington post

Zane

7:44 PM

You're supposed to go get paper towels for them to throw up on or something.

Brilliant.

bluefeet

@Zane I don't have a cat so I wouldn't know. I'm a dog person

Zane

@bluefeet Well when your dog starts to yak you put it outside right?

bluefeet

@Zane we pick them up and run to the tile :)

they have puked enough on the carpet

Zane

@bluefeet See same thing don't get the camera. You only have precious moments to spare before you are cleaning vomit off a rug.

@swasheck I don't think @AaronBertrand is coming back my guess is he's already at a bar having a good time.

swasheck

dont blame him

Zane

7:52 PM

Blame him?

swasheck

i dont blame him for celebrating

Zane

Oh I don't. I would have done the same if we pulled off the come back.

I'm just going to shut my big dumb mouth about sports predictions.

bluefeet

well I hope you guys are voting :)

Aaron Bertrand

Voted

bluefeet

glad we have some time, because I'm still decided on 2/3

swasheck

8:06 PM

voted2

Zane

Is it actual election time?

bluefeet

yes

Zane

Well one vot is cast not sure who's getting 2

or 3

JNK

8:26 PM

I'm not casting a 2nd or 3rd choice

Zane

@JNK Good call I don't really care about the rest. Just @bluefeet

bluefeet

@Zane aw shucks

Aaron Bertrand

@JNK I'm not entirely clear on how these STV methods work. Do you think voting for only one candidate makes it more or less likely that someone you don't want elected will get in, vs. voting for three candidates?

@JNK Not challenging your choice, just curious about your thinking.

I made 2nd/3rd choices but not sure if I should (or how to undo them if I shouldn't)

Shog9

If you don't use your second vote and the person you select as your first choice gets elected without needing your vote, you're effectively throwing away your opportunity to influence the second place candidate.

112

Q: How are moderator election votes counted, in plain English?

The election pages' sidebars state that Stack Exchange elections use the Meek STV vote-counting method: After m days, the final voting results will be freely downloadable from this page forever, and we will calculate the n winners using OpenSTV with the Meek STV method. How does that work? ...

support election

@JNK, @Aaron ^^^

Zane

@Shog9 Don't have a strong enough opinion for that.

For the second and third candidates.

Shog9

8:32 PM

@Zane then VOTE MEAGAR!

Zane

I want to do a write in ballot for Spider-Man.

Aaron Bertrand

I voted Meager and Undo (Undo is already a moderator on another site)

Shog9

@Zane Or, y'know, go read the candidates' answers to questions on meta until it becomes clear who you want

Aaron Bertrand

Probably shouldn't have told you guys that, but tough

Shog9

@AaronBertrand yeah, as of like half an hour ago

JNK

8:34 PM

@Shog9 Yep I realized that, didn't have strong enough feelings about anyone else

Aaron Bertrand

@Shog9 I didn't say "...with a proven track record." :-)

Zane

@JNK See same. I read that but no one in particular stood out.

Aaron Bertrand

@Shog9 way TL;DR for me today, sorry :-)

JNK

I'm a person who when I vote for like county commissioner or whatever, if I don't know about the candidates I typically won't vote

Shog9

@AaronBertrand well, that's why I gave the tl;dr above it ;-P

Aaron Bertrand

8:35 PM

@JNK that doesn't mean you can't learn about the candidates. You have plenty of time

Shog9

...aaand I just now realized I wasn't in the election chatroom

JNK

@AaronBertrand yep this is true

Phil

8:46 PM

Votes for Bluefeet

Aaron Bertrand

@Phil lemming

Phil

... And 2 randoms that aren't Bohemian

Zane

@Phil Meta whining turn you off?

FreshPrinceOfSO

@bluefeet good luck!!

You have ~~4 days~~ 25 minutes to vote for @bluefeet here.

4

^ star & pin that

Zane

9:02 PM

Already done that.

bluefeet

@AaronBertrand meanie!

Phil

@Zane yeah

swasheck

9:21 PM

@AaronBertrand this is related to the plans i emailed you yesterday. answers.sqlperformance.com/questions/1509/…

Aaron Bertrand

@swasheck thanks, haven't had a chance to look yet, between the hockey and a sick daughter

swasheck

@AaronBertrand i know your world doesnt spin around the axis of my email. i was just giving you more info on the question on the site. also, very sorry to hear about your daughter. what is it?

Aaron Bertrand

@swasheck no, I appreciate it, just letting you know I haven't looked yet. Madeline had 103+ fever overnight, better today but we had to keep her home.

swasheck

man - that's hard. you can't do anything but help manage it but you know they're miserable.

JNK

room topic changed to Vote For Bluefeet™ HQ - The Heap™ - Consultancy ©®: General on- and off-site discussion for dba.stackexchange.com [mysql] [nosql] [oracle] [postgresql] [sql-server]

@AaronBertrand I like how you ranked those things

eminently Canadian

2

bluefeet

9:33 PM

@JNK LOL!

JNK

@bluefeet I thought about doing it earlier but kept getting distracted

Aaron Bertrand

@JNK well she slept through most of the hockey game, so...