The Heap™ – Consultancy ©®

« first day (2745 days earlier) ← previous day next day → last day (2420 days later) »

hot2use

05:54

Morning

Andriy M

06:28

Morning

McNets

06:58

Morning

Andy K

07:12

morning and evening

dezso

07:57

@ypercubeᵀᴹ could you please post this in all chat rooms? :D

Andriy M

08:08

@dezso Sadly, even if we had globally pinned messages, it would hardly resolve the problem, because in the end everyone would still be going by their own definition of "seriousness"

Unless you also added, "By 'serious' I mean..." followed by a very detailed description.

dezso

@AndriyM that would be SEAGL

Mathematics

08:43

Morning all

InnerJoin TableB on TableA.ColumnX = TableB.ColumnX  OR  TableA.ColumnY = TableB.ColumnY

this takes ages, guess I need to change it to cross join, that wo0uld help

gbn

InnerJoin TableB on TableA.ColumnX = TableB.ColumnX
...
UNION
...
InnerJoin Table TableA.ColumnY = TableB.ColumnY

hot2use

09:44

SPAM is in the air

dezso

10:03

@hot2use gone

1 hour later…

dezso

11:15

given command work..try — narayan malsmindar 57 mins ago

hot2use

@dezso We he certainly got my vote

What do you guys & gals think of the new design for StackExchange sites?

gbn

11:39

@hot2use Quite compact and sensible. Not too much change

compared say to the CoC...

hot2use

11:54

(CoC) seems by many to be a \1-up

Paul White

12:21

182

Q: We're more aggressively enforcing self-moderation in chat

While the timing of this post coincides with us expressing some serious concerns around how we're not doing a good job of helping and guiding Stack Overflow to remain a welcoming place for everyone, this is something that's been weighing heavily on our minds for quite some time, and applicable to...

General reminder.

dezso

12:33

@PaulWhite I am wondering if mentioning qronta is still accepted

Paul White

@dezso I don't understand your question, can you clarify?

dezso

@PaulWhite have you tried to search for this wonderful term (thanks @gbn)?

Paul White

@dezso I am busy doing other things.

dezso

@PaulWhite I cannot imagine that. However, chat.stackexchange.com/search?q=qronta&room=179

Mathematics

12:48

@gbn thank you

2 hours later…

Max Vernon

14:20

results are less-predictable as complexity increases

no doubt!

1 hour later…

Andy K

15:40

cya

2 hours later…

Kermit

17:26

It's me

I cannot for the life of me find what the standards for performance testing is called...

The one that provides specific query complexities

Any ideas?

Andriy M

And then a wild Kermit appears...

Kermit

See what happens when you stop doing database

Colin 't Hart

@Kermit TPC?

tpc.org

Kermit

YES!

Thank you :)

How's everyone doing

Andriy M

Preparing to watch the second semi-finals match, I guess

Well, some of them anyway

Kermit

18:01

France was quite shady

Max Vernon

@Kermit watching England beat Croatia!

Kermit

@MaxVernon all my favorite teams are out

Max Vernon

@Kermit that makes it less fun!

pretty sure England is screaming with joy right about now

Kermit

18:23

keeping my fingers crossed for croatia

2 hours later…

A_V

20:23

Database suddenly ramped up to 100% CPU and we don't see any unusual load :/

Max Vernon

@A_V is the sqlservr.exe process using all that CPU?

A_V

yes

I'm not sure what's wrong so I'm thinking of just restarting the database service. Classic noob trick which often works. I'd like to actually figure out what's wrong now though.

jadarnel27

Probably a dumb question, but have you tried running sp_WhoIsActive or sp_BlitzFirst to see what queries / sessions are actively using so much CPU?

A_V

20:39

Wow it just ended after 1hour 30 minutes of 100% CPU

We did nothing

@jadarnel27 yes, we did look at all the metrics. Nothing was obviously blocking..

Many sessions were rotating as usual, no single process clogging up all the resources

I'm going to start logging sp_whoisactive results

jadarnel27

Maybe someone put your server into power saver mode.

For an hour and a half.

For fun.

ypercubeᵀᴹ

@A_V Which version of SQL Server (and CU)?

Philᵀᴹ

Ooh, a @Kermit

Colin 't Hart

20:56

From what I've seen, the two best teams are in the final.

Tom V

@Colin'tHart hey!

Just kidding

A_V

@ypercubeᵀᴹ sqlserver 2016
13.0.4446.0

Tom V

@A_V a plan was recompiled

And sql server figured out nested loops wasn't the way to go for your data

A_V

I used to have the 'query store' feature enabled to look that up

gives nice details of plans versions doing things

Tom V

Just guessing

A_V

21:00

I enabled it back just now

GOING FULL LOGGING

ypercubeᵀᴹ

@A_V You know you are several CUs behind, or one SP behind: support.microsoft.com/en-gb/help/3177312/…

A_V

Oh.. Yes you're right.

I was a full time DBA in my last position but now we're supposedly paying for people to schedule patches and maintenances. Seems like you have to do everything yourself these days

ypercubeᵀᴹ

Who knows how many bugs have been fixed in 11 months

@A_V Your problem could be unrelated of course but I'd suggest you schedule that ;)

jadarnel27

Be wary of the dozens of kilobytes query store could potentially add to your transaction log usage.

ypercubeᵀᴹ

21:54

rudyrucker.com/wares/cc_downloads

1 hour later…

Master Database

23:18

Q: Add Licensing questions as off-topic on help/on-topic page?

I've seen this question covering why we don't need to add an explicit VtC option to covering licensing questions. However, it would seem to make sense that, if we're going to close questions about licensing as off-topic, it might be worth including that fact on the What topics can I ask about? p...