@sp_BlitzErik I was pretty good at databases today

if you define the day starting at 8:30 AM

was not so good if you define it starting at midnight

The day starts when the cock crows

@sp_BlitzErik Preach!

@sp_BlitzErik when did it crow?

@SeanGallardy you only say that because you're experienced the despair of support

@JoeObbish Yeah, some of the things I see... I can't unsee!

What if I told you...

… at PASS!

@SeanGallardy it'll be our secret

I'd text you, but...

:(

if you ever feel down about support you can just read the RFCs that came out of my tickets

then you'll have faith in the community again

@JoeObbish I always do, it warms my heart

:^)

did you look up that issue number I sent you?

If it was recent I haven't, but if it was from a bit ago - yes.

@SeanGallardy tracking number 12450706

check 'em

Making me get on corpnet this late...

oh, right

it will be around tomorrow

probably

lmfao I'm checking now

did you post a blank message?

oh, my internet is having a bad time

No, should be a picture?

congrats!

now all room owners have gold sql server badges

Erik and I are no longer ashamed to be seen with you in public

good timing, right?

LMFAO - yes good timing!

@JoeObbish Oh, this is closely related to another one

Did you write the repro?

it's the same one

what do you mean, did I write the repro? what kind of ridiculous question is that?

I assume you did but wanted to check

are there repro-writers for hire???

actually that would be useful tbh

Top notches for the repro work

A++ Would use repro services again

maybe I should start a business

@JoeObbish You'd have to talk and deal with people though

@SeanGallardy hm

I could hire someone for that

True...

I'd have to talk to that person though

could I use AI?

AI + ML + CLOUD

what about COSMOS?

I hear it's outta this world

my windows is still messed up

or maybe it's opera

@JoeObbish Seems usual these days

Mine is too :(

PLZ FIX

What the Christ are you wads talking about

@sp_BlitzErik it's so easy to understand even a French speaker can get it

RFC? Rimbaud Fried Chicken?

@sp_BlitzErik so let's say you submit a support ticket

you go through the process and run SQLDIAG, etc

the support engineer is convinced that a product change may be needed

that person writes an RFC (request for comment) and submits it to the product group

I asked to see it once and was denied

Yeah I know

Don't be goofy

REEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE

I appreciate your reeeeeeeenactment if a ReeeeeeeeFC

@SeanGallardy congrats, man!

yes congrats

Thanks @jadarnel27 and @PaulWhite One day I'll be a real boy!

with Mod like powers MWUAHAHAHAHA

"The Real World: Implementing Data Compression in SQL Server 2008 R2"

YUP YUP YUP

people are still doing that

as you live AND breathe

REAL applications are only on 2008 R2

RTM

what do you think people mean when they say

"thank you, it really worked"

is there any doubt about it working if you thank someone?

"Thank you, for nothing"

@sp_BlitzErik Sometimes I say "Thank you for your answer" in an attempt to soften the blow of telling them that they didn't actually answer the question

SEWR++

@JoeObbish They still have 8 months of official support left, so they won't have to upgrade for another 8 years.

@sp_BlitzErik Release To Manufacturer? Read The Manual? Riding The Moose?

to be fair, I can understand not wanting to upgrade due to the whole licensing change

one of my goals in life is to give Microsoft as little of my money as possible

@JoeObbish False dilemma on their part as the licensing change happened, they had a period of time to convert their licenses going forward for free, 1 to 1.

@SeanGallardy release the monkeys

I did the company's licensing change from socket to cores in 2013 and made out handily with the 1-1 on some of the 4 socket 10 core systems we had at the time.

@sp_BlitzErik "There's no place like home, there's no place like home"

@SeanGallardy was that well advertised?

@JoeObbish Immensely. <not being sarcastic>

don't know why there was so much whining about it then

Because people saw it as a bad thing when it was actually a got a bunch of cores free thing

well, it's not licensing got cheaper...

I'm looking at a server with 4 CPUs and 19000 MB max server memory

it's really suffering

over an hour of RESOURCE_SEMAPHORE_QUERY_COMPILE

that's pretty good

It didn't get cheaper but you could get the same amount of cores you had, licensed in the core model, and then take away the 12 you weren't using and move them somewhere else. I'd say that's a win.

@JoeObbish which version?

@sp_BlitzErik 2016 SP2

there's nothing to troubleshoot here. it's just way undersized

that's why it suffers

you should put some of the memory from your laptop in there

@sp_BlitzErik you can take my laptop memory from my cold, dead hands

i thought that's what the gloves were for

you're a riddle, joe

a real riddle

they're not heated

LOL you two kill me

Found another of Joe's socks.

Also: how does that have two votes?

bulk insert with TABLOCK, I'm pretty sure

Post your answer, sir.

don't want to post something wrong

Well alright.

Man, the blitz output from this question is like a horror story.

holy cow

i'm running away from that hard

screenshot of blitzcache -_-

@sp_BlitzErik tf 8048 has no effect on sql server 2016

context is this one: "Poison Wait Detected: CMEMTHREAD & NUMA - 0:12:38:38 of this wait have been recorded. In servers with over 8 cores per NUMA node, when CMEMTHREAD waits are a bottleneck, trace flag 8048 may be needed."

yeah, we fixed that, he's running an older version

that guy has ten days of RESOURCE_SEMAPHORE

@sp_BlitzErik oh, of course he is

I think he needs professional help

@Forrest Is this legit? "Texas Style Smoked Chicken with Mustard Glazed Potatoes and Coleslaw"

I don't know what would make it "legit," but it does sound good

@Forrest Is that something that you might find on a menu in Texas?

It would say "Here Style Smoked Chicken..."

🥁

I've never seen mustard glazed potatoes, but otherwise yeah

@jadarnel27 Hah!

I will eat it in your honor

line was a mile long

I have failed

A Texas-sized line

Everything's bigger for Texas food

lol

@jadarnel27 Ouch... but you could make $$$ on helping them ;)

One of my clients just contacted me because they are decommissioning the server that houses one of their SQL Server 2008 R2 instances, and are moving all of the databases to a new...2008 R2 instance. Should I even bother bringing up the impending end of support?

yes

you'd be a bad consultant if you didn't

@jadarnel27 hahahahahaha

a shiny, new, 2008 R2 instance

the latest and finest technology on the market

@sp_BlitzErik yeah, you're right. Just feels so futile.

@JoeObbish only the best for our customers!

@jadarnel27 Yes, please do!

They disabled the clipboard through their Citrix VPN.

:(

I feel like I read a blog post from Microsoft not too long ago about end of extended support for 2008 R2, but now I can't find it.

blogs.msdn.microsoft.com/sqlreleaseservices/…

@jadarnel27 it was Jun 2019 or something like that

@sp_BlitzErik A+++ customer service

@sp_BlitzErik Thanks! I actually found that one about mainstream support. But I thought I saw one specifically about extended support.

@jadarnel27 Thanks for making me smile today :)

@jadarnel27 It was removed by design. (that's a joke, but also not really)

@JoeObbish This

@JoeObbish Close!

support.microsoft.com/en-us/lifecycle/search/?c2=1044

July 9th, 2019

Ah, THIS is what I was thinking of: Announcing new options for SQL Server 2008 and Windows Server 2008 End of Support

I should've know it would have Azure in the name.

people still on 2008 R2 as of July 10th should automatically be upgraded to a cloud version as punishment

can you imagine being on the same hardware and software for that long?

i'm not even sure you're a sentient being at that point

what about mainframes?

what about them?

Doing a SQL Server demo that depends on parallelism over a screen share is a Bad Idea.

how come?

The parallel queries were fighting over the CPU with Skype for Business.

skype is a virus

I was doing a lunch presentation to some of the folks at my work about index tuning. Stuff I learned in the Mastering class. It was fun.

@sp_BlitzErik agreed.

man

no wonder you need a new laptop

@jadarnel27 try running Skype in a VM

HTH

what's that sql server 2016 feature called that allows you to save off a small amount of data?

I think it can be at the session or global level

I think I'm thinking of SESSION_CONTEXT

sounds like it

hm

this is useless for me

Thanks, @SeanGallardy

really drive the point home

@JoeObbish I do what I can :)