« first day (5001 days earlier)      last day (22 days later) » 

Paul White
Paul White
12:42 AM
Well, you only have two eyes
Erik Darling
Erik Darling
1:06 AM
Or three
 
3 hours later…
Paul White
Paul White
3:36 AM
An extra eye looking for a visitor from HR
 
1 hour later…
Paul White
Paul White
4:59 AM
How many years do you need to use SQL Server before you realise HOLDLOCK doesn't mean hold locks?
Like, how long do you think modification exclusive locks were held for anyway?
And how much longer than the end of the transaction do you think HOLDLOCK would hold them for?
A week?
If HOLDLOCK ever needed to exist at all, it would be better as a synonym for REPEATABLEREAD
Which does hold shared locks longer than normal (to the end of the transaction).
 
6 hours later…
Josh Darnell
Josh Darnell
10:59 AM
@PaulWhite 24.8 days?
Neat suggestion: Update multiple statistics on a table with a single scan
John K. N.
John K. N.
11:34 AM
Wordle 1,182 4/6*

⬛⬛🟨⬛🟩
⬛🟩🟩⬛🟩
⬛🟩🟩🟩🟩
🟩🟩🟩🟩🟩
Paul White
Paul White
12:08 PM
user image
For some reason, that plan shape always looks odd to me
Wordle 1,182 4/6*

⬛🟩⬛⬛⬛
⬛🟩⬛🟨⬛
🟨🟩⬛⬛⬛
🟩🟩🟩🟩🟩
 
2 hours later…
Hannah Vernon
Hannah Vernon
1:41 PM
Wordle 1,182 5/6*

🟨⬛⬛🟨⬛
🟩🟩⬛⬛⬛
🟩🟩⬛⬛⬛
🟩🟩🟩⬛🟨
🟩🟩🟩🟩🟩
Erik Darling
Erik Darling
@PaulWhite i really don't understand why ssms chooses to draw some groups of joins along a straight line and draw some at angles
 
3 hours later…
Erik Darling
Erik Darling
4:24 PM
@Vlad if you're asking my permission to create and test an index, you're never going to get anywhere. — Erik Darling 14 secs ago
 
2 hours later…
mustaccio
mustaccio
6:30 PM
why don't you just issue a permit to the man
for a reasonable fee
 
1 hour later…
Paul White
Paul White
7:48 PM
> Since you're on some damnable Microsoft cloud version of SQL Server, your storage is awful and you don't have near enough memory to keep the data you care about cached in memory.
Those HTTP waits. In a database. My god, what were they thinking
It's not even cheap
@ErikDarling To be fair to SSMS, it's just rendering the xml and using the nested structures it finds there
In other words, it has the structure the optimiser produced
Erik Darling
Erik Darling
Well yeah. I get that. It just makes looking at some plans quite an adventure.
Paul White
Paul White
8:50 PM
Looks weird, for sure
Erik Darling
Erik Darling
9:17 PM
I sometimes wonder if the graphical plans a the best vehicle given all the new information that has been added
The amount hidden in tool tips and properties is inconvenient at times
Sean Gallardy
Sean Gallardy
9:31 PM
@PaulWhite 💵💵💵💵💵💵
Paul White
Paul White
9:41 PM
@ErikDarling I suppose it will always be a compromise between summary view and detail overload
@SeanGallardy Yeah well I know you're planning HTTP waits for memory access next so don't act all innocent or act like you're one of the good guys 🤣
Sean Gallardy
Sean Gallardy
@PaulWhite I wasn't, I was throwing shade on MS for doing http calls for disk storage.
It's all about the Benjamin's baby
Yeah, going over ms latency networks for ns latency memory is gonna be great
Paul White
Paul White
But you are MS
Sean Gallardy
Sean Gallardy
Am I though?
I'm the Ron Swanson of MS
3
Paul White
Paul White
Ha ha ha
Erik Darling
Erik Darling
Ron Swan’son
Paul White
Paul White
9:47 PM
Son of Swan
Sean Gallardy
Sean Gallardy
Sounds like it's time for a new avatar
Erik Darling
Erik Darling
10:31 PM
Better call Lamak
Erik Darling
Erik Darling
10:49 PM
Oh boy
@Lamak I need you now more than ever
user image
Can you make this so it says Erik D up top and Reasonable Rates at the bottom
With some portion of my stupid face peeking out

« first day (5001 days earlier)      last day (22 days later) »