The Heap™ – Consultancy ©®

« first day (2265 days earlier) ← previous day next day → last day (2603 days later) »

Paul White

10:37 AM

@JackDouglas SQL Server v.Next CTP 1.4 is out

2 hours later…

ypercubeᵀᴹ

12:53 PM

@billinkc You excel at word? Sounds like an MS Office ad ;)

4 hours later…

Jack Douglas

4:52 PM

@PaulWhite dbfiddle.uk/… :)

4 hours later…

McNets

8:50 PM

@JackDouglas are you there?

@JoeObbish you there?

Jack Douglas

@McNets yup

McNets

is there a significance difference in performance using sum(case where x <> 1 or x <> 2 and x not in (1,2)?

Jack Douglas

what RDBMS?

McNets

oracle

Jack Douglas

Any idea if there would be a significant difference in performance between SOURCE_NAME <> 'A' AND SOURCE_NAME <> 'B' and SOURCE_NAME NOT IN ('A', 'B') ? — Wilson 13 mins ago

McNets

8:56 PM

exactly

Balazs Papp

@McNets Oracle implicitly rewrites x not in (1, 2) to x <> 1 and x<>2. You can verify this from the execution plan.

McNets

@BalazsPapp Thanks.

Jack Douglas

@BalazsPapp it rewrites to OR not CASE

dbfiddle.uk/…

Balazs Papp

@McNets A sum(case when... will not appear in the plan though, just a regular not in in the where clause.

McNets

@BalazsPapp @JackDouglas Thanks.

@JackDouglas I've mentioned you on my comment. Do you receive a notification if someone name you on a comment, even if you are not answering on this question?

Jack Douglas

9:20 PM

@McNets I'm not sure, I don't think so though

Joe Obbish

hello

agree with what was said earlier

@McNets could test on meta. I thought that you do but that could be wrong

McNets

@JoeObbish do you mean the ping or the sum(case)?

Joe Obbish

sum (case)

I cannot recall ever seeing a difference in oracle

I think IN() is limited to 1000 values but OR might not have that limit

Wilson

Thanks guys.

McNets

@JoeObbish thanks.

Master Database

9:34 PM

Q: Question Migration, and question ban information requested

"Community" moved my question ASP.NET Core - Application not connecting to database after publishing to SO from DB. The bases of placing on DB was because it still involved "Advanced Programming in built-in server-side languages including stored-procedures and triggers." plus the fact I am curren...

support

Jack Douglas

9:47 PM

@JoeObbish it is, but you can fudge that: dbfiddle.uk/…

McNets

@JackDouglas how can I get execution plan on dbfiddle for sql server?

Jack Douglas

@McNets dbfiddle.uk/…

McNets

@JackDouglas thanks again, and I'm sorry

Jack Douglas

@McNets thanks for the prompt — I think the 'home page' for each RDBMS needs some examples of what you can do, and execution plans should be in there.

see this btw:

Mar 2 at 17:58, by Paul White

@JackDouglas Using SET STATISTICS XML would be better. Perhaps with a link to Brent Ozar's Paste The Plan thing? See SET Options Scheduled for Deprecation in Future Showplan Versions

then you can use Paste the Plan — but only with 2014 (without tweaking the XML output). I think PTP needs updating: