The Heap™ – Consultancy ©®

7:46 AM

morning

Morning

8:03 AM

@PeterVandivier your answer here dba.stackexchange.com/a/238875/44945 doesn't answer the OP question - you might just want to add in the part he's asking about in reference to "Do multiple FULL's do that same job as full recovery model". Which they don't obviously

It is a weird question though

his post is worded in a weird, self-contradictory way

It is lol

i couldn't resist the urge to be sassy and put a big block "No." at the top though

I don't think he understands what PIT and recovery are in general

probs not

fire up the Ola Hallengren signal

8:06 AM

@PeterVandivier Oh god I wish that was a thing

8:52 AM

is it just me, or does "Ola Hallengren's Backup Solution" feel very old-timey and aggressively whimsical as a name?

like, it wouldn't be out of place next to "Professor Harlow Jepsens Miracle Snake Oil"

or "Dr. Fünke's 100% Natural Good-Time Family Band Solution"

Lacks an adjective, perhaps, to fit in

lol, i was gonna say "just add 'Swedish'", but i think that works better as an "as seen on TV" style tagline

Ola Hallengren's Backup Solution: Just add Swedish

95% of your daily recommend allowance of tlog backups

Ola Hallengrens Backup Solution: The good stuff

™️

Q: One SPID has deadlocked itself - how?

9:13 AM

So we just had a session deadlock itself

1 SPID, 4 ECIDs all waiting on Exchange events

How is this possible :S

Maybe one for a question actually

0

We had some Deadlock alerts raised today - on further investigation I have found that it seems to all be the same SPID and related to parallelism events. How has this happened? I didn't think deadlocks could occur within the context of one SPID? I've uploaded the Deadlock XML to PasteBin

ypercubeᵀᴹ

@George.Palacios I can't access the pastebin link. But it could be just me, some firewall

@ypercubeᵀᴹ Do you know anywhere else I can put it? Too many characters for the post probably

@ypercubeᵀᴹ Ah nevermind it fit in the post

I've added it

ypercubeᵀᴹ

Another option gist.github.com/discover

I think there's something with the ssl certificate in pastebin

@ypercubeᵀᴹ I have the same thing with IMGUR

10:16 AM

hahaha, at my last job we had a couple hundred exchange deadlocks per-hour

ask me how we solved the issue

2

@PeterVandivier MAXDOP 1?

un-subbed the CTO from the alerts

@PeterVandivier HAHAHA

💪

@PeterVandivier I suppose you technically did solve the "issue"

10:17 AM

god i hated that place

@PeterVandivier At least you can look back on it with disdain and hatred?

@George.Palacios it's the little things

11:06 AM

twitter.com/mikemead86/status/1131481279738929153?s=21

oh lawd, my chrome auto-complete for "y" just cutover from youtube to YAML

what have i become

11:29 AM

It's the little things

11:41 AM

Could have been you<something else> ...

Evan Carroll

1:46 PM

What does @PaulWhite hate more. Sadness, war, and misery --OR-- capital letters?

Slow learners!

Evan Carroll

Break it down for me.

Tom Petty - Breakdown

Tears For Fears - Break It Down Again

no collusion

> The uploader has not made this video available in your country.

I'm appalled.

1:51 PM

@JoshDarnell Seriously?!

I don't think I've ever come across a VEVO video that was limited like that.

This is indeed appalling. Can you at least see the artist and title?

A beautiful moment ruined.

I would try to find another copy but I just can't risk hearing another Grammarly ad so soon

@PaulWhite They're so obnoxious and EVERYWHERE

Like, why does the intrenat thonk I can't types!

@George.Palacios Mate you don't have to tell me about it. I am so never going to install that app on general bloody principle.

@PaulWhite Yes, I can see that part!

So I got the joke at least =)

1:55 PM

@PaulWhite Hahahaha it's such a weird thing - I feel exactly the same. It's interesting that advertisements can do that

@JoshDarnell Can you find a US-comaptible copy?

Literally the opposite of the intention

And yet here we are talking about them spreading the virus even further

I guess it works

Tears for Fears - Break it down again

AAAARGH!!!!

I clicked on it

1:56 PM

Oh no.

@PaulWhite HORROR

in stop the merry-go-round, 2 days ago, by Paul White

Grammarly is the new rickroll

Still it is a pretty good tune

New hobby: deleting my account when organizations send an enthusiastically-worded update to their privacy policy

Aha! meta.stackoverfiow.com/questions/785330/…

5

@PaulWhite You....

How do I still fall for that

Honestly I don't know, but I'm kinda glad you do

Makes it all worthwhile

2:14 PM

@PaulWhite How do you make those links out of interest?

Tempted to provide a link that explains all

hot2use

2:27 PM

It's got to be an internal redirect for that one question over on meta stackoverflow and it only works for the (deprecated) http:// address. Changing the link to https:// results in a page not found error message.

I guess there is some old running gag.

<a href="http://meta.stackoverfiow.com/questions/785330/can-we-block-grammarly-ads" rel="nofollow noopener noreferrer">meta.stackoverfiow.com/…</a>

The code behind the link.

It is yes.

The domain is maintained by Félix Gagnon-Grenier.

hot2use

Got it. :-)

stackoverfiow.com also works

They're 301 redirects from Amazon S3

@PaulWhite Ahhh I see

Sadly the Rebecca Black one doesn't autoplay

Or happily, depending on your POV

2:33 PM

@PaulWhite A tragedy

The Bee Gees are on chat.stackoverfiow.com

There was some talk of making that work at some stage but it never happened. The Bee Gees weren't the intended target, but I forget what was.

Bee Gees - Tragedy

@PaulWhite EVERY DAMN TIME!

noice

Cade Roux

2:59 PM

@AndriyM I think you are right, I need to set it OFF. And revisiting Erland's series on error handling has extracted all hope from my soul.

PostgreSQL 12 Beta 1 Released postgresql.org/about/news/1943

4

Online index rebuilds 🤭

@Philᵀᴹ What a good idea!

Forrest

hovers over link suspiciously

@CadeRoux Yes, I can believe that place to be capable of having such an effect on people.

Well it's not really as bad as Erland makes out. It's not much better either, but there you are.

He has always had a bit of a bee in his bonnet about it.

https://www.postgresql.org/about/news/1943/

3

3:08 PM

@PaulWhite fool me once...

Just for @Forrest

@George.Palacios Think of it as payback for your blank avatar!

I see why ypercubeᵀᴹ was asking about online index builds the other day

@PaulWhite The hilarious thing for is that I can't see the image at my work because of the firewall. Although I CAN see yours for some reason

> magic

🎩🐇

@PaulWhite I've always thought it would be far more magical to pull a hat out of a rabbit than the usual way.

Excellent point

I wonder if anyone has ever done that

Seems like a missed opportunity

Sympathy star for Phil's message

3:12 PM

Ushanka

An ushanka (Russian: уша́нка, IPA: [ʊˈʂankə], lit. "ear flap hat"), also called an ushanka-hat (Russian: ша́пка-уша́нка, IPA: [ˈʂapkə ʊˈʂankə]), is a Russian fur cap with ear flaps that can be tied up to the crown of the cap, or fastened at the chin to protect the ears, jaw, and lower chin from the cold. An alternative is to bend the flaps back and tie them behind the head, which is called "ski-style" — this offers less protection from the elements, but much better visibility, essential for high-speed skiing. The dense fur also offers some protection against blunt impacts to the head. The word...

@AndriyM So close!

> Ushankas are often made from inexpensive sheepskin (tsigeyka, ru:Цигейка), rabbit or muskrat fur.

This is a funny phrase:

> Ushanka with ear flaps deployed

deployed

@PaulWhite Well yeah. For the landing

Sounds vaguely threatening to me

They're like those helicopter hats. Except more glidey.

And also much softer on the skin

3:16 PM

They do look cozy

@PaulWhite something, something in soviet Russia something, something

ha ha ha

(in my head) ...ear flaps deploy you!

saad butt, Lahore, Pakistan

1

presented without comment

Apparently, this user prefers to keep an air of mystery about them.

an air

sadly

Cade Roux

4:00 PM

saadly

5:43 PM

Oh I missed a lot of fun today while I was busy pretending to be a sales guy

@TomV Did you sell anything?

That remains to be seen

At least I was honest. When they asked about how x would work on the platform is answered 'not well'

Because it wouldn't

The actual sales guy looked at me like I farted in the mic

Ah, there, you see. When you said you were honest, I thought, "Does that still makes you a sales guy?"

I did say pretend

Fair point

But did you need to do that (i.e. participate) if there was an actual sales guy there anyway?

5:51 PM

I was there for the technical questions because there were developers in the audience

I see

And I knew one of them. There was no way I could talk my way out of his question

A decent excuse not to lie. I like it when it happens like that.

Evan Carroll

6:34 PM

@PaulWhite Phishing attempt ^^

9:29 PM

😴

9:51 PM

All, I have a SQL conundrum that I am ill equiped for. I am not a DB guy as such, I muddle by as best I can.

I have a table with composite key of Guid and DateTime. I want to have a view that gets all records of distinct Guid and the Max DateTime of those records.

So I fully expect to have eventually hundreds of records with the same Guid with ever increasing DateTime values, and I want only the latest record for each Guid.

Is that doable?

Jack Douglas

@CodeWarrior you need the other records too, not just the DateTime? The best way to do that is different for each RDBMS (postgres has DISTINCT ON, Oracle has KEEP…FIRST etc).

I need the rest of the record too, and I am on SQL Server.

Jack Douglas

you can do in in two passes with ROW_NUMBER() partitioned by Guid and then filter all with rownumber 1

check out the questions in greatest-n-per-group and sql-server

A: Retrieving n rows per group

@PaulWhite Thanks!

And @JackDouglas Thanks to you too!

Jack Douglas

10:04 PM

42

The typical way to do this in SQL Server 2005 and up is to use a CTE and windowing functions. For top n per group you can simply use ROW_NUMBER() with a PARTITION clause, and filter against that in the outer query. So, for example, the top 5 most recent orders per customer could be displayed this...

Wow. Now that is an answer.

Personally I think the question is awesome but ok