The Heap™ – Consultancy ©®

12:36 AM

@PeterVandivier Yes "Too localized - this could be because your code has a typo..."

Q: I am resigning as moderator on Stack Overflow

12:54 AM

271

Effective immediately, I am resigning from my position as moderator on Stack Overflow. I will no longer actively participate on the site or network sites. I will move whatever discussions I can with the people here to other mediums, and mostly refrain from entering chat. These words are very har...

Evan Carroll

1:35 AM

Queen - Another One Bites the Dust (Official Video)

►

Unrelated, I swear.

I had that tune in my head as I pasted the meta link

5 hours later…

Vérace

6:18 AM

Morning all...

6:36 AM

Morning

Andriy M

7:21 AM

Morning

2 hours later…

8:56 AM

> Suspicious request
> Sorry, your request could not be completed because it looked suspicious. If you meant to perform an action on Stack Overflow, please return to the previous page and try again.

just trying to login to meta, on the train wifi

Q: In defense of sanity, let's shake hands. Stack Exchange has changed, and it's ok

9:22 AM

People used to avoid meta, now they are drawn to it

-26

I think we need to shake hands, and realize that our "communities" are going to have to migrate. It's ok. There are other, amazing platforms out there. This one has decided to move on without us, and I think that's ok. Let me open with a statement I made in chat earlier. I think that SE is g...

discussion

2 hours later…

11:06 AM

heh

> This post is hidden. You deleted this post 7 years ago.

11:18 AM

Morning all.

mysql query-performance optimization

morning

mssql, mysql, same difference ;)

Q: Optimise/Speed up query

Below query is used for inserting and updating the tables in the mssql database. INSERT INTO BalanceTable ([AccountID],[Type],[Date],[Balance],[TRansactionDr],[TRansactionCr]) VALUES (134,'month', '30-Apr-2007',0,0,0); Update BalanceTable set [daily_balance] = '<Root><Maxrowid>1</Maxrowid></Root>

In SQL Server, when is memory for variables in stored procedures allocated and released? My guess is when the SP starts rather than when the variable comes into scope. I don't recall ever seeing a reference, though. Any thoughts or links?

Peter Vandivier

@MichaelGreen no idea but i'd guess it's on batch start / complete rather than by the SP start. so i guess "comes into scope"

what if you have an SP with branching code? it'd be bananas to reserve resources for all possible branches

and in either case if the guess was bad, you still need to wait for more to be allocated etc etc

11:55 AM

Fair points. I know for queries memory is reserved before execution commences and intermediate results may spill to disk (more-or-less). Since vaiables are never arrays (table-valued variables are handled like tables in this respect) the total maximum needed can be known once the SP has compiled. Continually calling the memory broker seems like a run-time overhead when most SPs aren't all that complicated most of the time.

I could see it working either way. Just wondered if anyone had a link that would enlighten.

2 hours later…

John aka hot2use

2:06 PM

Morning

Why aren't people down-voting bad quality questions...

Andriy M

@MichaelGreen @PeterVandivier I'm not sure about release timing but as for allocation, when do you think the memory for the @a variable is allocated in this little demo?

I would say, right from the beginning

It may be hard to verify because the parser makes sure you can't reference a variable before its declaration in your source code.

That is to say, it may be hard to verify that without some lower-level debugging, I guess.

Peter Vandivier

2:29 PM

@AndriyM 🤯

perhaps the correct answer is...

Jan 8 at 9:47, by Tom V - Team Monica

It depends ™

2:47 PM

@Johnakahot2use some people do not vote at all

A: In case you missed it: Shog9 and Robert Cartaino are no longer staff members at Stack Exchange

2:58 PM

The Chipping away of the community continues. The toxified corpse of SO lays motionless, its former vitality drained away. They, fewer than three people who code, many that meddle, disassemble and envenom. Do not resuscitate.

heh

@PaulWhiteReinstateMonica meta.stackoverflow.com/posts/392883/revisions

yeah I saw

one-boxing it here preserves the current state

Chipping away LOL

3:19 PM

@PaulWhiteReinstateMonica yeah. also this one

I'm shocked ... more like we're Shogged ... — rene yesterday

I see George Stocker has started a gofundme for Shog

> gf.me/u/xcmzn4

80k target

3:35 PM

@halfer Sure. But that ship has, too, has sailed. They have their delusions, we have ours. I wrote it yesterday ( meta.stackexchange.com/questions/342076/…) ... I reckon that my communication style gets pretty darn negative these days. And you know what? I do not care. Not one bit. — GhostCat salutes Monica C. 5 mins ago

3:54 PM

ha!

4:05 PM

my contribution to the edit war ;)

meta.stackoverflow.com/posts/392883/revisions

4:25 PM

I'm afraid my contribution won't last very long ;)

@ypercubeᵀᴹ Do you think that that honours the spirit of what I just said? — Martijn Pieters ♦ 5 mins ago

A: In case you missed it: Shog9 and Robert Cartaino are no longer staff members at Stack Exchange

105

Chipping away of the community, continued. The toxified corpse of SO lays motionless, its former vitality drained away. They, fewer than three people who code, many that meddle, disassemble and envenom. Do not resuscitate.

Let's one-box it one more time then :)

Quite a clever solution.

It did stop the edit war. For a while at least.

If Shog9 was around, he might have locked it by now ;)

5:04 PM

@ypercubeᵀᴹ Looks like the answer was deleted

yeah

> This post is hidden. It was deleted 23 mins ago by Tim Post♦.

> This answer was deleted because it's clearly a personal attack. Please do not post it again. – Tim Post♦ 23 mins ago

I disagree but sigh, I'm not a mod.

2 hours later…

7:31 PM

@AndriyM that would be my guess too. Interestingly changing to DECLARE @a int = 7; still returns NULL. I guess allocation and initiation may be separated internally.

Hmmmm .. I wonder what would happen if I try to write 2 billion characters to a varchar (max) on an instance that only has less than 1GB? iirc that memory's not limited by MAX SERVER MEMORY.

Andriy M

7:52 PM

@MichaelGreen Looks like that. Interesting indeed

@MichaelGreen If the goal is to bring the instance down on its knees, that should get you pretty close to achieving it, I'd think.

Evan Carroll

8:41 PM

Did anyone resign in the past couple of hours?

John aka hot2use

twitter.com/shog9/status/1217542885605662720?s=21