Joined devRant on 5/28/2017
Do all the things like ++ or -- rants, post your own rants, comment on others' rants and build your customized dev avatarSign Up
I absolutely hate software that throws error message boxes that look identical to their "please enter new password" message box.
User called and said they needed their password reset. I give them a temp pin and tell them to press ok to the prompt and then put new password in. She says it is still saying invalid pin. This goes on for 10 minutes. I hang up and try on my laptop. Works fine. Then it hits me.
The message boxes look the same. Have the same width and height and shitty little yellow triangle with ! In the middle. The only difference between them is the text in size 9 font.
Gotta read people...cause sometimes the people developing your software assume you can. And to all the software people out there....end users don't want to fucking read.4
I haven't told anyone I know yet but yesterday I got a call from a user and she asked me if I could come down and take a look at some software I support. I did and fixed the issue.
She then asked if I could take a look at her computer because help desk and PC team had tried to fix and couldn't.
5 minutes later I fixed it (every site she went to gave cert error in both chrome and ie). I stood up and there was a couple seconds of me and her just facing each other not saying anything. She was smiling ear to ear the whole time. (This issue was weeks old I think). Then she walks towards me......
And hugs me.25
So back to the stories of the gentleman with his master's degree who's job I wasn't qualified for. Hope you all enjoy this gem I found in his stored procedure.
Select distinct *
Select * from a inner join b on a.id=b.id
Select * from a full join b on a.id=b.id
Where b.id is null
An inner join unioned to a full join where you exclude null values in right table creates a.....left join you fucking idiot!5
When the guy with his master's who's job you were told you weren't qualified for performed the following all in one query:
1. A massive many to many join on a 4 million row table.....to itself on in inner query through a linked server.
2. Decides to try and join this massive inner query (see step 1) to another table on a second many to many join.
3. Writes a function for month. Yes instead of month(literallyadate)
Then this guy emails me to ask if I can optimize it because we yelled at him for trying to insert 216 GB of data into a table (again on a massive many to many joined disaster). We told him if a query was taking more than 40 minutes we needed to see it.
I regret saying that now...should have just bought more space ;)3