« first day (2574 days earlier)      last day (2284 days later) » 

Paul White
Paul White
5:53 AM
@EvanCarroll Which question?
 
 
3 hours later…
Evan Carroll
Evan Carroll
8:44 AM
32
Q: Methods for finding new Trace Flags in SQL Server

sp_BlitzErikThere are a lot of Trace Flags out there. Some are well-documented, some are not, and others found their way to default behavior status in the 2016 release. Aside from official support channels, Microsoft employees, etc., what are ways to find new trace flags? I've read through a couple recent p...

sql-server trace-flags
re @PaulWhite
 
Paul White
Paul White
Oh, right.
 
 
3 hours later…
hot2use
hot2use
11:47 AM
Good <time-of-chat-users-day-section> everybody
 
 
3 hours later…
McNets
McNets
2:49 PM
@AndriyM thanks
 
Andriy M
Andriy M
3:17 PM
@McNets My pleasure
 
sp_BlitzErik
sp_BlitzErik
3:41 PM
sweeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeet
Our recent work on UDF optimization in SQL Server https://twitter.com/pvldb/status/954889298842660865
Tweeted by karthiksr on January 21, 2018 at 6:19 AM
5
 
 
1 hour later…
Sean Gallardy - Microsoft
Sean Gallardy - Microsoft
5:09 PM
'Git', spelled like how a Texan says 'Get'
 
 
2 hours later…
ypercubeᵀᴹ
ypercubeᵀᴹ
7:24 PM
0
Q: Protect postgres database from slow queries

caseymI'm running a Django web site on Heroku, with the database hosted on RDS. There are some queries out there that take 10 to 15 seconds. Yesterday I got a lot of those and it overwhelmed the database. Write IOPS went above 700, CPU went to 90%, and connections went to 0. I'm upgrading the database ...

postgresql
 
Andriy M
Andriy M
11
Q: How do I detach all other users from a postgres database?

mitI need exclusive access to a database. Is it possible using an SQL command to "detach" all other users from a postgres database. Or maybe closing all other connections and then gaining exclusive access. This is for unit testing, and tests are only run manually, so there is no danger involved. On...

postgresql
Problem solved
 
ypercubeᵀᴹ
ypercubeᵀᴹ
@AndriyM head hurts, chop head ;)
 
Andriy M
Andriy M
Something like that :)
 
Evan Carroll
Evan Carroll
8:05 PM
HALLO MY PEOPLE.
 
Evan Carroll
Evan Carroll
8:20 PM
First 500pt bounty of 2018?
 
Paul White
Paul White
8:32 PM
> These answers are all subpar some are outright wrong. TAKE IT TO 11.
You really know how to win friends and influence people eh Evan
 
Evan Carroll
Evan Carroll
11 has the secret handshakes
 
Paul White
Paul White
On a Q & A with 111 upvotes and no downvotes
Your humour really missed the mark with me this morning
 
Evan Carroll
Evan Carroll
my bad I'm just playing, I just think this can be done a different way
 
Paul White
Paul White
 
Evan Carroll
Evan Carroll
I'm not saying that those are bad ways, they are ways and they're totally functional and I've used brute force discovery on this very site. It's very much functional. However, it's not the only way, certainly. And, it's not the best way.
Maybe that joke went too far, my bad. Didn't see that.
 
Paul White
Paul White
8:41 PM
Well I'm not going to cancel the bounty. It is what it is.
Going to get coffee. Back in a bit.
 
Evan Carroll
Evan Carroll
If you want to cancel it I'll remove the statement and repost the bounty, and be totally cool with it.
Didn't mean to offend, sometimes I play too hard.
 
Paul White
Paul White
Hm Ok maybe that would be best. Done. Try again.
 
Evan Carroll
Evan Carroll
That really should have said some of those statements are outright wrong, that was too strong.
Cool, hopefully that's better.
Btw, I was mainly addressing this "There's nothing you can do to find the list except ask or pick them up from posts/slide decks/etc"
@PaulWhite we still best friends?
PAUL?!?!????
PAULLLLLLLL???????????????????????????????????
 
Paul White
Paul White
9:23 PM
Sure. (coffee acquired)
 
Evan Carroll
Evan Carroll
9:34 PM
all hail the nectar of the gods.
I never heard of the liveoverflow channel on youtube
What an amazing resource.
I learned Scheme watching videos from MIT when they first went public with their open coursewear. It's amazing how much inefficient the formal instruction is. You go back and you watch that stuff, and you just think about how much instruction time is wasted with the professor writing on the blackboard, you watch these kinds of polished videos on youtubes without that inefficiency and at 2x speed -- probably do a month of work in a 5 days.
 
sp_BlitzErik
sp_BlitzErik
9:56 PM
@PaulWhite press 1 if you are under nda about froid :)
 

« first day (2574 days earlier)      last day (2284 days later) »