The Heap™ – Consultancy ©® - 2017-08-07 (page 1 of 2)

Michael Green

03:55

Q: "Can not start the mariadb.service in the 3th node" Those 3th nodes can be a bugger. Especially on Frinesdays.

gbn

06:29

@ConcernedOfTunbridgeWells It's a better class of bollocks though

McNets

07:30

morning

Tom V

Morning

ConcernedOfTunbridgeWells

09:08

Morning

gbn

howdo

ConcernedOfTunbridgeWells

Fair-middling.

How's life working for the gnomes?

gbn

one day closer to retirement

ConcernedOfTunbridgeWells

London makes me feel like that too.

I've never seen so much gamesmanship in one place as on my current project.

McNets

One day away from youth

ConcernedOfTunbridgeWells

09:16

I feel this place is in urgent need of a spot of percussive stakeholder management.

Or, at least, certain of the locals.

gbn

@McNets That receded into the mists of time some, er, time ago

ConcernedOfTunbridgeWells

What is this 'youth' you speak of?

McNets

Can't assure, I barely remember it

gbn

@ConcernedOfTunbridgeWells motherboard.vice.com/en_us/article/kb7eew/…

A more general view of business users google.ch/search?q=loudest+monkey+smallest+balls

ConcernedOfTunbridgeWells

@McNets A lot of folks say that about the 1960s too.

McNets

09:20

@ConcernedOfTunbridgeWells Yeah, but it is due to LSD

ConcernedOfTunbridgeWells

Or, in a more gender-neutral way - Just 'cause you've got a c#nt doesn't mean you have to act like one.

Tom V

Service delivery manager is just a human email forwarding service

ConcernedOfTunbridgeWells

@TomV There's a saying about project managers:

In order to understand the value of a good project manager you first have to see the damage done by a bad one.

gbn

@TomV is that your job title? Before I jump in mullet first...

Tom V

No I'm just dealing with one today

SDM asks me something, forwards my mail to their dba "can you look into this", forwards her reply to me "this is the feedback of our dba can you comment", forwards my comments to the dba

ad nauseum

gbn

09:28

A corporate non-job.

ConcernedOfTunbridgeWells

@TomV Let me introduce you to the joys of Acceptance criteria.

When you have stakeholders that do this sort of shit you need to outline exactly the actions you want taken, e.g.
Investigate issue X
Propose a solution and don't bother me until you have finished the investigation - except to call me if you have any questions.
Once you have a solution, write up an email detailing what you have done and sendit to me, my line manager and any other relevant stakeholders.

The acceptance criteria for the initial ticket are that all three items are met.

Specify the acceptance criteria clearly and don't let them close the ticket until they have met the acceptance criteria.

Tom V

@ConcernedOfTunbridgeWells Except this guy thinks he can replace a real issue tracker so there aren't any tickets

ConcernedOfTunbridgeWells

Then email him the acceptance criteria and escalate with his line manager if he fails to deliver.

However he's tracking it, make the acceptance criteria explicit and make his life miserable if he fails to deliver on those criteria.

If he tells you to stop treating him like a child then tell him to stop acting like one.

'We expect you to take some ownership of the process. You're just fobbing your job off onto your customers and wasting everybody's time.'

I've had to start doing that with other teams on this project as there are a couple of office politicians in key positions.

You can also start your own issue tracker. Call it a 'RAID Log'. This can just be a spreadsheet. Start summarising outstanding issues in appropriate meetings.

One thing I find is that something in writing always beats talk.

Paul White

11:13

1

Q: Slow access to JSONB column

I have the following query that accesses a JSONB column in the table datasets: select count(*), my_jsonb_column->0->'PARAM1' from datasets group by my_jsonb_column->0->'PARAM1' The explain analyze output is HashAggregate (cost=4778.92..5577.57 rows=53243 width=40) (actual time=1189.083..118...

Philᵀᴹ

dba.stackexchange.com/questions/182693/… needs more reopening love - question was clarified & has an accepted answer

ypercubeᵀᴹ

Post Reopened by Philᵀᴹ, joanolo, Andriy M, Mikael Eriksson, Paul White♦
occurred 1 min ago

Paul White

Thinking I should trade mark my name

Andriy M

@PaulWhite They must be mad.

Paul White

But scientific

ypercubeᵀᴹ

11:28

@Phil doesn't your query need select * from cte order by level; to guarantee the order returned?

Colin 't Hart

@Philᵀᴹ Question is still pretty unclear to me.

Andriy M

11:45

Edited to make the example clearer (hopefully)

More explicit anyway

Paul White

13:40

You know you've zoned out a bit when you look up and realize the TV has been playing a looped paid advertisement for a ladder for the last 30 minutes

Now replaced with a Jackie Chan movie

ypercubeᵀᴹ

Ladder fight scene comes to mind

Paul White

@ypercubeᵀᴹ Yeah but that was with a clearly inferior ladder :)

Nelson Casanova

99 days in a row... word on the street is, if i show up tomorrow, I get golden star...

ypercubeᵀᴹ

Jackie Chan Famous Ladder Fight Scene (First Strike) HD Unrated Version

►

Paul White

It is First Strike I am watching!

Andriy M

13:49

It's the one where he calls the Cyrillic Ж letter double K, if I'm not much mistaken.

Paul White

Good job I've seen it before eh

ypercubeᵀᴹ

Faux Cyrillic

Faux Cyrillic, pseudo-Cyrillic, pseudo-Russian or faux Russian typography is the use of Cyrillic letters in Latin text to evoke the Soviet Union or Russia. It is a type of mimicry typeface. This is a common Western trope used in book covers, film titles, comic book lettering, artwork for computer games, or product packaging which are set in or wish to evoke Eastern Europe, the Soviet Union, or the Russian Federation. An early example was the logo for Norman Jewison's film The Russians Are Coming, the Russians Are Coming and more recently the logo for Sacha Baron Cohen's film Borat. In the music...

sp_BlitzErik

woo alright who's ready to do some sql

ypercubeᵀᴹ

Cyrillic letter  Latin look-alike 	  Actual pronunciation
Ж   backwards and frontwards K 	/ʐ/ similar to "treasure"

Paul White

Andriy M

13:57

That's the scene

sp_BlitzErik

shouldn't they be undocumented weapons?

Paul White

@AndriyM So many weird coincidences this morning I had to check behind me for a Heap webcam

Paul White

14:37

Ladder scene in progress

Paul White

14:49

18

A: How long should I wait before deleting a closed question?

I hope that we can converge on a policy on how long a question should remain closed before being deleted. For the majority of users able to vote for deletion, there's an enforced waiting period of two days. For things so bad they need to be deleted sooner, there are spam/offensive flags (and...

sp_BlitzErik

15:07

does anyone want anything from alaska?

Royi Namir

Hi. How is it possible ? I got 2 inner joins (without ON right after them) and the query still works :

SELECT distinct mes.Supplier
            FROM Payments_PaymentOrder_Claims ppoc
                  INNER JOIN WebERP_Claims.dbo.Claims_Claim_Data ccd
                  ON ppoc.ClaimID=ccd.Claim_id
                  INNER JOIN weberp.dbo.APP_Policy ap
                  ON ap.Member_ID=ccd.Member_ID
                  INNER JOIN WEBerp.dbo.App_Policy_Groups apg
                  ON apg.IdPolicy=ap.IdPolicy
                  INNER JOIN WebERP.dbo.App_Policy_Types apt  <-----
                  INNER JOIN weberp.dbo.MasterEntity_Suppliers mes  <----- ON mes.MasterEntityId = apt.MasterEntityId AND …

INNER JOIN ---> INNER JOIN

sp_BlitzErik

that's perfetctly valid syntax

Royi Namir

@sp_BlitzErik If I move the other ONs it doesn't work

sp_BlitzErik

brentozar.com/archive/2015/05/forcing-join-order-without-hints

sqlblog.com/blogs/joe_chang/archive/2014/04/02/bushy-joins.aspx

Royi Namir

Thanks :)

Paul White

15:18

That's the fourth time that question has been answered in this room

Royi Namir

I'm sorry , I didn't see prev questions. my bad.

ypercubeᵀᴹ

@RoyiNamir also: What does the position of the ON clause actually mean?

Paul White

@RoyiNamir No reason you would. Just remarking on it. It confuses people.

hm I answered it once, sort of, on SO of all places

Royi Namir

Thanks Paul. Is it possible to get a reference to your answer for this topic ? (I will search , but I hope I'll find the one you intended for me to read),

Paul White

It's not great but stackoverflow.com/a/5203891

The one @ypercubeᵀᴹ linked to is the one I like best

Also Erik's links of course

The keyword to search for in this room is "bushy"

sp_BlitzErik

15:26

this question is a disaster

0

Q: Migrating Binary (IMAGE column) data into a file, during data migration

We are migrating data from our client to our databases. They're using binary data to store their files. We here, use to store the file patch on a string, and then point the correct file. During the migration we are using insert into select (it will happen just one time) we would like to impor...

sql-server sql-server-2008-r2 varbinary

heh heh heh

ypercubeᵀᴹ

@PaulWhite yeah, I like that one, too. I had started writing an answer, to highlight some minor points, but never got around to finish it.

Paul White

@ypercubeᵀᴹ It really gets to the heart of the issue like nothing else quite does for mine

sp_BlitzErik

in your opinion is that sort of syntax too brittle?

Paul White

@sp_BlitzErik Without the hint?

sp_BlitzErik

yeah, of course

(i think hints are too brittle, fwiw)

Paul White

15:35

@sp_BlitzErik Yes I think so because it doesn't come with a guarantee.

I'd probably always look to rewrite it so it was clear and guaranteed.

Unless it was for some sort of competition or something

Or to confuse people in a code review

Goodness me there's sp_OA* methods in there as well

@sp_BlitzErik Hints are pretty much always a sign of failure

sp_BlitzErik

like looking at spinlocks

for a while i was thinking about writing a presentation called "how to win plans and influence joins" but every other slide would have been asterisks

Paul White

That's not a presentation, that's a 5-year on-site class

Joe Obbish

@sp_BlitzErik yeah hook me up

@sp_BlitzErik I was thinking about writing a blog post on that. maybe I shouldn't

sp_BlitzErik

@JoeObbish baked alaska isn't a possibility

Joe Obbish

why are you going to alaska?

sp_BlitzErik

15:42

this year's company retreat is a cruise to alaska/canada

Joe Obbish

huh

was it a bad year?

sp_BlitzErik

no, it's what brent's into

Paul White

@sp_BlitzErik SQLcruise?

sp_BlitzErik

@PaulWhite no, different boats thankfully

Paul White

k

Joe Obbish

15:44

is it part of his 100 epic life goals?

sp_BlitzErik

> 99. throw erik overboard

3

Joe Obbish

some of the advertising around sql cruise is pretty great

"how to go without your boss knowing that it's a cruise!"

apparently alaska still has mosquitoes

Tom V

@PaulWhite Well his profile says he's looking for challenges

Joe Obbish

now there's really no point in going

Paul White

@TomV Looks like he found them!

sp_BlitzErik

15:50

@JoeObbish do you live in a mosquito-free zone?

Joe Obbish

nice try

Lamak

@sp_BlitzErik but is that really epic?

Joe Obbish

Lamak continues to dig himself into a hole...

Lamak

I mean, he could just give you enough to drink....and let yourself do the rest

@JoeObbish you might be right

sp_BlitzErik

the allegation that i'm a sloppy drunk is probably the most offensive thought you've ever rendered to text

what am i, joe after his first shirley temple?

2

Joe Obbish

15:55

edit to "first" please

personally I just assumed that you are immune to alcohol poisoning

Paul White

Scrubs - Appletini, Please

►

Oh that's J.D. not J.O.

sp_BlitzErik

close enough

Joe Obbish

I regret nothing

sp_BlitzErik

yet

ypercubeᵀᴹ

17:54

Fan holiday activities: assembling fans

sp_BlitzErik

what holiday requires fans?

Murray Hertz

Is this a forum I can ask an SQL question in?

sp_BlitzErik

sure, but you may have better luck posting it as an actual question on the site: dba.stackexchange.com/questions/ask

Paul White

@ypercubeᵀᴹ As in, like, groupies?

ypercubeᵀᴹ

@PaulWhite alas, no :(

Joe Obbish

18:02

Erik, can I email you my question?

Paul White

@ypercubeᵀᴹ Condolences.

ypercubeᵀᴹ

@PaulWhite thnx. Due to some unfortunate events, we're stuck in Athens for a bit longer than we had planned. (@sp_BlitzErik)

Paul White

Well that doesn't sound so bad

Joe Obbish

it's Erik's fault that you're stuck?

sp_BlitzErik

@JoeObbish only you can

Tom V

18:04

@MurrayHertz sure but we may tell you it's not a good fit for chat

ypercubeᵀᴹ

Temperatures reach 38 at midday, lowest at night 24-25.

Joe Obbish

@ypercubeᵀᴹ Can we get that in Freedom Units?

Murray Hertz

I remember I used to use a tool that displayed a form so that any reachable database could be selected, like the initial prompt when you open SSMS. I don't remember if it's a StackOverflow tool, something from Microsoft, or a NuGet thing. Does anyone know what I am referring to?

sp_BlitzErik

@ypercubeᵀᴹ how many pornburgers is that?

ypercubeᵀᴹ

@JoeObbish high: 100F, low 75.

Joe Obbish

18:05

thx

Tom V

Mar 22 at 14:09, by Paul White

Dollar Transfer Units

Murray Hertz

I mean a tool accessible from the C# level, that is.

Paul White

@ypercubeᵀᴹ That sounds awful.

@sp_BlitzErik He may be more interested in knowing if you'll read/respond to it

Joe Obbish

whenever I sent Eric an email alarms go off in his house

and he immediately responds

that's why I don't email during office hours

Tom V

@MurrayHertz I think I know which dialog you mean but haven't come across it as a stand-alone thing

Paul White

18:08

@MurrayHertz Like PowerShell?

ypercubeᵀᴹ

@PaulWhite It's not too bad if you can stay at the beach for the hot hours (or in air-conditioned environment). Otherwise, it's a shock, the change from the UK temperatures

Paul White

@JoeObbish That's very considerate

@ypercubeᵀᴹ Yeah I can imagine

ypercubeᵀᴹ

They had high at 17 in Oxford today (that's around 60F for the yankee squirrels)

Joe Obbish

I'm not a squirrel

Murray Hertz

Not Powershell, it was something like a package that created a custom winform control that had prompts for the servername and database name, just like the opening dialog on SSMS.

Paul White

18:15

@ypercubeᵀᴹ That's the same as we had here today, and there are 3 weeks of Winter left

Joe Obbish

say hi to the penguins while you can

ypercubeᵀᴹ

@PaulWhite looks like you have normal weather.

Paul White

Certainly normal for us :)

sp_BlitzErik

@PaulWhite perhaps, but

Aug 4 at 17:29, by Paul White

chat's ok but results depend on who's around

@JoeObbish i need to shuffle your emails out of the way for important ones. inbox zero and all that.

Tom V

@MurrayHertz Microsoft.Data.ConnectionUI.Dialog.dll

Paul White

18:20

Check out the big brain on Tom!

Joe Obbish

I also do index zero

but I'm 600-700 in the hole

Paul White

I reply to approximately zero mails in my inbox if that counts

Tom V

I starred that myself ha ha

Murray Hertz

Thanks, @TomV - that's exactly what I was looking for.

Joe Obbish

@PaulWhite I thought you don't get emails

Paul White

18:22

(I rewatched Pulp Fiction just recently)

sp_BlitzErik

@PaulWhite i have several responses from you, pants on fire

Joe Obbish

@sp_BlitzErik he has a rule for you

Paul White

@JoeObbish Who would know?

Joe Obbish

You?

Paul White

@sp_BlitzErik Yep you don't go to my inbox

@JoeObbish See above

sp_BlitzErik

18:22

@JoeObbish i know, shuffling me out of the way for important ones. food chain. cycle of life.

Joe Obbish

goes to the trash am i rite

Paul White

Erik has a special Gmail "Darling" label

AFAYK

Joe Obbish

do the wife's emails go there too?

Tom V

@MurrayHertz No worries

Paul White

@JoeObbish Whose wife?

Tom V

18:25

I just have mad Google skillz

sp_BlitzErik

@PaulWhite @_@

Paul White

Nuts like a squirrel

Joe Obbish

Didn't realize he was such a player

Paul White

@sp_BlitzErik I'm just encouraging our fawn to be more precise

Joe Obbish

Don't bring your wife to NZ

sp_BlitzErik

18:27

uh joe

Paul White

But no, my wife has her own label

sp_BlitzErik

Aug 4 at 10:43, by Paul White

Six giggly squeaky drunk kiwi women in one car is quite an experience

Paul White

ha ha ha ha

sp_BlitzErik

how did you miss the fact that pablo blanco has a girl for every slot on the stick shift

Paul White

<- rocks an automatic

Joe Obbish

18:28

he's such a player that it's automatic

sp_BlitzErik

those still have different doodads

Paul White

True

sp_BlitzErik

forward, reverse, neutral

whatever 1 and 2 are

the skull and crossbones that you hit when the fuzz is after what's in your trunk

Tom V

@MurrayHertz oh I didn't realize it was a question on main. I'll answer that

Paul White

drive, stop, stop with conviction

Tom V

18:30

But it could use some downvote first so it's elegible for reversal 😀😀

Paul White

ha ha the idea of a family wagon with nitrous

@TomV No chance

ypercubeᵀᴹ

-2

Q: SQL Server database chooser

I remember I used to use a tool that displayed a form so that any reachable database could be selected, like the initial prompt when you open SSMS. I don't remember if it's a StackOverflow tool, something from Microsoft, or a NuGet thing. Does anyone know what I am referring to?

sql-server c#

sp_BlitzErik

why is murray using a picture of joe?

that's freaky

Paul White

...because it Hertz not to?

sp_BlitzErik

i'm gonna mail you a box of spoiled vegetables

you'll have to throw them at yourself

Paul White

18:36

Clearly a shopping list question, I should close & delete it :)

Tom V

@PaulWhite Then I would've wasted 3 minutes of my life without earning unicorn points for it

Paul White

@TomV Sucks to be you

Joe Obbish

I don't own any nice clothes

Tom V

@PaulWhite Story of my life

sp_BlitzErik

@JoeObbish socks to be you

Paul White

18:37

Welcome to Dad Joke hour

Joe Obbish

How's that? People who own nice clothes have to dress up for things

pass

Paul White

PASS is mostly casual

sp_BlitzErik

pass is a few thousand people with tshirts tucked into underwear

Joe Obbish

I'm going to wear my wife beater to Erik's precon

Paul White

Smart casual if you're presenting I suppose. Maybe business casual, whatever that is

Joe Obbish

18:38

dumb casual all the way

Tom V

I said I was going to be more welcoming

Paul White

You're all mean for downvoting Murray's question just so Tom can get a badge!

Tom V

dude I'm messing up the mobile chat thing

sp_BlitzErik

2

hopefully we'll match

Paul White

@TomV It was messed up long before you got to it

Joe Obbish

18:39

> taking selfies

Paul White

@sp_BlitzErik Goodness me

Joe Obbish

mine is classic

sp_BlitzErik

> having a phone with a camera

> having a phone with a screen

Joe Obbish

my phone technically has a camera

Paul White

Someone printed your t-shirt backwards

Joe Obbish

18:40

if I lose the bet it'll be a nice way to do malicious compliance

Forrest

I'm more shocked at the choice of wall art

Joe Obbish

why is there a plant in a chair?

sp_BlitzErik

my kid painted it

Joe Obbish

chairs are for sitting in

sp_BlitzErik

because the chair is by the window

it's also a very old chair that wouldn't do well with a person sitting in it

Joe Obbish

18:41

ok, I'll give you a pass on that one

Tom V

@PaulWhite I'll upvote it as soon as it's eligible for a badge

Paul White

Let me just check the mod manual about voting abuses...

Joe Obbish

there's some illegal voting ring stuff going on in here

Tom V

No sorry @MurrayHertz we're just trolling

It would be the first reversal ever on this site though :)

Paul White

@sp_BlitzErik Did they paint you as well?

Tom V

18:43

@PaulWhite Ha ha, I thought they were bruises

Paul White

snort

sp_BlitzErik

@TomV brent has one on meta from a sontum question

(removed)

Joe Obbish

what's the criteria for reversal?

bluefeet

Provide an answer of +20 score to a question of -5 score

Paul White

> Provide an answer of +20 score to a question of -5 score

Joe Obbish

18:47

thanks

-5

Q: Why over 1.3TB desired memory for this query, it should have no memory grant?

SQL Server version is 2014 Developer SP1. Trace Flags 272, 610, 1118, 1206, 1222, 8048, 9481 are globally turned on. We had to turn on flag 9481 since the new cardinality estimator badly effected many of the query plans. The query has no sort, hash or paralellism. When I run the query no result...

sql-server query-performance sql-server-2014 memory

Tom V

The +20 may be a stretch with that answer though

Joe Obbish

that one is somewhat close

because everyone downvoted a good question because they don't like the guy

Paul White

@JoeObbish How do you know why people voted the way they did?

Tom V

What surprises me is the lack of a check mark :)

Joe Obbish

@PaulWhite I didn't conduct interviews, but it seems pretty obvious based on the comments and how it was closed

despite the question having a ton of information and a posted answer

Paul White

18:50

@JoeObbish It's not unusual for people to downvote an unclear question

The downvote tooltip even has that word in it!

Tom V

I complained about this before, we don't get a notification if the question is edited and forget to remove the down vote

ypercubeᵀᴹ

@JoeObbish the first revision of that q did not even have a query. It was closed as unclear and reopened

Joe Obbish

it was closed in its current state

and reopened without any edits

Tom V

To Meta!

sp_BlitzErik

@TomV i'll check back in but i have a limited attention span

Joe Obbish

18:52

and the query isn't relevant to the question

EBrown

22

Q: Notify users of a question they closed being edited or nominated for reopening

This is brought up by a chat discussion on Code Review. The idea being, when you Vote to Close a question (and it subsequently get's closed), you get a notification when the first Vote to Reopen is cast. This comes up because many users (on all sites) tend to downvote a question when they VTC i...

feature-request vote-to-close down-votes notifications vote-to-reopen

Similar request, no status from SE.

ypercubeᵀᴹ

@JoeObbish if an OP reacts like this to comments/questions, what do you expect?

> Please stick with the original question, what is it that requires a memory grant in this query plan, there is no sort, hash, parallelism? Index seeks do not require a memory grant.

Tom V

@EBrown Yes but in that case other users can revote on my close vote, they can't remove my down-vote in any way

ypercubeᵀᴹ

So perhaps you have a point. Some may not have appreciated the OP's behaviour

Joe Obbish

he didn't do himself any favors, sure

but the question wasn't unclear

EBrown

18:54

@TomV I specifically mention "This comes up because many users (on all sites) tend to downvote a question when they VTC it, and sometimes those downvotes stick (especially on high-traffic sites like SO)." for that concern.

Joe Obbish

as far as I can tell, the only edit was taking the sql query out of the file that he posted

and adding it to the question

sp_BlitzErik

this conversation is too on topic for me

i'm going to the gym

ttfn~~

ypercubeᵀᴹ

Mar 9 '15 at 15:47, by billinkc

Well, that's just like your opinion, man

Tom V

Jan 27 '16 at 19:01, by Tom V

Because I tend to forget to retract it later on unless it happens to get on the front page while I am looking at it

ypercubeᵀᴹ

;)

Joe Obbish

18:58

"this conversion is so bad I'm going to go do manual labor for fun"

@ypercubeᵀᴹ You agreed with me by voting to reopen ;)

ypercubeᵀᴹ

@JoeObbish I can't remember why. Perhaps because it had 2 answers. (I was joking with the "opinion", but the smiley was posted too far away)

Paul White

You reopened it because you like the guy

Joe Obbish

@PaulWhite I dislike the guy

EBrown

@PaulWhite (and @JoeObbish and @sp_BlitzErik) Since you're here, I have a question regarding SQL server that I've been working around in an ugly way: I have a database that's about 15G's, and the server has 32GB of RAM, SQL Server is the only application on it, is there a way I can tell SQL to just load the whole DB to RAM (obviously sync writes with disk) at boot? (SQL Server 2014)

Paul White

@JoeObbish I was referring to Mr Cube

Joe Obbish

19:03

@EBrown Erik is busy banging around weights and grunting

EBrown

My workaround is to SELECT * FROM for every table when it boots, that usually has the desired effect for the most part.

But if I add or remove a table I have to modify the startup program that does that.

ypercubeᵀᴹ

@sp_BlitzErik that meta q with the reversal has all kind of weird voting.

Joe Obbish

Do you mean keep everything in the buffer cache?

Paul White

Anyway. That question has a super long and complex history of votes, reviews, comments and whatnot. Seems clear to me that the majority voted explicitly to close as unclear while leaving comments to that effect.

Joe Obbish

or you want a proper in-memory database?

HEKATON

is not one

so I'm told

EBrown

19:04

@JoeObbish Doesn't matter, it's high-speed RAM so it should be faster (for the most part) to load it to RAM on boot and run it from there.

Paul White

PINTABLE in 3...2...1...

Joe Obbish

sigh

well I was going to say

EBrown

I don't have performance issues in it, but that might be because I literally select all data as soon as it boots hoping it cache's the entire thing.

Joe Obbish

That you should upgrade to SQL Server 2000 and take advantage of DBCC PINTABLE

EBrown

@PaulWhite Not sure if good or bad?

Joe Obbish

19:05

but Mr. No Fun ruined it

Paul White

@EBrown Unavailable since, what, 2000?

EBrown

@PaulWhite No idea, I'm not a DB expert.

ypercubeᵀᴹ

Both question and accepted answer have 15 downvotes.
The accepted answer has a single upvote (I guess from the OP).
The answerer did not upvote the question!
Two more answers at +23 and +19, not accepted ...

Paul White

@ypercubeᵀᴹ The meta question?

ypercubeᵀᴹ

3 mins ago, by ypercubeᵀᴹ

@sp_BlitzErik that meta q with the reversal has all kind of weird voting.

Paul White

19:07

Well yes

Joe Obbish

@EBrown My only real answer is to stop restarting the database

EBrown

@JoeObbish Weekly windows updates.

Joe Obbish

that'll give you other benefits as well

What's your OS?

EBrown

@JoeObbish Server 2012 R2

This database is mirrored between two servers, and they both reboot at least once a week (though not at the same time).

Joe Obbish

I'm sure that if you search for it you'll find lots of information about it

Paul White

19:11

@TomV Can you imagine the number of notifications that would be generated though?

Tom V

Good point

Paul White

Also there's a school of thought that an initially bad post deserves to retain some of its past

ypercubeᵀᴹ

and should we also get notification after an edit if we have upvoted?

Joe Obbish

could all be opt in

Paul White

@ypercubeᵀᴹ Well quite

Joe Obbish

19:13

but I'm part of that school of thought

adding formatting to long wordpress posts is such a pain...

Paul White

It really is. I used the WP editor exclusively once (this last time) and I'm not sure I ever will again

Joe Obbish

ouch

suppose it's a good experiment to try

Paul White

I sort of assumed that's how everyone else did it

Joe Obbish

I thing I wrote a sentence and gave up

my big problem at the moment is no plugin support

they want $20 a month for plugin support

Paul White

19:29

@JoeObbish What sort of plugin do you need?

Lamak

@JoeObbish they are going the Oracle route

Joe Obbish

@PaulWhite spoiler tags and better support for images would be nice

better code formatting

that was way longer than I thought it would be

also I always catch some stupid error immediately after publishing

@Lamak Oracle route would be selling individual plugins

Lamak

19:52

@JoeObbish well, yeah, and charging the previous amount times 1,000

MDCCL

I find interesting the term "lakh", from this suggested edit. Never heard of it before.

Transcript for

The Heap™ – Consultancy ©®