The Heap™ – Consultancy ©®

« first day (1962 days earlier) ← previous day next day → last day (3205 days later) »

Paul White

04:57

@AndriyM No.

3 hours later…

Master Database

08:26

Q: Anonymize SQL Code

Once a user of DatabaseAdministrators told me a webservice or something similar that can help to make SQL Code obfuscated so that meaningful/distinctive fields / column names / variables are anonymized and won't allow any conclusions to companies or products. I need this to post code into questio...

3 hours later…

ConcernedOfTunbridgeWells

11:16

5 hours later…

ypercubeᵀᴹ

16:32

No, not really. Performance will be identical, both in SQL Server and MySQL. Why should it be any different? Is there any evidence to support this claim? — ypercubeᵀᴹ 41 secs ago

Lamak

pfft, who needs evidence?

swasheck

@ypercubeᵀᴹ unless the sql server optimizer slips in a cartesian intermediate

Tom V

@swasheck Are you serious this time?

sincere question

swasheck

@TomV i've only heard of it happening and have never witnessed it.

Tom V

I'm asking because I have a déjà vu of an answer I posted to the same question for SQL Server

swasheck

16:43

iirc i read somewhere that sometimes star syntax and table,table,table where = = = = on newer engines may misunderstand. that could be completely bogus and total hogwash.

ypercubeᵀᴹ

@swasheck are you refering to the *= and =* joins?

swasheck

@ypercubeᵀᴹ yes

ypercubeᵀᴹ

Ok. That's was not asked in the specific question though.

The q was about old comma joins and JOIN syntax

swasheck

i didnt read

ah. ok.

ypercubeᵀᴹ

By the way. I had a discussion in a SO recently

swasheck

16:46

congratulations

ypercubeᵀᴹ

Soemone claimed that SQL Server had a *=* join too (FULL JOIN)

I think that never existed but I can't be sure. Has anyone seen such a query/syntax?

swasheck

i dunno

ypercubeᵀᴹ

Considering that =* and *= existed in 2000 version (and I guess earlier) and were only deprecated recently (2008R2 or 2012?)

and there is no mention of *=* in any MSDN page, I find it very unlikely that such syntax existed, even in versions 6 or 7.

swasheck

i mean ... the best way to test it would be to try it

ypercubeᵀᴹ

@swasheck yeah but I don't have a version 6 available ;)

Paul or Aaron might have a CD somewhere

Paul White

16:55

@ypercubeᵀᴹ Ha! No.

swasheck

then we're doomed to speculation

ypercubeᵀᴹ

Did they use CDs back then?

swasheck

@ypercubeᵀᴹ 3.5" "floppy" disk

Paul White

6.5 came on cassette.

swasheck

@ypercubeᵀᴹ i dont think that @aaronbertrand loves us anymore

Lamak

16:58

silly @swasheck, he never did, he only tolerated us ;-)

swasheck

good point

Paul White

@swasheck He does, he just doesn't visit the heap much. No names mentioned.

None of the regulars though!

swasheck

ah. so we have a new one, eh?

used to be RTK

Paul White

@swasheck Indeed. My understanding is the latest was simply the last straw.

Also, he's busy now he has a real job.

swasheck

@PaulWhite oh yeah? what's that?

Paul White

17:01

@swasheck "Product Evangelist"

swasheck

street preacher

nice

Paul White

Also I think hitting 100K represented a natural stepping back point.

Lamak

@PaulWhite damn @billinkc

Paul White

@Lamak Ha ha ha

Tom V

Same thing with dezso?

Paul White

17:05

@dezso Where have you been? We miss you.

Tom V

Maybe he never got home from his trip to, what was it, dublin?

swasheck

17:18

too much guinness

Paul White

Apr 11 at 16:11, by dezso

good afternoon from a very rainy Dublin

Yes, Dublin.

Tom V

I'm an elephant

Paul White

So it seems!

-3

Q: Where can I lean database?

What website can I learn database from? websites like Codeacademy's teaching style ect. tnx for you time.

database-administration

Tom V

If not for my memory, because I'm often the elephant in the room

Paul White

^^^ Against the wall?

swasheck

17:30

@PaulWhite i prefer my databases plump and juicy

Paul White

I see what you did.

swasheck

nice, @TomV ... google.com

Tom V

@swasheck If you're talking about the comment, that's another Tom

Andriy M

Double Tom

Paul White

Double gone.

swasheck

17:35

my attention to detail is lacking today

Paul White

I was looking for a good duplicate for that question, but it probably wasn't worth the effort.

Tom V

@AndriyM What are words worth? :) -Tom Tom club

I would never post a sarcastic comment

swasheck

17:56

@TomV my mistake

billinkc

18:19

/fistshake

mmarie

18:40

@swasheck what time are pre-meeting drinks?

swasheck

415-ish ... darcy's

bring weed

mmarie

I don't control her.

swasheck

@mmarie never said you did. just influence

mmarie

a text has been sent

swasheck

donkey shame

mmarie

18:43

:-)

Why does it have to be so far away? (distance, not time) It takes 45 minutes to get there. from here.

I got a response. There will be Weed.

swasheck

it's close to the event location

mmarie

which is also far away from me

remember, i don't have to drive anywhere every day so i'm spoiled to no traffice.

swasheck

well you have to arrive at the event location anyway, don't you?

ypercubeᵀᴹ

@mmarie thnx for clarifying.

At first I though @swasheck meant "weed" and not a person.

Paul White

Me too!

But then I remembered @swasheck has no shift key.

swasheck

18:47

WHAT ARE YOU TALKING ABOUT????

Paul White

OMG!

dezso

@TomV smbc-comics.com/?id=3520

Tom V

@dezso :D

dezso

thanks for asking, I got back to Berlin, but am really busy recently

Tom V

-1

Q: PostgreSQL community channels other than mailing lists and IRC?

Is there an active channel for the PostgreSQL community other than the official mailing lists and IRC? I'd hope to find a forum-like channel. This is the 21st century after all...

postgresql

Guy seems to be asking on a forum for a forum

dezso

18:54

Are forums so 21th century, by the way? — dezso 15 secs ago

Paul White

@TomV Well, to be fair, we are Q & A, not a forum, and discussion is off-topic. We do have chat I suppose.

dezso

@swasheck only one

swasheck

@dezso that's too many for me

dezso

the others were (don't remember)

@swasheck not my favourite either

but there are many others, the craft beer revolution reached Ireland, too

Paul White

Ooo I haven't had a Guinness or a Murphy's for years.

Tom V

18:58

@PaulWhite You tried it once and you're thinking about having another one?

dezso

@PaulWhite they both taste better from a pint glass than the 0.5 litre one

Paul White

@TomV Ha, yes. I know it's personal taste, but I am rather partial to it.

@dezso I'm sure!

Some things should never go metric.

Actually, I can only think of that one thing :-/

dezso

@PaulWhite yes, it is so straightforward to count with cubic inches, fl ozs and gallons :D

swasheck

kids are so cute

Paul White

@dezso Speed of light: one foot per nanosecond.

dezso

19:09

@PaulWhite the well known New Zealand Short Foot, yes

Paul White

Short Hairy Foot.

« first day (1962 days earlier) ← previous day next day → last day (3205 days later) »

all rooms

Transcript for

May18

May '1619

May20

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