The Heap™ – Consultancy ©®

« first day (1389 days earlier) ← previous day next day → last day (3465 days later) »

5:34 AM

@ypercube You're both right. wBob is right that CTEs behave that way today; you're right that this depends on implementation and may well change in the future. There is at least one active Connect item for this. By the way, wBob is a good (and smart) guy.

3 hours later…

ConcernedOfTunbridgeWells

8:36 AM

Today's Economist has a reference to the Dead Parrot Sketch on the cover.

ypercube

@PaulWhite Ah, thnx.

4 hours later…

JNK

12:16 PM

morning party people

Mikael Eriksson

morning (or something)

@JNK remember this one? Just had a reason to make some further testing.

It turns out that you can get different query plans depending on the order of columns in the column list.

I did not think that was possible but you know.... it's XML, anything can happen.

JNK

I vaguely recall that

it was my last big thing at my last job

bluefeet

12:35 PM

@AaronBertrand you around?

do you have anti-virus software on your mac? My former employer is requiring it on macs to remote in, so my spouse needs one. Just curious if you have one.

2 hours later…

billinkc

2:48 PM

FWIW, I don't have virus software on my mac. Or any machine I own for that matter

You should get her a VM on the box so she has a work sandbox to isolate any dumb crap the work requires from her native machine

The Cisco vpn forces all the traffic to go through the work network, even for web traffic so I'd run a work VM for just work things and general usage, I'd still have my host OS to "connect to whatever I darn well please, thank you very much net nanny"

JNK

are macs advanced enough to support viruses? I thought it would be like getting a deadlock in Mongo or something.

billinkc

I've reimaged my mac to just run mangodb

JNK

3:03 PM

awesome

JNK

3:20 PM

man I hate product investigations

billinkc

Researching whether a product is suitable?

bluefeet

@billinkc I don't either we never have. They made it a new requirement, they make sure the machine has anti virus software in order for the remote connection to work.

billinkc

And they got it right for a mac? That'd be semi-impressive

Moo no longer supports the text-o-matic business cards. Pity, I rather enjoyed that style (allowed you to have random text printed on the backs of cards)

bluefeet

@billinkc They sure did

JNK

@billinkc yeah

ypercube

3:45 PM

@bluefeet How do they check?

bluefeet

@ypercube Not exactly sure but they couldn't log in this morning until the software was installed and a scan was completed

Aaron Bertrand

3:59 PM

Until what software was installed? No, no anti-virus on any Mac here. Agree with Bill - use a VM

bluefeet

4:16 PM

@AaronBertrand We had to install anti virus software on the Mac here at home before the remote connection would work.

Aaron Bertrand

4:32 PM

@bluefeet got that, but what software? Was it looking for specific software, or does it have a known whitelist of anti-virus apps?

bluefeet

@AaronBertrand Sorry, I missed that. Maybe it has a whitelist, I'm not exactly how it works but it refused a connection until we installed an anti virus and ran a scan. I was just wondering if you ran an anti virus on your machine. We installed sophos to get the connection to work

Obviously I've not been clear, I'll blame my pain meds. Just forget it. ;p

Max Vernon

5:42 PM

Does anyone want to migrate this to workplace?

Q: What are the dangers of non-IT managers using improper database terminology

My immediate manager above me is not an IT person. She has obviously read a wiki page or two on SQL Server and/or database theory. Many times during discussions she will use terms like "Normalized" or "Inner Join" for no reason or in the wrong context. I try and correct "Actually what you are ...

ypercube

@MaxVernon Flag ;)

Max Vernon

@ypercube I'm a bit reluctant to flag:

ypercube

OK, I did it for you ;)

Questions cannot be migrated to the Workplace without a moderator's intervention.

Max Vernon

@ypercube that goes for any site that is not SO, correct? In my image, I asked for it to be moved to SO or Sharepoint.se and that flag was declined. Perhaps we should have a flag reason "move to another site: ________" that accepts anything other than the list of sites in the "close question -> off topic -> move to" list?

ypercube

Yes, but it's so rare. How often do we have questions that should be in other sites (not SO)?

Max Vernon

5:53 PM

I guess not all that often.

ypercube

I didn't even know there is a sharepoint site!

Max Vernon

lol, no doubt. There are so many sites now in the network that it is very hard to know all of em!

ypercube

VtC: dba.stackexchange.com/questions/81062/…

Kermit

Have you tried the Sims? — Kermit 5 secs ago

ypercube

@MaxVernon Don't let one declined flag stop you from advancing to [badge:Marshal] ;)

Max Vernon

6:02 PM

@ypercube cheers!

@Kermit lolol.

ypercube

You can compensate by following Kermit and flagging his comments.

Max Vernon

@ypercube I tried duckduckgo.com/?q=!dbasx%20kermit%20boom! but got nothing

ypercube

I don't think the search works for comments.

Kermit

@MaxVernon why would you want me to explode

Max Vernon

@Kermit Because VERTICA!

Kermit

6:08 PM

@MaxVernon you're just jealous of the massive parallel processing power

Max Vernon

@Kermit lol... that's what she said.

Kermit

@MaxVernon she got results fast

Max Vernon

lol

►

where the mind rolls on Friday afternoon, it boggles, well, the mind.

billinkc

6:24 PM

Whoa, I should be getting way more than 10 rows back... 5 minutes of furiously evaluating my join conditions to realize I have a TOP 10 in my query. I think that's a sign I should take a nap

Kermit

@MaxVernon they look 12

JNK

6:49 PM

@billinkc done that

billinkc

7:00 PM

You had a nap? You sonofa...

JNK

oh no I never nap

I have 2 little kids and am away from home 11 hours a day

billinkc

"You are taking a nap because I need a nap" always worked for me

Max Vernon

7:20 PM

@Kermit tinyurl.com/RollinOn

Andriy M

@billinkc Wait, "You are taking a nap because I need a nap"?

billinkc

Yes. I had no problem telling them when they were 2-4ish that they were taking a nap because I needed one.

My nap requirement was likely due to them wearing me out with their deteriorating behavior. But telling a child they need a nap is a sure fire way to get a response of "no, I don't"

Andriy M

@billinkc Haha, indeed! I'm slow tonight.

billinkc

Have children yourself?

JNK

@billinkc yes it is

Andriy M

7:28 PM

Nope, only a nephew and a niece, 6 1/2 and almost 2, my sister's

JNK

My 4yo can will himself awake

We were driving to his grandparents' house pretty late and he stayed awake for the prospect of presents. He normally is out cold by 8 and he stayed up in a quiet car in the dark until like 11pm through force of will.

billinkc

Niece and nephews are the best, you can have as much or as little of them as you wish and then you can walk away

@JNK They are buggers like that, aren't they

ypercube

@AndriyM Do you plan to have kids?

Andriy M

@ypercube Well, I love children, but I'm not ready to have a family for some other reasons.

ypercube

8:40 PM

I had to share this

Lamak

hm, maybe if I know that the person that is answering is an idiot, I could be an askhole

Lamak

9:31 PM

good thing he figured it out

A: MSSQL Trying to insert into temp table using Count

Okay I figuered it out, here is the correct code to make this wrok: SELECT * INTO #tempAgentStatus2 from (SELECT UserId, COUNT(*) as a FROM #tempAgentStatus GROUP BY UserId)a I was missing the "as a" after "COUNT(*). In case anyone else runs into this problem.