Comments for Being Mark Cohen

Comment on Short-circuit evaluation in SQL by Richard C

Richard C — Wed, 14 Jul 2010 01:00:28 +0000

Jeff’s already posted the counter. But I was working up my own as well using your sample test.

create table OrgView (ORGNAME varchar(100), QID int, ANSWER varchar(100))

insert into orgview (orgname, qid, answer) values(‘org1′, 120, ‘1′)
insert into orgview (orgname, qid, answer) values(‘org2′, 94, ‘2006-06-06′)
insert into orgview (orgname, qid, answer) values(‘org3′, 98, ‘all about loving you’)

SELECT orgname FROM OrgView
WHERE ANSWER IS NOT NULL AND qid/0 = 1

The point is that yes, SQL Server will perform short circuit evaluation.
But NO, it is not left to right.
It is determined by the query optimizer based on least cost.

In my revised form above, IS NOT NULL on a text field is more expensive than integer division, so SQL Server zooms in on that one first. Whoalla, bang – divide by zero.

QED

Comment on Outlook toolbar disappeared? by PreviouslySeen

PreviouslySeen — Thu, 24 Jun 2010 16:31:48 +0000

Thanks for this, it solved an issue that was stumping our IT support.

Comment on Outlook Contact Scrubber by Mark Cohen

Mark Cohen — Mon, 21 Jun 2010 05:45:02 +0000

This app is not so free any more, it’s gone commercial and costs $50 USD now

Comment on Delivering Happiness – Book out this week by popz

popz — Sat, 12 Jun 2010 10:49:19 +0000

Mark,

I want one!
Why I want it? well, since the ‘mycareer melb office’ era, I haven’t been working in any organisation where I can truly admit “I love my job and my colleagues and can’t wait to meet all of them in the morning!”. So, rather than job hopping and keep moving from one job to another job, I have decided to change my current workplace environment.
I introduce heaps of team building time, bring the whole team back to basic (their passion for programming & IT), and try my best to bring “joy” to the people I work with. Hopefully that book will help me to pursuit more…happiness at work..
so is this enuf? or shall i wrote more…:D

Comment on Outlook toolbar disappeared? by OrderedList

OrderedList — Fri, 07 May 2010 02:39:27 +0000

Thank you. Can I just say that this is one of those jaw-dropping computer moments when I think, “Microsoft, you have got to be kidding me.”

Comment on Sunset at La Perouse by Ricardo Bueno

Ricardo Bueno — Thu, 06 May 2010 06:24:26 +0000

Something I’ve been enjoying very much as of late is taking a break to disconnect from technology and refresh. For me this means heading to the beach to take a walk by the pier and do nothing more than just enjoy the sunset. Leaves me charged up for the days/weeks ahead!

Comment on Outlook toolbar disappeared? by Kevin Zimemrman

Kevin Zimemrman — Tue, 27 Apr 2010 19:51:34 +0000

Thank you. This is exactly what I was looking for.

Comment on Macro photography with an iPhone by Abdi

Abdi — Tue, 27 Apr 2010 07:01:16 +0000

This is SICK!!!! (in a good way) I still have a couple of old drives, so I think it’s time to start digging for that lens

What kind of case do you use for your iPhone??

Comment on RIP Dr Seuss by Mark Cohen

Mark Cohen — Mon, 26 Apr 2010 11:28:34 +0000

I always feel like those bubbles are following me around too

Comment on RIP Dr Seuss by Charlie the Unc

Charlie the Unc — Sun, 25 Apr 2010 13:04:58 +0000

I love it.
You are part of a funny crowd – the other day one of Lee’s twins (Adina) said “Imma, why can’t I see my bubbles?” Lee asked “What bubbles?” and Adina answered “You know – those bubbles like in books when people are thinking”.