« first day (4304 days earlier)      last day (863 days later) » 

01:42
Looks like a link to a profile
HtH
 
6 hours later…
08:01
morning
08:18
morning
morning
 
2 hours later…
10:04
0
Q: Negative votes with unknown reason should be a thing?

lemonI'm a fairly regular Stack Overflow answering user and a new user for this specific community of Database Administrators. Yesterday I was scraping through the open issues and decided to attempt helping a guy having problems with a query, with a workaround to their schema design. Op's was satisfie...

 
2 hours later…
11:47
Morning
@MasterDatabase Love the premise, anyway.
12:10
'Morning.
12:46
hard to imagine a regular SO user being surprised about downvotes with no comments
True lol
Hard to imagine what the fuss is all about, without an actual example, ey?
tempted to downvote
13:03
-1
A: SQL Server: left join resulting in multiple rows, want each row result in separate column in result

lemonYour "Table 2" mapping won't help you for this task, because it holds non-useful association between A values and B values (A1 is matched with B1 and B2. A2 is matched with B3 and B4). What you can do here is generate an ad-hoc remapping with ranking values using three window functions: ROW_NUMB...

Reminds me of the chess engine's ?? Blunder. If it's marked as such, you don't get an explanation why, you have to find out.
13:45
@J.D. Are thinking of Great Plains they took over from the company in Fargo, North Dakota?
14:05
more like great pains eh eh eh
golf swing
15:17
Stats are overrated
15:30
Good morning
15:58
@ErikDarling You could offer him some training
i don't know how much more i could offer
The thing that struck me about "lemon"'s profile, when Erik linked to it earlier, is that they sell query tuning services.
> Need a fully dedicated service? Spot me on Fiverr >> fiverr.com/tfranza
Also, they seem to enjoy regex
@PaulWhite That's how you know they're a psychopath
Maybe I should get on fiverr
@bbaird 😀
16:34
@ErikDarling Might be an option for lowly peons like myself
 
1 hour later…
17:41
@SeanGallardy nah don't think so. I heard it second hand from our ERP consultant at the time. I'm guessing he was referring to Damgaard Data. Didn't realize IBM was involved too, I envisioned a small shop project.
18:24
@J.D. MS bought a lot of stuff around that era, hard to know all the hands in teh cookie jars :D
Fair enough lol
I will say, I liked AX better than the ERP system we use at my current place. Idk how ours can be accurate with how poorly written the code is (at least in the database side), and the intricacies they chose when architecting the database. But all ERP systems I've seen so far are jungles regardless.
18:42
Nothing wrong about a person that tunes queries and likes regex.
@Zikato No one likes regex. At best, it is dealt with - like a hangover or perhaps an old sports injury
(goes back to editing REGEX statements in teradata)
@Zikato Nice one. JEAGL please
19:07
@J.D. I spoke to a SAP developer once... said it was insane trying to figure out some of these customer's setup their stuff.
@ypercubeᵀᴹ I love regex and tuning queries. I don't sell my tuning though
 
2 hours later…
20:57
@SeanGallardy Yea I believe it. There's too many intricacies ERP systems need to account for. Probably could never pay me enough to build one from the ground up. I'll happily complain about other people's code who have though. 😆
 
1 hour later…
22:08
what's the easiest way to get a query to timeout in ssms (like using waitfor or something)?
22:34
What does REALLY "rubberducking" mean, in fact? Quite a riddle, isn't it?
Would you consider SQLite to be beginner-friendly for a person that is otherwise quite familiar with Python? DB usage being simple and trivial compared to the app's business logic, just a few basic requests to handle user stuff.
22:50
I have to disagree with your opinion on nobody supposedly liking regex. Regex is a tool, and in many instances, it is THE tool. Powerful and precise, yet nuanced enough to have driven many people to temporarily lose their marbles. And regardless, the added bonus of being a master-key joke -- say anything remotely witty, or even just snarky that involves the word "regex", and one out of three computer developers will laugh like they have heard the best joke in their life. Win-win scenario.
23:32
@ErikDarling tools, options, query execution, SQL server, general, execution timeout.
23:45
Beginners were a mistake

« first day (4304 days earlier)      last day (863 days later) »