« first day (320 days earlier)
← previous day
next day →
last day (369 days later) »
Sean Gallardy
1:17 AM
@jadarnel27 All is going according to plan...
1 hour later…
jadarnel27
2:43 AM
Worried about Paul's safety tbh.
12 hours later…
Joe Obbish
2:45 PM
room topic changed to stop the merry-go-round: πππ GROUP BY FRIDAY 13:00 EST - BE THERE OR BE LAMAK πππ | Gallery, but feel free to request write access if you read SQL Server CU fixes for fun [database-internals] [sql-server]
Forrest
I'll try not to be Lamak
Joe Obbish
that's all any of us can do
Lamak
we are all lamak
6
4 hours later…
Lamak
6:47 PM
@sp_BlitzErik are you here?
Joe Obbish
7:12 PM
I think he's busy speaking French
Lamak
ah, shoot
the one time that I actually wanted to ask him something
Joe Obbish
what's your question?
Lamak
it was about sp_blitzQueryStore
Joe Obbish
oh, I don't use that
hth
Lamak
@JoeObbish the thing is, it checks the "database" version first
I mean, the server versionβ¦
but I was trying to run it in Azure....so the server version isn't necessarily the database version
I don't know, I don't really get it
Joe Obbish
7:30 PM
sounds like an azure problem
Lamak
I like to think about it like an Erik problem
Lamak
7:48 PM
@JoeObbish so....are you here?
I need another pair of eyes
Joe Obbish
what's up?
I'm just barely here
Lamak
ah, maybe I barely need another pair of eyes
so, why would this happen?
Forrest
no repro (MI)
Lamak
MI?
Joe Obbish
try nvarchar?
Forrest
7:56 PM
managed instance
Lamak
@Forrest ah
Forrest
What is
SERVERPROPERTY('collation')
?
jadarnel27
I was just about to mention that! There was an issue in the FRK repo recently about Azure and mixed collations:
github.com/BrentOzarULTD/SQL-Server-First-Responder-Kit/issues/…
The problem in the end on that one was that the instance collation was different from the database collation.
Lamak
@Forrest SQL_Latin1_General_CP1_CI_AS
Forrest
try doing a convert to varchar first
SERVERPROPERTY seems to be outputting a sqlvariant, and I can get similar behavior by forcing a different collation
Lamak
8:04 PM
@Forrest yup, that did it
Forrest
+15! oh wait....
Lamak
@Forrest dude, forget the +15, now we can ask Brent to hire you to fix Erik's code
Forrest
Oh boy, now I get to work with more XQuery!
Hmmm....
Uh, maybe I'll pass
Lamak
well, I can't make it work anyway
@Forrest well?, aren't you gonna fix it?
;)
Forrest
Only for a fee. I accept Query Pesos and unusual repros.
Lamak
8:13 PM
when did you get so greedy?, I remember the times you were happy just making some puns
on another note, how do I win some Query Pesos?
Forrest
@Lamak Gotta pay upkeep for the blog now.
Joe Obbish
whenever I get mad at @Forrest I angrily refresh his blog
Lamak
what's his blog?
Forrest
@Lamak Isn't that what your servers use instead of Query Bucks? ;)
Lamak
@Forrest I mean, it's in the cloud, so it gets converted somewhere there
Forrest
8:19 PM
probably to DTU...blech
Lamak
@Forrest yeah, and that's the reason we can't use R yet
Forrest
blog is at forrestmcdaniel.com
2
Joe Obbish
8:55 PM
sp_whoisactive took over 90 s to run
should I run another sp_whoisactive to see why it's taking so long?
Forrest
run 5, just in case
2 hours later…
sp_BlitzErik
11:14 PM
@Lamak i am now
Joe Obbish
11:31 PM
@sp_BlitzErik the google robots are disappointed
Paul White
11:43 PM
the natural state of a googlebot
Joe Obbish
Source spid78 Message Failed allocate pages: FAIL_PAGE_ALLOCATION 2048
I am also disappointed
sp_BlitzErik
@JoeObbish they should try not being evil
so did i miss any good questions while i was away?
Joe Obbish
@sp_BlitzErik no
sp_BlitzErik
good
Joe Obbish
unless one was asked today
« first day (320 days earlier)
← previous day
next day →
last day (369 days later) »
all rooms
Transcript for
Dec
16
Dec '18
17
Dec
18
♦
stop the merry-go-round
Gallery room. Feel free to request write access if you read SQ...
database-internals
hope-that-helps
sql-server
join this room
about this room
00:00
06:00
12:00
18:00
all times are UTC
site design / logo © 2024 Stack Exchange Inc;
legal
mobile