The Heap™ – Consultancy ©®

Thomas Stringer

00:00

@rfusca Haha which RDBMS?

@SQLKiwi One could only dream....

rfusca

@ThomasStringer pick one and I probably do something with it. Mainly Oracle, Postgres, and Teradata these days

a touch of MySQL and SQL Server

Thomas Stringer

@rfusca Wow, talk about the full gammit (I have no idea how to spell that, and way too lazy on a Friday night to actually look it up)

SQL Kiwi

Wow a generalist. Aren't they endangered?

Thomas Stringer

@SQLKiwi Find that corner, and dive deep, deep, deep :-)

rfusca

@ThomasStringer ya, it makes life ...interesting

Thomas Stringer

00:04

@rfusca Sounds like it

rfusca

@ThomasStringer its gamut btw

@ThomasStringer you're a sql server fella right

Thomas Stringer

@rfusca Yep, that's correct. Purely SQL Server.

rfusca

@ThomasStringer lucky to be pure...but eh, sql server ;)

Thomas Stringer

@rfusca Ouch :-)

@rfusca I can't imagine working with any other RDBMS. I love it too much

rfusca

lol

brb

@ThomasStringer ya, i really would only use postgres given the choice

Thomas Stringer

00:08

@rfusca That's interesting. Any particular reason?

rfusca

teradata feels like you're working in the 90s and Oracle feels like your hands are tied. pg is really flexible and unsurprising

Thomas Stringer

@rfusca Very cool indeed

rfusca

@ThomasStringer who do you work for?

Thomas Stringer

@rfusca Microsoft

@rfusca You?

rfusca

@ThomasStringer oooooooooooooooooooo

@ThomasStringer transcore

Thomas Stringer

00:15

@rfusca Ah, nice

rfusca

transcore.com

Thomas Stringer

@rfusca Sounds like a very cool environment. Looks like it'd be chock full of data :-)

rfusca

lol chock full of data is probably right

but they've had a string of terrible dbas

@ThomasStringer most of the data i work with is rail related

but i just moved to atl from arkansas

Thomas Stringer

@rfusca How are you liking it here? I like the city.

rfusca

@ThomasStringer its good, we like it

alpharetta seems nice

but the commute is rough

but raising a family ITP wasn't really an option

Thomas Stringer

00:21

@rfusca I hear ya. Very similar situation for me, wife and two kids.

rfusca

@ThomasStringer yup, wife, two kids

Thomas Stringer

@rfusca Haha Talk about coincidence

rfusca

@ThomasStringer ya, you, me, and a whole 100 million other people ;)

Thomas Stringer

@rfusca Well....maybe not that coincidental :-)

@rfusca hahahahahahaha

rfusca

must be neat to work somewhere like microsoft

Thomas Stringer

00:24

@rfusca I like it a lot

@rfusca But data is data! It's all fun :-)

Hey, @ConcernedOfTunbridgeWells, long time no talk!

ConcernedOfTunbridgeWells

Well, back safe and sound folks. A good time was had by all.

@ThomasStringer Indeed. If it didn't catch your attention we had the London Christmas drinkies tonight.

Thomas Stringer

@ConcernedOfTunbridgeWells It didn't. That sounds like a fun time :-)

rfusca

@ThomasStringer yup!

ConcernedOfTunbridgeWells

@ThomasStringer Give us some advance warning if you come across the ditch and we'll organise one for you ;-}

Thomas Stringer

@ConcernedOfTunbridgeWells :-) Will do. You'll be the first to know!

ConcernedOfTunbridgeWells

00:27

@ThomasStringer I'm sure we will. How's life there in 'merica

Thomas Stringer

@ConcernedOfTunbridgeWells Pretty good. A little chilly at the moment, but I bet you guys are even colder, huh.

ConcernedOfTunbridgeWells

@ThomasStringer Not so cold tonight although it's been quite wet. I've been working out of town and it's fairly cold there.

Thomas Stringer

@ConcernedOfTunbridgeWells Whereabouts?

rfusca

@ThomasStringer its been a veritable summer here though

and like 70s this weekend

ConcernedOfTunbridgeWells

@rfusca This summer was pretty crap here.

Thomas Stringer

00:29

@rfusca Ah, yes, but the summer is excellent! I'll take extreme heat over cold any day of the week

rfusca

in arkansas, we were a near 10 degrees hotter on avg than atl

Thomas Stringer

@rfusca What?! That's 10 degrees that they can keep :-) That's a bit too toasty

ConcernedOfTunbridgeWells

I went to Malta a couple of months ago and caught up with @gbn. It was pretty hot there, although not mid-summer.

Mark Storey-Smith

@ConcernedOfTunbridgeWells Richard dispatched on the Northern line, heading for Mordor

rfusca

we had so many days that were near or over 110

Thomas Stringer

00:30

@ConcernedOfTunbridgeWells Nice! How's @gbn doing?

ConcernedOfTunbridgeWells

@MarkStorey-Smith Excellent.

@ThomasStringer He was quite happy at the time. Had a new significant other.

Thomas Stringer

@ConcernedOfTunbridgeWells That's good.

rfusca

i wonder if anybody else in the atl area

bluefeet

@SQLKiwi no objection except it is old. I would not downvote for it. Just point out to them they are using old join syntax

ConcernedOfTunbridgeWells

@rfusca Don't know. The 'merkin side seems pretty widely dispersed. Even @jcolebrand and @caderoux are out of staggering distance.

jcolebrand

00:32

Well I used to live in Atlanta, and have friends there.

What's the question?

rfusca

yup

jcolebrand

Additionally, yeah, we're well outside the concept of staggering distance

ConcernedOfTunbridgeWells

@jcolebrand I think it's around the practicalities of meeting up for drinkies.

Thomas Stringer

@rfusca Not that I know of

jcolebrand

from my house to the nearest pub currently is at least 2 or 3 miles, and I live in one of the larger cities in the US, in one of the highly trafficked areas.

Thomas Stringer

00:33

@jcolebrand Which city?

ConcernedOfTunbridgeWells

@JackDouglas lives about 15 miles away from me and @MarkStorey-Smith shares a train line, so we've met up for drinkies a few times now.

jcolebrand

@rfusca I'm sure there are a few folks about but there's only like 15k on the site, no?

@ThomasStringer Dallas TX

Thomas Stringer

@jcolebrand Cool, good BBQ

rfusca

brb, kid, bath

Mark Storey-Smith

@jcolebrand That would necessitate a move

Thomas Stringer

00:35

@MarkStorey-Smith Haha

jcolebrand

However, the next time I'm in Atlanta I'll definitely poke you @rfusca

And ya'll remember Eric Humphries helping out here when the site first got started? @lotsahelp?

He's out here, we've had dinner together (I swear that's the name, I'm normally about 40/60 on remembering names)

Thomas Stringer

@jcolebrand Yep

ConcernedOfTunbridgeWells

@jcolebrand I live quite a way out of town and in a fairly sparsely equipped area for pubs, and there would be at least half a dozen in that range. If I lived in London there would be more like 50.

jcolebrand

@ConcernedOfTunbridgeWells exactly

@MarkStorey-Smith to be fair, I'm in the market starting next month for a place to move into

ConcernedOfTunbridgeWells

@jcolebrand A tad style-cramping.

Oh well, folks. Happy drinkies day and compliments of the season; I've got something I need to get up for tomorrow so I must go to bed. Have a good evening and don't do anything I wouldn't. You can ask @MarkStoreySmith what I've been up to.

Mark Storey-Smith

00:39

@ConcernedOfTunbridgeWells Cheers :)

jcolebrand

I'm pretty sure that just rules out straight heroin injection into the brain ...

:p

ok, somebody figure out why my checkboxes aren't working?

ConcernedOfTunbridgeWells

@jcolebrand Yes, it does. Alcohol is my drug of choice ;-}

rfusca

dang i'm on a legacy google storage plan and now its way more expensive, like 6 times the price

Phil

@ConcernedOfTunbridgeWells What's this I've missed about beers?

ConcernedOfTunbridgeWells

@Phil We had dba.se drinkies tonight.

Phil

00:48

Oh. Fail

:)

I didn't know

ConcernedOfTunbridgeWells

@Phil Bummer. You should really come down for drinkies at some point.

Phil

Will do. May well move to London early next year

Mark Storey-Smith

@Phil You were invited... pay more attention in class!

Phil

Then your liver will take a battering :D

ConcernedOfTunbridgeWells

@Phil A few pints is enough for me. However we'll quite happily consume popcorn and watch you getting trollied ;-}

Phil

00:50

Lalala

ConcernedOfTunbridgeWells

@Phil Still, give us some advance warning when you're down next and we'll arrange something.

Phil

Fires up Jobserve

Can't be arsed to look for a job before Christmas though

Mark Storey-Smith

getbuckyballs.com/order/buckyballs

Phil

Not the time for it. January will be slow too, I'll wait until Feb

Mark Storey-Smith

Get 'em before they close!

ConcernedOfTunbridgeWells

00:52

@Phil We've already had the christmas drinkies. No hurry though. We can wait for you to get something.

Mark Storey-Smith

Or they change marketing ploy

jcolebrand

fixed my checkbox, no thanks to the gits gettin plastered in here ... who's buying me round tonight?

oy

uh huh, I see

ConcernedOfTunbridgeWells

@jcolebrand Got a paypal account?

jcolebrand

@ConcernedOfTunbridgeWells lol

ConcernedOfTunbridgeWells

@jcolebrand I'll paypal you a few bob to go drinkies on if you want.

jcolebrand

00:55

pffft

Phil

Send the monies to [email protected] - All will be sorted :P

jcolebrand

I've got the cash, I've just got no mates

2

@Phil smart trick ;-)

ConcernedOfTunbridgeWells

@jcolebrand Bummer

Phil

(Don't care about my address being public)

Tim Stone

@jcolebrand I paid for drinks last night, so. Also, I'm not your type. ;)

jcolebrand

00:55

@TimStone No, she'll be here .. uh ... /me scurries to the TBR

Tim Stone

Hahah

Mark Storey-Smith

@TimStone You're like the se.chat overlord... always listening in from the sidelines :)

Tim Stone

I liked to keep people on their toes.

jcolebrand

@MarkStorey-Smith the first rule about being a chat overlord ...

Phil

Grabs a beer from the fridge

ConcernedOfTunbridgeWells

00:57

@TimStone We're not even sober.

Phil

Bad influences, the lot of you

ConcernedOfTunbridgeWells

@Phil Cheers.

@Phil Bollocks.

Phil

Honest, guv

Tim Stone

@ConcernedOfTunbridgeWells Making the whole "on your toes" business all the more amusing, clearly

Phil

@ConcernedOfTunbridgeWells My email address is above. Mail me your personal one. Only had your LV one before

Mark Storey-Smith

00:58

@phil Would it surprise or disturb you to hear that technically, I just re-started work.

ConcernedOfTunbridgeWells

@TimStone Blargle Blargle fnaaargh. (best read in a drunk Glaswegian voice)

Phil

@MarkStorey-Smith Depends what the surprise is. Never had my balls tickled over the internet before, for example....

ConcernedOfTunbridgeWells

@Phil Done.

Mark Storey-Smith

And I've no idea how or why that message was linked to your previous. Perhaps I should rethink the maintenance I'm undertaking for the next 2 hours

ConcernedOfTunbridgeWells

@Phil I'll take your word for that.

Phil

01:01

@ConcernedOfTunbridgeWells Received. Buy yourself a domain!

ConcernedOfTunbridgeWells

@Phil I have considered data-whisperer.co.uk at one point.

But I can't be arsed writing any content to put up on it.

Many years ago I tried to get fatbastard.com but it's owned by a california winery that has a vintage called old fat bastard.

Mark Storey-Smith

@ConcernedOfTunbridgeWells redirect it to dba.se as a mock protest at our site name :)

ConcernedOfTunbridgeWells

@MarkStorey-Smith I suppose I could.

Given that my entire internet presence consists of stuff posted on stackexchange sites.

Phil

You don't need a website to have a better email address

Get yourself a personal domain for email

rfusca

benedict cumberbatch in the new star trek movie...awesome

jcolebrand

01:11

later fellas

ConcernedOfTunbridgeWells

@jcolebrand Bye

Phil

01:39

Are you all dead from too much beer?

rfusca

@Phil lol

Mark Storey-Smith

@Phil Working :)

And in between, trying to answer a dba.se Q without sounding like I've had too much beer.

I think I'm going to fail... on the Q anyway

SQL Kiwi

02:17

1

A: How Can the Same Query in Two Nearly Identical Instances Generate Two Different Execution Plans?

Execution plans (actual, not estimated) need to be added to the Q for a definitive answer but... How Can the Same Query in Two Nearly Identical Instances Generate Two Different Execution Plans? Because, by your admission, they are not identical. Most likely explanation for the different e...

This guy sounds like he's been on the beer ;)

Mark Storey-Smith

@SQLKiwi I thought he hid it quite well, considering :)

SQL Kiwi

@MarkStorey-Smith Well you would, you're drunk!

LOL no it's fine - I upvoted.

Mark Storey-Smith

The original attempt (not posted) was basically a list of ranting noise along the lines of "NOLOCK!!!, CROSS DATABASE JOINS!!!, DIFFERENT ROW COUNTS!!!, ARARARAGEHHHH"

4

Q: Bulk insert into SQL Server from VMWare guest using distributed switch

This is mostly likely not a SQL server issue but the setup seems to only be affecting BULK INSERTS to SQL Servers. We have recently moved VM Hardware and all the guests that were moved had their virtual switches changed from standard to distributed. I then started receiving A fatal error oc...

Interesting

SQL Kiwi

Ah and there's an ISNUMERIC test too, just for kicks

Mark Storey-Smith

@SQLKiwi Lots of facepalm, little to work with

Phil

02:31

Noting says facepalm more than my avatar

Mark Storey-Smith

@Phil Hangover or server crash? Always wondered which it was.

Looks like hangover

Or possibly post long liquid lunch

Cade Roux

03:24

Damn, C.J. Date wrote a vicious letter to Communications of the ACM regarding Erik Meijer's article from September "All Your Database Are Belong to Us", saying "It is difficult to believe the article was peer reviewed". Meijer responds "building industrial-strength relational ... requires leaving the ivory tower"

So speaking of beers - I did manage to finally meet my little data warehouse project owner who has some tenuous connection to New Orleans and we had beers last night at a local pub/bar/tavern. And it looks like there is a lot more work coming my way, which is nice.

@SQLKiwi ISNUMERIC('1E10') => never use ISNUMERIC unless you really don't particularly care for your query to actually work in the real world.

@ConcernedOfTunbridgeWells Yeah @jcolebrand isn't even in Louisiana any more.

I was amused to find out that the little DW I built for them in 45 hours (which is populating every hour from their data) is about the only thing in their startup which is reliably working to expectations. He was amused to see I could easily monitor the hourly loads from my Android phone/tablet using pushover for notifications and mercurial to check the logs into my repository.

Seems like they will be a good client. All their development resources are customer facing - so they need back office automation.

dezso

07:28

What an unhygienic question is this? User drops? broaaf

0

Q: How are these two user drops different?

Other than the obvious, what is the difference between: drop user user_01@host01; and drop user 'user_01'@'host01'; In a sample test, they both achieved the same result. From Account Names docs (5th bullet point), looks like they are not the same ... yet they appear to do the same thing ......

mysql-5.5 users

Transcript for

The Heap™ – Consultancy ©®