« first day (3298 days earlier)      last day (1867 days later) » 

Paul White Reinstate Monica
Paul White Reinstate Monica
00:36
@PeterVandivier Yes "Too localized - this could be because your code has a typo..."
Paul White Reinstate Monica
Paul White Reinstate Monica
00:54
271
Q: I am resigning as moderator on Stack Overflow

Madara's GhostEffective 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...

discussion featured moderators
Evan Carroll
Evan Carroll
01:35
Queen - Another One Bites the Dust (Official Video)
►
Unrelated, I swear.
Paul White Reinstate Monica
Paul White Reinstate Monica
I had that tune in my head as I pasted the meta link
 
5 hours later…
Vérace
Vérace
06:18
Morning all...
Tom V - Team Monica
Tom V - Team Monica
06:36
Morning
Andriy M
Andriy M
07:21
Morning
 
2 hours later…
ypercubeᵀᴹ
ypercubeᵀᴹ
08:56
m
> 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.
ha
just trying to login to meta, on the train wifi
Tom V - Team Monica
Tom V - Team Monica
09:22
People used to avoid meta, now they are drawn to it
-26
Q: In defense of sanity, let's shake hands. Stack Exchange has changed, and it's ok

nduggerI 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…
ypercubeᵀᴹ
ypercubeᵀᴹ
11:06
heh
> This post is hidden. You deleted this post 7 years ago.
Michael Green
Michael Green
11:18
Morning all.
ypercubeᵀᴹ
ypercubeᵀᴹ
morning
mssql, mysql, same difference ;)
0
Q: Optimise/Speed up query

IT researcherBelow 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>

mysql query-performance optimization
Michael Green
Michael Green
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
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
Michael Green
Michael Green
11:55
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
John aka hot2use
14:06
Morning
Why aren't people down-voting bad quality questions...
Andriy M
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
Peter Vandivier
14:29
@AndriyM 🤯
perhaps the correct answer is...
Jan 8 at 9:47, by Tom V - Team Monica
It depends ™
ypercubeᵀᴹ
ypercubeᵀᴹ
14:47
@Johnakahot2use some people do not vote at all
Paul White Reinstate Monica
Paul White Reinstate Monica
14:58
98
A: In case you missed it: Shog9 and Robert Cartaino are no longer staff members at Stack Exchange

JamesThe 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
Tom V - Team Monica
Tom V - Team Monica
@PaulWhiteReinstateMonica meta.stackoverflow.com/posts/392883/revisions
Paul White Reinstate Monica
Paul White Reinstate Monica
yeah I saw
one-boxing it here preserves the current state
Chipping away LOL
3
ypercubeᵀᴹ
ypercubeᵀᴹ
15:19
@PaulWhiteReinstateMonica yeah. also this one
I'm shocked ... more like we're Shogged ... — rene yesterday
Paul White Reinstate Monica
Paul White Reinstate Monica
I see George Stocker has started a gofundme for Shog
> gf.me/u/xcmzn4
ypercubeᵀᴹ
ypercubeᵀᴹ
80k target
Tom V - Team Monica
Tom V - Team Monica
15:35
@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
user image
Paul White Reinstate Monica
Paul White Reinstate Monica
15:54
ha!
ypercubeᵀᴹ
ypercubeᵀᴹ
16:05
my contribution to the edit war ;)
meta.stackoverflow.com/posts/392883/revisions
ypercubeᵀᴹ
ypercubeᵀᴹ
16:25
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
Paul White Reinstate Monica
Paul White Reinstate Monica
105
A: In case you missed it: Shog9 and Robert Cartaino are no longer staff members at Stack Exchange

JamesChipping 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.
ypercubeᵀᴹ
ypercubeᵀᴹ
It did stop the edit war. For a while at least.
If Shog9 was around, he might have locked it by now ;)
Paul White Reinstate Monica
Paul White Reinstate Monica
17:04
@ypercubeᵀᴹ Looks like the answer was deleted
ypercubeᵀᴹ
ypercubeᵀᴹ
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…
Michael Green
Michael Green
19:31
@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
Andriy M
19:52
@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
Evan Carroll
20:41
Did anyone resign in the past couple of hours?
John aka hot2use
John aka hot2use
twitter.com/shog9/status/1217542885605662720?s=21
4
Paul White Reinstate Monica
Paul White Reinstate Monica
21:26
@MichaelGreen lob type variables are backed by tempdb

« first day (3298 days earlier)      last day (1867 days later) »