The Heap™ – Consultancy ©®

« first day (3299 days earlier) ← previous day next day → last day (1865 days later) »

Michael Green

01:33

@PaulWhiteReinstateMonica That makes sense.

5 hours later…

Andriy M

06:27

Morning

John aka hot2use

07:05

Morning

1 hour later…

McNets

08:20

Morning

3 hours later…

Michael Green

10:57

Now there's something you don't see every day

theguardian.com/artanddesign/2020/jan/15/…

Tom V - Team Monica

11:44

Q: Database Engine Tuning Advisor drops index automatically on SQL Server 2016?

we are using SQL Server 2016 and currently we are facing some performance issues. Solarwinds tells us, that there is sometimes much wait time caused by a Lock "LCK_M_SCH_M". I was now able to check the activity monitor while we have there problems and I saw that our server dropped an index with ...

Trying to cure a schema lock with database tuning advisor....

Or caused by dta, hard to tell

Does Azure really do that by itself?

Paul White Reinstate Monica

12:08

@TomV-TeamMonica docs.microsoft.com/en-us/sql/relational-databases/…

Tom V - Team Monica

scary

Paul White Reinstate Monica

Well obviously it's configurable

Tom V - Team Monica

And disabled by default, but I can see how it sounds like a good idea when it's just a checkbox the azure infrastructure guys can check

Paul White Reinstate Monica

Goodness only knows what that specific user's issue is. The question doesn't really tell us much.

Maybe someone really is running DTA against production

Tom V - Team Monica

I can see how non-dba's have access to the azure portal and would think something labeled "automatically tune indexes with our uber AI performance tuning algorithm" sounds like a good idea

Paul White Reinstate Monica

12:50

Well it's cheaper than hiring someone who knows what they're doing

Tom V - Team Monica

Azure portal administrators are very often just juniors handling tickets

Paul White Reinstate Monica

13:23

A: Add a link to the timeline of a post

I am happy to announce that a new and improved post timeline is now available to all users. It can be accessed by clicking the clock icon underneath the voting and favorite buttons that are located to the left of a question or answer. Clicking on the button will bring you to the timeline p...

ypercubeᵀᴹ

13:58

> This feature has obviously been a long time coming, and we are happy to be able to release it now. Special thanks for getting this feature done goes to Josh Heyer (Shog9). Shog did all of the coding for this feature (on top of his regular CM duties). For this, and so many more things, we show our appreciation and admiration.

Time to implement: 6-8 years ;)

John aka hot2use

14:14

@ypercubeᵀᴹ ....Shog9

Tom V - Team Monica

@ypercubeᵀᴹ Shog just got fed up with waiting for the dev team to add a write "<a href=\"/{1}/timeline\">history</a>", postid somewhere

Ha, that prompted a visit from smoke detector folks

Peter Vandivier

14:30

is it like saying Voldemort?

ypercubeᵀᴹ

@TomV-TeamMonica it wasn't even (evil) regex!

Unless it's what Peter says. A spell on the use of the name of the one who should not be named ;)

Tom V - Team Monica

I don't see my message in Charcoal but bwDraco and Tim both showed up here soon after I posted it :)

ypercubeᵀᴹ

coincidence

it's wake up time in the east coast ;)

Tom V - Team Monica

and the heap is always the first place they check for shenanigans

Peter Vandivier

14:59

Shognanigans

Shog9igans? 🤔

Tom V - Team Monica

((((((((((//(((((((((((((((((((((((((((//((((((////////////////////////////////////////////////////////////////////////////////////////////////////////////////
((((((((////(((((((((((/////(//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
((//((((/////(/(((((((//////(//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
/(////////(/(((//////////////////////////////////////////////////////////////////////////////////////////////////////…

ASCII shog

Andriy M

15:17

Nice. Had to copy&paste that to a Notepad window to be able to see the image because the lines were too long and some of them would split at symbols that are word delimiters (spaces, asterisks, hashes for some reason). However, I then discovered that I could just set the zoom level at 90% to make the lines fit the field width.

Mathematics

15:34

Hey Kings of Database(s) !!!

mustaccio

15:44

You don't address kings with "hey"

McNets

16:03

Your HEYness!

Evan Carroll

zomfg the caps

WHAT IS UP CAPTAIN MCNETS

how you doing today?

McNets

@EvanCarroll I'm fine, home alone, my wife took a 15-day vacation and she travelled to Argentina

2 hours later…

Philᵀᴹ

18:02

SO could accelerate its demise quite easily. Just make Evan a mod and community manager. It’d be a good* experiment

Peter Vandivier

18:13

if @EvanCarroll was made a mod, which Batman rogue's gallery villain would he emulate. please discuss at length

alternately, which canonical Batman would he emulate?

@McNets well that's shmancy

ypercubeᵀᴹ

18:32

@PeterVandivier isn't Batman the villain in those moves?

Peter Vandivier

@ypercubeᵀᴹ as i remember it, a 👋 New Contributor killed his parents as they were leaving the HNQ, so he's vowed revenge

Andriy M

19:17

@PeterVandivier There was one called Hugo Chavez, wasn't there? I'm not sure as I'm not very familiar with the DC Comics universe.

Peter Vandivier

19:34

the google hits for "Hugo Chavez Batman" are surprisingly entertaining

McNets

@PeterVandivier and then he throw a new CoC and all villains in the city went to the jail...

Martin Smith

19:54

@MichaelGreen LOBs use tempdb. Other datatypes it is allocated up front in the memory for the execution context. Query to see the effect of declaring more variables on size of memory is here. social.msdn.microsoft.com/Forums/sqlserver/en-US/…

Josh Darnell

20:28

Ooh, I blogged about that recently: joshthecoder.com/2019/12/18/invisible-tempdb-killer.html

jcolebrand

21:12

Guys ... here's a thought: Let's not pick on Evan quite so often yeah?

Even I'm known to poke fun at his expense every now and then, but I shouldn't do it either. I'm not a saint here, I'm just saying that if we set him a positive environment and don't direct negativity we can elicit a better response, yeah?

What would Mr Rogers do?

Andriy M

21:27

@jcolebrand Don't know who Mr Rogers is but I agree. I should've known better. And it wasn't even funny or clever what I said

Max Vernon

@jcolebrand invite him to his be his neighbor whereupon Evan would mightly and verily set upon the HOA, and raze that place to the ground.

jcolebrand

21:52

@AndriyM You're not super missing anything, but Mr Rogers was the kindest person I've ever seen from a distance. From the way he talked in Congress in the (?) 60s to his children's show.

@AndriyM as for clever or funny, meh, we all say dumb things. I was more speaking to the room and less to a specific person. See Max's comment right after yours here :p

Andriy M

22:03

@jcolebrand Is this the one?

Fred Rogers

Fred McFeely Rogers (March 20, 1928 – February 27, 2003) was an American television personality, musician, puppeteer, writer, producer, and Presbyterian minister. He was the creator, showrunner and host of the preschool television series Mister Rogers' Neighborhood, which ran from 1968 to 2001. Born in Latrobe, Pennsylvania, near Pittsburgh, Rogers earned a bachelor's degree in music from Rollins College in 1951. He began his television career in 1951 at NBC in New York. He returned to Pittsburgh in 1953 to work for children's programming at NET (later PBS) television station WQED. After graduating...

jcolebrand

22:19

Aye

Paul White Reinstate Monica

@AndriyM Which thing was that? Nothing jumped out at me as over the top. It's not like Evan can't take it or dish it out.

-68

A: How long can Moderator Resignation notices be featured?

Moderator resignation posts will be featured for around 24 hours moving forward. We will not remove the posts from Meta but the featured tag needs to be removed after that time. Lately, we have had an increase of resignation posts that have served to host combative and hurtful words to attack S...

Andriy M

22:36

@PaulWhiteReinstateMonica My response to Peter. Not over the top, no, but not particularly witty either. Anyway, it's not about Evan, it's about me. I actually took a minute to consider before pressing Enter. Should've taken two. No big deal either way, just a nice little lesson in discreetness for me

Paul White Reinstate Monica

Ah ok

« first day (3299 days earlier) ← previous day next day → last day (1865 days later) »

all rooms