« first day (4649 days earlier)      last day (63 days later) » 

5:20 AM
Wordle 830 3/6*

5:54 AM
🐅 Animal #58 🐈‍⬛
I figured it out in 5 guesses!
🔥 3 | Avg. Guesses: 6.3

6:17 AM
@ErikDarling I like them all, including the later reverse side rope text. Can't split them
Isn't the Big Top full of 🤡🤡🤡 though?
It's a brand association but maybe not the good kind
Irony and context notwithstanding
1 hour later…
7:36 AM
🐍 Animal #58 🦌
I figured it out in 10 guesses!
🔥 3 | Avg. Guesses: 11.6

Google's 25th anniversary!
1 hour later…
8:57 AM
@ErikDarling "Big top" makes me think of circuses. Then again "♫ Send in the ... ♫" etc.
Good morning all.
2 hours later…
10:59 AM
I've got an interesting problem. App calls a proc which updates a single row in a table (< 0sec) but only releases the lock after 30 sec. The proc isn't nested and there should be no transaction created in the app (as far as I've been told)
The only suspicious thing was that the connection is using MARS, but I don't know enough about it
there is probably a 30 seconds to MARS joke somewhere
1 hour later…
12:09 PM
@Zikato Curious, how are you measuring lock time outside of the runtime?
lock acquired/released vs module_start/end
@Zikato Do you know if the query is generated by EF / EF Core?
No significant wait stats, no EF / EF Core.
12:36 PM
> there should be no transaction created in the app (as far as I've been told)
You've been OPed
It's possible, but I lack the skill to debug that on the app side
@Zikato is that measured via Extended Events, or what's your trace tool of choice here?
extended events
I think it must be a transaction somewhere. Because the blocked process report shows an unrelated procedure as the main blocker.

But I don't know how to prove it or trace it further
is there a trigger involved somewhere
foreign key nonsense
implicit transactions
i wonder if mars needs implicit transactions for some reason
12:58 PM
MARS is quite weird
But I don't know heaps about its detailed behaviour with locks and whatnot
Transactions get batch-scoped
Since it spans (at least) two separate RPC calls then it must be on the app side, right?
1:13 PM
transaction (I presume)
or anything else that would keep the locks
Morning All
1 hour later…
2:18 PM
1 hour later…
3:18 PM
A chairde - Morning all!
1 hour later…
4:33 PM
Oh jeez
2 hours later…
6:52 PM
J.D. lakhs answers today
7:50 PM
🐕‍🦺 Animal #58 🐸
I figured it out in 3 guesses!
🔥 1 | Avg. Guesses: 10.5

Well, that was impressive
i'm going to start an online game where people have to guess the source of a smell based on the description
I gagged a little just reading that sentence
8:06 PM
@CadeRoux nice! 👍
@SeanGallardy nothing new there. 🫣
9:04 PM
@SeanGallardy Maybe even crores?

« first day (4649 days earlier)      last day (63 days later) »