The Heap™ – Consultancy ©® - 2015-02-26 (page 2 of 2)

Zane

6:01 PM

/sigh fine...

Paul White

Zane

@Phil mysqlrockstar.blogspot.com

Paul White

Surely an oxymoron.

swasheck

@PaulWhite right. ostensibly that would fall under testid = 3, i just dont see where that happens. and if it did, the cost of implicitly converting (n)varchar into nvarchar is significantly less than converting nvarchar to varchar.

Andriy M

@Zane Thanks!

Phil

6:02 PM

Erm, how about "no":

Pease, mark it as an answer if it was correct. it will end the post. — Rafael Piccinelli 16 mins ago

Paul White

@swasheck Er what testid = 3? Are you looking at something I can't see?

swasheck

@PaulWhite in the linked post in @Zane 's answer. (sqlperformance.com/2013/04/t-sql-queries/…)

Andriy M

@Phil How come that question is still not migrated?

Not that I'm asking you personally, @Phil, of course

Phil

Not enough votes yet

Andriy M

Partly my fault, because I still have not enough rep to vote yet

Paul White

6:09 PM

@swasheck In test 3, the string is typed as Unicode. In the current example, the string uses Unicode characters, but is nevertheless typed as non-Unicode.

@swasheck As far as "where it happens" is concerned: it happen at parse time.

The string '男孩 SQL' never exists, it is parsed as '?? SQL'

There doesn't have to be a destination column.

ypercube

@AndriyM shame on you, spending time on SO instead of here ;)

Paul White

@swasheck Try SELECT TOP (1) '男孩 SQL'; for example - and look at the Compute Scalar expression.

Andriy M

@ypercube Guilty as charged!

Paul White

Chameleon questions: I didn't have a clear question, I needed some free consultancy.

swasheck

@PaulWhite which was my original point ... that jonathon's post doesnt seem to address the exact circumstance here

am i wrong?

(i normally am so i'm not trying to be a jerk)

Paul White

6:19 PM

@swasheck Arguably not. Then again, Zane's answer only references that article for "more information", which is accurate enough.

billinkc

But you're also normally a jerk so those cancel out

swasheck

@PaulWhite yeah. i know. i'm just trying to sort through my thoughts on how jonathon's post applies to this circumstance. my initial reaction is that it doesnt

k thanks

@billinkc takes one to know one

Paul White

It's not directly about the root cause, no.

billinkc

I embrace who I am

Lord knows, no one else will

Paul White

But really only Zane could tell you for sure what he intended.

billinkc

6:20 PM

Gotta wear a porkchop around the neck just to get the dog to play with me

Paul White

Aw.

swasheck

@PaulWhite thanks for the help. it wasn't specifically aimed at trying to discredit @Zane ... it was more to see if he knew something that i didnt know and was trying to pick his brain for what it was.

bahahahahaha

Paul White

@swasheck I didn't think you were trying to discredit Zane, just saying I can't know what his intention was.

swasheck

i just wanted to make sure it didnt come through that way.

Paul White

It didn't.

Phil

6:30 PM

Fight!

billinkc

^^^

It's a triangle of death between Zane and JNK and Zane vs Swasheck

swasheck

i'm the underdog

live my life on a lullaby

bluefeet

why is everyone fighting?

late to the party, being lazy like @swasheck and not reading the transcript

billinkc

It's how the song goes

Everybody was kung-fu fighting

Lamak

@bluefeet @Zane vs @JNK is a death match for the Bozar position. @swasheck vs @Zane just because

swasheck

6:36 PM

it's me against the world

Phil

Customer service at its finest:

Zane

Like I said Seth I copied it from an internal blog I did

Phil

mobile.twitter.com/tescomobiIecare/status/570693152488755202

swasheck

@Zane totes

Paul White

We weren't fighting.

Ok, Thanks all for your answers. — Vikas Ahlawat 47 mins ago

I wonder if he learned anything.

Like how to make an answer 'accepted', for instance.

swasheck

6:46 PM

@billinkc ... i just made some changes to a onenote book and instinctively did a quick ctrl+s. thought you'd appreciate that

billinkc

Warms the cockles of my heart

swasheck

@Zane nevermind. re-reading that, "totes" made no sense. was on the phone with microsoft support.

JNK

@Phil awesome

billinkc

Still writing code for SQL Server 2000 in 2015. Bless your hearts

0

Q: Windows 2000 DTS package error

Hi All i am getting the below error message for an DTS package Error on Line 34 Multiple -Step OLE DB operation generated errors. Check each OLE DB status value , if available . No work was done . Below is the code for that '******************************************************************...

dts

swasheck

> This is the official Parody Twitter account of Tescnot Mobile’s UK based Customer Care team. You can also get help from Frank. We're not here to help.

@billinkc in the most southern way possible

JNK

6:50 PM

@billinkc You should move out Missouri, as it's 2015 everywhere else.

Zane

Sorry for missing all of those questions I was out eating a big ole torta.

billinkc

@JNK Beat you to it

JNK

oh you meant the header comment

lol

the header does say the date on the file is 2013

I was about to give you credit

billinkc

That's what I .. too clever for my own good

I am sending an email to the sqlsupport account asking them why they're doing this

Since that turd keeps posting email addresses in the clear

JNK

Seems like a reason not to outsource

swasheck

6:53 PM

send some to annette, belinda, and tina

JNK

why is there a hardcoded date in there?

billinkc

because vb

Paul White

Because softcoded is unreliable

swasheck

@JNK everything going on in that post and you're rankled by the date? :)

billinkc

bit rot is a bitch to detect

JNK

6:55 PM

if you always call the SP with the same params put it inside the SP

Paul White

Clearly JNK's first time looking at an SO question.

Though that one is admittedly toward the far end of the curve.

billinkc

I'm sort of disappointed that ppap.hvwan.net isn't publicly available

Zane

@Lamak because he has it coming!

:)

swasheck

natch

Lamak

yeah, he does

swasheck

7:05 PM

you guys are meanieheads

Zane

7:18 PM

Pretty much.

Lamak

that's kind of our thing, right?

Phil

We're supposed to be mean. That's why we all get along so well

Lamak

exactly

except @JackDouglas

swasheck

he's a nice guy

Phil

room topic changed to The Heap™ - Consultancy ©®: General on- and off-site discussion for dba.stackexchange.com [aaron-is-a-dad-again!] [gbn-just-got-married] [lamak-for-cm] [meanieheads] [mysql] [nosql] [not-too-many-vertica-folk] [oracle] [postgresql] [sql-server]

2

JNK

7:26 PM

wait gbn is married

that was on there before I'm sure

Lamak

it's still there

Phil

JNK must've been on the breakfast beers again

Lamak

I would change it for [meanieheads-except-Jack]

billinkc

I thought we were going to kill the mysql tag

Lamak

or just kill MySQL

JNK

7:28 PM

Sorry I was unclear

billinkc

If only

Zane

We will be drowning in tags sooner or later.

JNK

I never noticed before the gbn-is-married tag

I thought that's what Phil added initially

Phil

Oracle already killed MySQL :P

billinkc

Now, if only they'd take out Oracle

/me hugs Phil

Lamak

7:30 PM

Feb 9 at 16:40, by ConcernedOfTunbridgeWells

room topic changed to The Heap™ - Consultancy ©®: General on- and off-site discussion for http://dba.stackexchange.com [aaron-is-a-dad-again!] [gbn-just-got-married] [lamak-for-cm] [mysql] [nosql] [not-too-many-vertica-folk] [oracle] [postgresql] [sql-server]

JNK

ok thanks

billinkc

Facts prove nothing

JNK

That just like, your opinion, man.

Phil

Google autocomplete for "why did mysql " is amusing

JNK

also "why is mysql"

swasheck

7:33 PM

my autocomplete results a disappointing

JNK

"Why did seth" brings up "Why did seth kill osiris"

no idea what that refers to

Phil

"Why is Aaron " is erm.... Haha

JNK

"Why did phil cry on duck dynasty"

swasheck

@JNK Set(h) is the egyptian god of war and death, i believe

JNK

@swasheck I ended up clicking the link :)

"Why is Kansas City" is interesting too

swasheck

7:41 PM

put away the crack before the crack puts you away

Phil

hands swasheck the pipe

Lamak

is sqlfiddle working for you guys?

Phil

Nope

Lamak

7:57 PM

ok, thanks

Zane

@Zane could you put yours as an answer and I'll mark it as such? — tjcinnamon 1 min ago

Lamak

@bluefeet is this new?

Zane

^My comment is not good enough to be an answer.

Lamak

bluefeet

@Lamak not sure

Lamak

8:01 PM

hadn't seen it before

bluefeet

44

Q: What is the new "Answer similar questions" feature for?

I and a few others in chat are noticing that we get the following message after answering a question: Thanks for contributing! Have more to say? Answer similar questions Clicking the button for that post took me to this search page listing "similar" questions to answer. I guess that's ne...

discussion answers search answer-similar-questions

Lamak

ah, thanks

I didn't like it, I mean, maybe it could work for newish users?

billinkc

Sounds like a perfect fit then

bluefeet

@jnk why does replication suck so much? ;)

JNK

@bluefeet it's brittle

Lamak

8:04 PM

@billinkc alright, I guess I had that coming

Zane

Zane, Minneapolis, MN

3k 9 25

sql sql-server ssis sql-server-2008 mysql tsql select

Yeah VTC!

billinkc

Looks like someone needs a DV

bluefeet

@JNK that's an understatement

Phil

8:22 PM

Heap (comics)

The Heap is the name of several fictional comic book muck-monsters, the original of which first appeared in Hillman Periodicals' Air Fighters Comics #3 (Dec. 1942), during the period fans and historians call the Golden Age of Comic Books. The character was created by writer Harry Stein and artist Mort Leav, and revived in the 1980s by Eclipse Comics. Similar but unrelated characters appeared in comics stories published by Skywald in the 1970s and Image Comics in the 1990s. == Publication history == === Hillman === Following its debut Air Fighters Comics #3 (cover-dated Dec. 1942), the H...

ypercube

8:33 PM

@Phil Have they? I thought they were adding features, judging from the (still in beta) 5.7

Mike Fal

What the hell is all this llama stuff on Twitter?

Zane

@Phil Six bucks on ebay.

swasheck

@MikeFal como se llama?

anyone have a good rec on video editing software

mmarie

@MikeFal The llamas have apparently been captured now

Mike Fal

@mmarie What llamas?

mmarie

8:45 PM

2 llamas escaped near Phoenix and evaded capture for quite a while

Mike Fal

Ah

swasheck

@bluefeet was unavailable for comment

Aaron Bertrand

Should I use NOLOCK against #temp tables?

Also check out the new WITH (ONLINE = ON) hint for ALTER TABLE ALTER COLUMN

swasheck

@AaronBertrand on 2014 ... definitely not

Phil

@ypercube oh, they are, but they're seen to have alienated the community, hence the forks (MariaDB etc)

mmarie

8:49 PM

@MikeFal kfor.com/2015/02/26/…

bluefeet

@swasheck I may have been releasing the llamas and that's why I wasn't here

swasheck

mmarie

@bluefeet Or helping lasso the llamas. Do you lasso?

Aaron Bertrand

@swasheck why the qualifier?

bluefeet

@mmarie that's not a skill I've acquired yet

ypercube

8:53 PM

@Phil Yeah. Although the maria forked while mysql was in sun, I agree. And they have certainly made some things worse - like closing the bugs system, etc.

Zane

Oh snap.

brentozar.com/archive/2015/02/signing-off

mmarie

Yeah, i was just going to comment on that

Time to clear out my desk drawers, pack up my pictures, and take posters off my @BrentOzarULTD walls. On to new adventures!

Tweeted by grrl_geek on February 26, 2015 at 8:35 PM

Mike Fal

Yeah, she just tweeted out about that. What her next move will be is a mystery

Zane

So much for having an friend on the inside...

swasheck

@AaronBertrand researching again ... i'll have more info in a bit

@Zane elide the final 3 words

@AaronBertrand nevermind. misremembered

mmarie

9:00 PM

@swasheck Although I figured it out from context, I had to go look up the word elide

swasheck

@AaronBertrand i knew that an update to 2012 and that 2014 did somethign with tempdb ... but it was to get rid of eager writer

Zane

@swasheck ouch my feelings.

swasheck

@mmarie TMYK;

Aaron Bertrand

@swasheck right, that shouldn't affect locking.

JNK

@Zane explains some stuff

swasheck

9:01 PM

@AaronBertrand yeah. i was misremembering that it was something with isolation levels

Zane

@AaronBertrand I approve of this message.

@JNK indeed.

Aaron Bertrand

I'm sure there is some bizarre query pattern you could arrange with #temp tables and transactions interacting with permanent tables in user databases where there is some tangible difference.

Lamak

indeed (I'm too far of that world, so it doesn't explain anything to me)

swasheck

2 hours ago, by Phil

We're supposed to be mean. That's why we all get along so well

Zane

@swasheck I was joking. You should know that I don't have feelings.

swasheck

9:04 PM

@Zane indeed

Lamak

@Zane good feelings

ypercube

@Zane That should not stop us from trying to hurt them.

2

Zane

ha ha

Aaron Bertrand

Olivver the Kid - Lucy (Hurt People Hurt People)

►

ConcernedOfTunbridgeWells

@JNK I added that a few weeks ago. @gbn said he got hitched recently.

swasheck

9:07 PM

anyone (@Zane) know this guy?

Thomas Lourigan

Zane

uhhh no sir.

Well now that Jes is leaving BOU seems to be lacking a comic book enthusiast.

I guess they'll have to hire me now.

Paul White

9:23 PM

Or Michael Swart

swasheck

ZING!

(frickin fat fingers)

Paul White

I liked ZONG

swasheck

that's what i heard too

Zane

Alright I'm out. Time to hit the ole bike trail

swasheck

OLEDB!

we have 14 inches of snow so rub in the biking stuff

Zane

9:29 PM

Do your bike trails not get plowed?

swasheck

not while it's still snowing

Zane

Makes sense.

See you

JNK

Anyone have thoughts on creating a production table with SELECT...INTO?

I know what I think but hope maybe I'm missing something

Aaron Bertrand

@JNK can't think of any real problems except you don't get indexes, constraints etc. but you do get identity property. You'll need to create the other things manually.

Also check if the source has computed columns, sparse columns, etc. They may cause issues.

ypercube

@AaronBertrand The created table is always a heap?

Aaron Bertrand

9:40 PM

@ypercube yes.

JNK

do the new columns match the source columns? I thought it matched the RESULTS of the select

so the varchar lengths may not be the same etc

Aaron Bertrand

@JNK match the select, so you can do ID = ID+0 for example to skip the identity property, or x = CONVERT(NVARCHAR(255), x) to make the new column have Unicode

JNK

ok, just wondering

seemed sloppy/lazy to me

Aaron Bertrand

@JNK does your select explicitly do convert(varchar(some_other_length), source)?

JNK

no

there is an order by for an unknown reason

but otherwise it's just the source columns

swasheck

9:42 PM

nice

JNK

I'm reviewing this thing and it just seems off to me

Aaron Bertrand

@JNK someone have an MS-Access background?

JNK

no sir this is a LEAD SQL Engineer/DBA with 20+ years experience

Aaron Bertrand

@JNK select into is like a lot of other things - not bad on its own, just bad when it's abused or misunderstood

JNK

ko

Aaron Bertrand

9:44 PM

@JNK right, but were the first 17.4 years exclusively in MS-Access?

JNK

I thought I had read a best practices thing about not using it in production code (except maybe temp tables)

swasheck

@JNK he of the "what's a trace flag" fame?

JNK

@swasheck the same

I have aesthetic reasons I hate reviewing his code too

he uses a weird formatting I've never seen anyone else use

Aaron Bertrand

@JNK You mean like this? Empty advice with no context?

JNK

he lines up all his keywords on the space

Aaron Bertrand

9:45 PM

@JNK does it match Gordon's?

JNK

no its worse

I think it's unreadable

swasheck

do share

JNK

@AaronBertrand no there was context

@swasheck ok one sec

swasheck

> Use query "with (nolock)" when you don't require high transactional consistency.

Aaron Bertrand

1

A: Creating a table using explicit create table statement versus select into

Select into has logging benefits (doesn't do as much), so the performance is actually better in most cases. However, it errors if the table exists, and doesn't build things such as indexes or constraints, just columns. Depends what you need it for. I know we have some actions that SELECT ... I...

swasheck

9:48 PM

20

Q: Freefall into snow

In the movie Frozen, the following dialogue takes place: Anna: "It's a hundred-foot drop." Kristoff: "It's two hundred." Anna: "Okay, what if we fall?" Kristoff: "There's 20 feet of fresh powder down there. It will be like landing on a pillow... Hopefully. Then they fall all ...

homework-and-exercises newtonian-mechanics free-fall applied-physics estimation

JNK

I'll be deleting that in a sec

I also like his use of aliases there

use a 5 letter acronym and add a letter at the end

swasheck

so he right-justifies his keywords

JNK

kind of yes

he lines them all up

he kept correcting me when I started to do it that way

Aaron Bertrand

Ugh. Also you should validate that those joins are all one-to-one, else the update could be unpredictable and non-deterministic.

JNK

the joins are 1:1

Aaron Bertrand

9:52 PM

kewl

JNK

I could bitch some more about the design but I'll refrain

Aaron Bertrand

theconcourse.deadspin.com/…

JNK

oh man that's great

I can't watch the whole video though

Aaron Bertrand

10:07 PM

@sqlstudent144 Apologies but this is all I could think of http://t.co/EJ9BOtwh6l

Tweeted by AaronBertrand on February 26, 2015 at 10:07 PM in reply to sqlstudent144

Phil

Night out in Manchester tomorrow. Going to drink beers WITH NOLOCK. Glug

3

Aaron Bertrand

What on earth is this

-1

A: Compare Numerical Days of the Year in SQL

select DATEDIFF(DAY,getDATE(),DAY(tableName.dateValue)) <= 15

Phil

10:29 PM

I only just bothered to look where sargable came from. Search ARGument ABLE

ypercube

@AaronBertrand I got tired of waiting someone to answer, so I edited the less horrible answer, with your suggestion.

bluefeet

11:49 PM

this is downright ugly

0

A: How to combine multiple rows of employee into single row in SQL Server

You can use Outer Apply to do this. I am assuming that one employee can have any number of medical, dental and vision rows. This query will take the latest StartDate for each type. Select EmpNo, Name, Medical.StartDate MedicalStart, Medical.Status MedStatus, Dental.StartDate DenStart, Dental.Sta...

Transcript for

The Heap™ – Consultancy ©®