« first day (2519 days earlier)      last day (2365 days later) » 

12:33 AM
hrm. how come the stackexchange db shows more upvotes per tag than my console?
ohh
that's deceptive.
It's upvotes not score which is upvotes on answers.
oh no, that must be including close votes
 
 
7 hours later…
7:50 AM
morning
 
good morning
@JoeObbish It can be a pain.
I normally use Atlassian's SourceTree to come to grips with Git & Github.
I then pull down the repository from their "upstream" and synchronise with my "origin".
I then change the code in a new "dev" or "Patch-1" branch on my local machine and synchronise that with my origin\dev or origin\Patch-1 branch on Github.
That is then referenced in the "Pull Request" on Github in the SQL-Server-First-Responder DEV branch.
 
 
1 hour later…
9:05 AM
Morning
 
 
5 hours later…
1:52 PM
evening and morning (late 1)
 
 
2 hours later…
3:30 PM
Having fun writing C extensions for Postgres :-D
 
@ChrisTravers you could be working with access...
 
I wrote about 200 lines of C on Friday that I spent about 1 hr debugging today and they seem to solve about half my problem so actually having fun :-D
(this code will run in d b servers having about 20TB of data each)
 
4:16 PM
cya folks
 
4:27 PM
@ChrisTravers you are into some hacking as always?
 
 
1 hour later…
5:45 PM
@ChrisTravers I think the last time I wrote C code that went into production was nearly 10 years ago. It makes me feel old. Are you still based out of Indonesia?
 
 
2 hours later…
7:27 PM
@sp_BlitzErik Do you know if the XE session will actually show that the SELECT statement that caused an automatic stats update to run caused writes? I'm just trying to verify that now
 
@JamesL which xe session?
do you mean for auto_stats?
 
@sp_BlitzErik An XE session in general
Yes
 
@sp_BlitzErik you killed his self-answer dude
 
I'm assuming an XE session would show that an auto_stats event caused writes, not the query that caused the auto_stats event to occur
 
@Lamak slam dunk
@JamesL hang on, i'll add an answer as as example
 
7:33 PM
auto_stats is going to be a much more common case (with slightly different symptoms) certainly
okay thanks, that's probably best
don't want to encourage people to look for obscure edge cases instead of the obvious
 
@ConcernedOfTunbridgeWells In Berlin right now.
 
@JamesL done
 
@swasheck doesn't come here anymore because he's too busy selling things.
@sp_BlitzErik thanks
 
@sp_BlitzErik so, when are you guys coming to chile?
 
7:44 PM
have i mentioned that i hate it when software uses implicit trans for no good reason
 
@Lamak when i get into real big trouble
 
@Lamak why would someone visit a country unable to qualify for the world cup
 
is that a drinking contest?
 
@sp_BlitzErik for the fans probably
 
@TomV that's quite a good question
 
7:48 PM
I was just trolling him. It's been a while since I had the opportunity
 
@sp_BlitzErik so, today?
 
finally got over 2000 dba.se points
2
 
@TomV I was away for the week
 
too bad i can't trade them on a cryptocurrency exchange
 
Sorry @Lamak but if Bill and Seth don't show up anymore you are my last chance target
 
7:51 PM
yeah, those guys are no fun anymore
 
It's sad really
 
also, the camera at your workplace isn't working now
;)
 
That wasn't a camera you read my mind
I purchased a new tinfoil hat during black Friday
 
@Lamak well, i haven't left the house yet, so maybe
 
ah, money well spent
 
7:57 PM
this filter operator won't show up where I want it to
it is most vexing
 
I tried hard not too laugh today
A meeting with business stakeholders related to the query I posted last week
 
@JoeObbish use a cte :D
 
The c something o doesn't understand why it's impossible to optimize a query with over a hundred things in the where clause so he referred to 'how does Google do it'
 
'Google doesn't search random combinations of columns and is optimized for text search' ringed a bell
 
8:06 PM
he probably thinks every word you type in gets compared to a different column
 
'but they have lakh times your budget' didn't
 
'HOW DO I CEO"
 
They are looking into building their own in memory thing now specifically designed for the purpose
Fine by me 🤣
 
They budgeted a little under a k euro
 
8:14 PM
why not just use memsql
 
You burn through that fairly quickly when going through that rabbit hole
@sp_BlitzErik we're special
 
@TomV well, you know, in-memory is so easy, that's why everyone does it out of the box.
 
Their queries now finish in 2ms or under a ms depending on if it is from memory or flash disks
Have fun making it faster
 
well they'll be more in memory
 
@TomV there's actually a COLUMNSTORE INDEX case study that MS talks about related to that
 
8:18 PM
don't you get it?
 
@JoeObbish CCI has proven to be (marginally) slower
 
but the case study doesn't make any sense
and I sat through it twice
I FIXED THE FILTER
 
xml or it didn't happen
 
need to chop down the demo first
 
Now looking for PostgreSQL database architects and people who can hack the db to hire :-P
haha
 
8:23 PM
@ChrisTravers you can hire @EvanCarroll if you promise to put dba.se chat behind a firewall
 
@sp_BlitzErik haha. might see what I can do.
 
@ChrisTravers A friend of my wife married a German guy who set up an Indonesian restaurant in Berlin.
 
@JamesL i'm not selling anything yet
 
@ChrisTravers I'm open to offers but I wouldn't call myself an architect ;)
 
8:49 PM
@ypercubeᵀᴹ Learn C if you don't already know it.
 
better than Perl
 
@ConcernedOfTunbridgeWells Awesome. What is the name of the restaurant?
 
Can't remember. I'll find out.
 
@ypercubeᵀᴹ What is the restaurant?
@ypercubeᵀᴹ feel free to send a resume to Chris.travers@adjust.com ;-)
 
9:06 PM
@sp_BlitzErik you <3 me
 
@EvanCarroll it's true, I just get so madly jealous watching you chat with other data professionals.
 
@swasheck do you write perl and C?
 
@ChrisTravers I don't know. That's COTW's friend, not mine.
 
@sp_BlitzErik it was a chat room for data professionals before, now it's filled with Evan-voyeurs.
@ChrisTravers what are you looking for in db-hackery.
 
@EvanCarroll how depraved~
 
9:23 PM
> Tell me do you think it'd be all right
If I could just crash here tonight
You can see I'm in no shape for driving
And anyway I've got no place to go
 
the satisfaction of creating the perfect repro ~
 
10:01 PM
@JoeObbish getting to your demo in a moment
 
such a gift for naming things
 
yes
 
10:36 PM
this one is too specific, right?
0
Q: Is there any available documentation on EPIC clarity table relations?

lampShadesDrifterIs there any (openly) available documentation on EPIC clarity table relations (aside from the data dictionary, eg. table relation diagrams, data flow documentation, or docs on how certain tables 'work' (specifically in the area of Professional Billing))? Have access to specific tables in EPIC cl...

 
10:48 PM
i mean, this is a bad forum to ask, but if you know anyone who works for that big bad $isv, you could show them that question so that perhaps proper documentation is written and easy to locate.
 
@sp_BlitzErik life isn't that simple
 
@ChrisTravers in Indonesia?
 
@JoeObbish life or schema?
 
@sp_BlitzErik what do you use for adding arrows to screenshots? snagit?
 
@JamesL yep, it has the most accusatory red arrows I've been able to find.
 
11:14 PM
@dezso he seems to be located very near you, at least for right 4 hours ago ;)
4 hours ago, by Chris Travers
@ConcernedOfTunbridgeWells In Berlin right now.
 

« first day (2519 days earlier)      last day (2365 days later) »