Ed Wagner (9/4/2014)
Koen Verbeeck (9/4/2014)
andrew gothard (9/4/2014)
I've just been told: "We don't recommend running SQL commands against the database"
Right. May as well go home then!
You know Chris Date? Cool
Nah, Chris Date would say SQL Server (and other RMDBS) aren't relational anyway, so just might use SQL anyway... 😀
Two situations yesterday really caused me to think last night.
I don't understand why certain people have to go on such rants and rip people up one side and down the other when it comes to such simple things in SQL. Some poor guy posts a simple question and gets a couple of good responses, only to have Joe come on a completely shred the OP from top to bottom. I don't know if he does this for pleasure or if he's married to ANSI so hard that he can't seem to acknowledge anything else. I mean, seriously, we're working in SQL Server, so we should use the SQL Server language (T-SQL) to it's fullest advantage to eek as much performance out of it as possible. This business he spews forth with ANSI data types and lack of relational theory is argumentative and just plain silly. What's the real point? To make the OP feel small and stupid? Why? To what end? Maybe it makes him feel better about himself. But again, why?
While he's never dressed me down personally on any of my posts, I'm to the point where I don't even want to post anywhere he's posted anything. I'm absolutely sure I don't follow ANSI standards 100% of the time and am fine with that. I admit I'm tempted sometimes to bait him to going off on a rant where he spends 35 minutes typing a 4-page response to a 5-line solution, but I haven't succumbed to that temptation yet.
Then there's the opposite end of the spectrum where the "silver spoon user" doesn't want to try anything or even think for himself. Really, isn't coding about understanding process, iterative development and thinking things through logically? He must have missed that class, but how do you ever survive as a developer without being able to think logically and figure things out?
Okay, my own rant is over and I'm off my soap box.
It is a bit frustrating to see someone who wants to learn get ripped with absolutely no help from the one posting the rant.
About all they learn is there is someone out there who has time to waste, and nothing to offer.
May as well be posting about the benefits of cooking with powdered water than their rant.
As for the silver spoon user, they will never get anywhere depending on someone else to do their work for them.
And will probably copy and paste something they don't understand into production at some point, which may result in an unexpected job search.
SQL is a learned language, not something you are born knowing.
Just like everything else you know.
You learn from your mistakes.
Or eventually get burned, just a matter of time.