- Feature Articles
- CodeSOD
- Error'd
-
Forums
-
Other Articles
- Random Article
- Other Series
- Alex's Soapbox
- Announcements
- Best of…
- Best of Email
- Best of the Sidebar
- Bring Your Own Code
- Coded Smorgasbord
- Mandatory Fun Day
- Off Topic
- Representative Line
- News Roundup
- Editor's Soapbox
- Software on the Rocks
- Souvenir Potpourri
- Sponsor Post
- Tales from the Interview
- The Daily WTF: Live
- Virtudyne
Admin
Admin
Is it time to start a Godwin pool?
Admin
I find stored procedures useful because so often in big companies the application guys aren't database oriented and thus make design decisions that fail to utilize the horsepower of a big database (see Exadata2). And a database developer using something like PL/SQL can leverage the power more effectively by hiding that complexity from the app developers.
Admin
Admin
Admin
Admin
Yes, exactly. Handled correctly, you get my first case. Handled badly, you get the second. Either way, you stand out, but one way helps you, the other does not.
I don't think we're really disagreeing on this. I'm just emphasizing the "caution" part of it. It'd be easy to blow an otherwise good interview by seeming like a potential problem employee. For example, you could easily mishandle this and create the impression that you're a potential harrassment suit. For another example, you don't want your interviewer to be wondering whether you'd be the guy surfing porn sites in the office. Either of those would probably put you on the "no" pile, no matter how good a programmer you are.
Admin
Admin
Death to Mork.
... (hi. i am not spam. hi. i am not spam. seriously now.)
Admin
Attach a photograph? This must not have been in the US. According to HR folks I've spoken with, any resume that arrives with a photograph attached goes directly in the trash. Apparently, it pollutes the hiring process by opening the possibility of discrimination based on race.
When I mentioned that a person's race could often be guessed just by what their name is, they shrugged and said "Doesn't make any sense, but those are the rules."
If you want a US job, attaching a photo to your application is a good way to not get hired.
Admin
OK smart guy, what race am I?
Admin
Should I keep my tale of college summers spent manually extracting bull semen quiet?
Or just bring a bottle of hand-sanitizer along to offer them?
Admin
Clearly you're a homosexual polynesian dwarf. With jug ears.
Admin
It's hard to talk about Germany's racial uniformity without skating the Godwin line. However, looking at France, it's only slightly more diverse (with a 5.25% of the population coming from Northern Africa and 1.75% from the rest of Africa... although only about 3% of France is black.) Turks only make up 0.7% of the French population.
Admin
I dunno - if you've been up close and personal for a career, the last thing you'd be likely to do is want to spend all your time looking at pictures of it all ... take it from one who knows. Er, so to speak.
Admin
I said could OFTEN be guessed. In case it wasn't obvious enough, I think the whole issue is moronic anyway.
Admin
Come to think of it, I wouldn't want to work for people who are prudish like that, it would put too much of a crimp on interpersonal banter and freedom of expression.
Admin
Admin
+1 pml
Admin
Is it just me?
Why not combine two of these experiences and submit one of those pictures that "the porn guy" took as the "non-returnable photo". Might just work, you never know.
Yes, in the USA, not including the picture is more for the protection of the EMPLOYER, not the candidate. If they don't have it, they can't be blamed. Times have changed. College applications of the 60's routinely asked for a picture (I don't know about now!).
Admin
Admin
Federally, the categories are race, color, religion, sex, and national origin. States are therefore free to permit discrimination based on gender, sexual orientation, and any other category you can think of. Yes, you can be fired in many if not most states for being gay or identifying yourself as a gender that does not match your sex.
In addition, you can discriminate based on any category - including race - if membership in the class is a bone fide occupational qualification (BFOQ). For example, BET can probably get away with only hiring black people to be on the air. Off the air, they probably could not.
Admin
Admin
Admin
Admin
Admin
Ad-hoc SQL is never going to have the execution plan(s) pre-built on the server side, is it? If not, there's a performance hit right there.
I can't speak for Oracle, but on SQL Server, stored procedures are great. They provide all sorts of opportunities to do processing on the DB server, instead of sending masses of data back and forth between the DB server and app server. The people who develop database software specialize in optimizing it for what it does, so why not let that software do that work for you instead of trying to code it yourself?
Tools like LINQ make it easier to do database-style processing off of the server, but it still seems wasteful to do that given the choice between processing in-place and offloading processing to the (probably-not-written-as-well-as-SQL-Server) application tier.
Admin
Here in the USA, that's the most legal reason not to hire someone. What good are past-job references unless employers can use them to deny a job?
... and that guy who played Barney Miller is dead, I think.
Admin
I too can misunderstand a word if I want to.
-Harrow.
Admin
We can go even further than that. In the US, it is legal to decline hiring someone based on his/her credit history. The only criteria that are actionable/protected are gender, race/nationality, religion, political views and (to a degree) sexual inclination, age, handicap status and past criminal record. Everything else is free game for hiring or not hiring someone.
With that said, the days when people were discriminated for minutia is long gone. It is rare (though still occurs). Every country is different, and when you are in that country, you do as in that country. And in this country, it is not appropriate (or wise) to talk about having any type of work with ZOMG! pr0nX0rs! regardless of how easy going the interviewers might be.
Maybe one can talk about it after getting the job... and only in work circumstances that are welcome, permissible and judicious. In life, no matter what country you are, it pays to keep your pie hole shut when at work.
Freedom of expression is best left when you punch out of work, not when you are in. Freedom of expression is not going to take a dent from keeping one's mouth shut while on the clock.
The only time I could think someone should/could talk about such type of past work is if that person is interviewing for a job related to online billing and charging or media streaming (where pr0n is supreme and leads the way.)
Admin
I worked in the UK about 15 years ago, so things might have changed, but then age discrimination was very legal and normal.
Applicant age was prominently mentioned in almost every employment advertisement. You'd see something like 'Java programmer with five years experience, should be between 20 and 30 years of age'.
Here in the United States people over 40 are a protected group, along with veterans, felons, and people descended from Spain. Oddly people of Portuguese descent are not a protected group.
Go figure.
Admin
There, see? Segregating people by some arbitrary group and saying "you can't discriminate against these people" is discrimination! And it perpetuates the idea that some people -- not individuals, but groups -- are weaker, and couldn't make it on their own.
I have a dream... that someday people will not be judged for the color of their skin, but for the content of their character. Radical, I know.
Admin
Admin
Who ever said that ad-hoc SQL was limited to queries? Name one SQL statement (other than RETURN) that can be used in a stored procedure, but not in an ad-hoc batch.
Let's try a little challenge... you post a stored procedure and I'll post ad-hoc SQL that runs nearly identically. Spoiler: I'm simply going to remove the CREATE PROC from your post, turn the arguments into batch variables and re-post it.
Admin
Admin
Why is this not blue?
Admin
That one had me rollin'.
Sounds silly, but before I realized what they were and had to write a few, I thought stored procedures were the functions we wrote for the database (from say PHP). Can you tell I started on MySQL?
captcha: paratus .. a wha?
Admin
Not exactly porn, but I once tried a stunt with a company where I was interviewing but actually did not want to go. They asked for a reference, and I gave them my former manager, just out of curiosity, what happens if they get a mixed response, and also how do people give this kind of mixed responses?
So a couple of days later they bothered to invite me again for a casual lunch talk, and started grilling me regarding my personal traits. I hardly concealed my smile, and was just curious, what exactly went wrong etc.
So now I know how it works.
Then the recruiter asked me what happened, and again, out of curiosity, I told him what happened. "You are very smart" he said. Probably in their language it means "you are an idiot". (Well, 23andme recently told me that not caring about negative response is in my genes...)
Admin
Actually, the issue is that it's difficult for anyone to send an unreturnable photo by email.
Admin
If you're not working with an embedded system, you probably don't care about atomic operations, and if you are working with an embedded system, you're likely to need to know what one is.
Admin
That said, candidates rarely find out why they have been rejected. And I don't suppose previously having held a job as a porn camerawoman would break the law (in the way that, say, rejecting an ex-soldier could do).
Admin
I love tales from the interview.
Admin
... When a user process inserts an execution plan into the cache, the user process sets the current cost equal to the original query compile cost; for ad-hoc execution plans, the user process sets the current cost to zero. ... The following examples illustrate which execution plans get removed from the procedure cache:
...so it looks to me that if the adhoc query is being looped, it'll eventually get costed, else it'll get flushed.
Admin
Probably too racey.
Admin
Naah, just write your own database drivers. It should only take about six weeks.
Admin
The company obviously built process controllers for nuclear power plants. Geeze, do I have to do all the thinking around here?
Admin
Oh for fscks sake will people stop going on about Uncle Liz being a woman! For one thing it's upsetting Aunty Steve.
Admin
On the other hand, some of what I do is a language runtime.
On the other-other hand, I would expect that an embedded system whose OS is so rudimentary that it doesn't offer application programmers the usual suite of concurrency primitives would be a single-core affair where atomicity is relatively simple -- no worrying about memory hierarchies and using the right kind of barrier. But I don't actually know that, no.
Admin
Admin
I mean that context matters. Talking about it in passing is fine. I personally don't have a problem with it - but I think mentioning it in an interview shows poor judgement. Do you want to employ people with poor judgement?