The Heap™ – Consultancy ©®

10:17 AM

best thing for it

3 hours later…

1:26 PM

Oh I see they managed to create a new tag nysql as well

@PaulWhite NY SQL is the best style of SQL and it's hard to find it outside the city

Good morning

That would be nycsql surely

morning

@PaulWhite Sure, if you're from upstate

I see

JEAGL: To people who live in New York City, it's just "New York" - only people who don't live there add the city

1:33 PM

So good they named it twice

Aside from all the rats of course

Those rats provide plenty of viral content - figuratively and literally

@bbaird how do they know they are not talking about the state then, uh?...checkmate

@bbaird I assumed that they were the main protein of your hot dogs, kebabs, etc

@Lamak No more than 25% per the health inspector

Alas, I do not live in NYC, instead I live in the land of two pizza choices: 1. terrible, thin, cut into squares with bland sauce 2. authentic Neapolitan

New Jersey?

lol

The midwest has a certain terrible pizza that is only found here because people don't have any other option

Like, how is that acceptable and not a crime?

1:39 PM

The 'midwest' is a v confusing term

@bbaird Well there's no pineapple...

@bbaird what the heck is that?, we have better pizza here

@Lamak I'm not sure, but it seems to be some sort of cracker topped with unseasoned tomato sauce and topped with cheese and available with questionable toppings

pizzaranch.com/menu/pizza

Is Philadelphia mid west?

I feel like I have had this discussion before

Philly is definitely east, but Pittsburgh and west seems to get the label that extends as far as Nebraska

I think it's mostly defined by 1. the amount of corn you grow per capita 2. how much you want to distance yourself from "those wicked city folk"

North Central

Midwestern United States

The Midwestern United States, also referred to as the Midwest or the American Midwest, is one of four census regions of the United States Census Bureau (also known as "Region 2"). It occupies the northern central part of the United States. It was officially named the North Central Region by the Census Bureau until 1984. It is between the Northeastern United States and the Western United States, with Canada to its north and the Southern United States to its south. The Census Bureau's definition consists of 12 states in the north central United States: Illinois, Indiana, Iowa, Kansas, Michiga...

Still a terrible name

1:47 PM

had to google it too

@Lamak We discussed it with Joe O back in Apr 2018 in STMGR

Erik had a v unhelpful diagram

With a red line

I see

> everything past that line is the south

very unhelpful indeed

@bbaird That is not pizza

1:51 PM

@PaulWhite Oh, also by labelling things that aren't pizza pizza or by making not very good pizza.

That does make some sense

Although bad pizza is a thing in a lot of places in the US

A side discussion

I will say that "pop" has always eluded me (and made me look at my cousins weird) but "coke" has to take the cake for weirdest region difference in the US

@bbaird So which generic term would you use most likely?

1:59 PM

I grew up on the east coast so it was always "Soda" and even when I lived in Missouri I was definitely on the "soda" side of the "missouri/missourah soda/pop" divide.

It's not something I hear often, but here I would say it was 'soda' or 'soft drink' or maybe even 'fizz'

Though fizz is more likely to be alcoholic

'pop' does have a certain olde-worlde charm

Very olde-timey

Does NZ have any such divide on the name for a common beverage or food?

not that I can think of immediately

'chips' is always a source of confusion for visitors

British people that live or work here would call them 'crisps'

hm maybe there's a divide between 'cordial' and 'fruit syrup' (squash for some)

good question

2 hours later…

4:29 PM

PAUL WHITE GOT A NEW PICTURE

... he should get a new nickname to go with it. I hear "Israel is an Apartheid State" is vacant.... ;)

pretty vacant

I changed it a couple of weeks ago I think

Well you must have been less annoying than usual. I hardly noticed.

It was July 12 in fact

So I've been not annoying for several weeks

Which might be a record

4:33 PM

Congrats.

Thanks man

I'm on an interrupted run that's lasted 36 years. But yeah 2.5 weeks isn't bad for you.

Also Happy Nina Turner day.

1 hour later…

5:36 PM

So there's this annoying thing I'm noticing when I'm doing certain types of joins in SQL Server and I'm trying to figure out if this is something MS would need to fix in the query optimizer or if I'm missing something altogether: sqlfiddle.com/#!18/92a54d/11

The crux is, if I include any additional predicates in the LEFT JOIN it will flip to some combination of TOP/stream aggregate with two seeks instead of just one seek with a TOP as it would without the additional logic.

It's not a huge deal (logical reads aren't super expensive) but it annoys me.

jcolebrand

6:07 PM

Is that at all hintable?

6:50 PM

@bbaird I might be missing something, but the 2 first queries aren't really equivalent?

Cade Roux

What does it look like using the SortOrder = ROW_NUMBER() OVER (PARTITION BY ThingyID ORDER BY UpdateDtm DESC), WHERE SortOrder = 1 technique - I've found that sometimes makes some improvements to the plan - quite surprisingly.

i.e. something like this fragment:

FROM Patient p
LEFT JOIN (
SELECT [PatientID]
,[CodeValue]
,rowNum = ROW_NUMBER() OVER (PARTITION BY PatientID ORDER BY PatientIdentifierID DESC)
FROM [PatientIdentifier]
where CodeName = 'MRN'
) pid on pid.PatientID = p.patientID and pid.rowNum = 1