May 24, 2012 at 4:31 am
<RANT>
can we get this guy banned from the site?
k.subramanyam1017
I for one see the value in people asking the most basic questions. I have gained by looking at simple problems other people ask and learning from the responses. Nowadays i do more responding than asking.
but this guy takes the biscuit
http://qa.sqlservercentral.com/Forums/Topic1303209-391-1.aspx
http://qa.sqlservercentral.com/Forums/Topic1293145-391-1.aspx
http://qa.sqlservercentral.com/Forums/Topic1292352-391-1.aspx
http://qa.sqlservercentral.com/Forums/Topic1292298-391-1.aspx
he is openly admitting that he is putting stuff on his CV and then when he goes for an interview he's asking the forums for the answers to questions that even the most basic junior dba/dev would be able to google
my favourite was "how to fail over primary in log shipping then witnes is involved" , "please requirements for install sql 2005" and most spectacularly "difference between 2005 and 2008"
can't we just get rid of this time waster pleeeeeaaaaaaaase ? it means the active threads screen becomes clogged with rubbish and the people who really need help get overlooked.
</RANT>
MVDBA
May 24, 2012 at 4:51 am
oh and by the way, the irony of me clogging up the "active forums page" with a complaint about users clogging up the active forums page is not at all lost on me :hehe:
MVDBA
May 24, 2012 at 5:06 am
Hear hear!
We're all guilty of asking idiotic questions from time to time but not to know the basic fundamentals of your job, then lying about it on CVs? Too much.
I have the task of sitting in as technical advisor on some upcoming DBA interviews at my place. I sincerely hope the CVs we've received are genuine as we've got some really good candidates.
I'm going to pose the Fizzbuzz problem to them along with a more generic SQL Server Q&A *evil cackle*
---
Note to developers:Want to get the best help? Click here https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help (Jeff Moden)
My blog: http://uksqldba.blogspot.com
Visit http://www.DerekColley.co.uk to find out more about me.
May 24, 2012 at 5:13 am
derek.colley (5/24/2012)
Hear hear!We're all guilty of asking idiotic questions from time to time but not to know the basic fundamentals of your job, then lying about it on CVs? Too much.
I have the task of sitting in as technical advisor on some upcoming DBA interviews at my place. I sincerely hope the CVs we've received are genuine as we've got some really good candidates.
I'm going to pose the Fizzbuzz problem to them along with a more generic SQL Server Q&A *evil cackle*
if using modulo (%) is your "evil interview" then you are never going to get an empire of dba "sharks with frickin laser beams!!!"
just to spoil your interview - please all attendees read the following :hehe:
select case
when (a%5=0) and (a%3=0) then 'fizzbuzz'
when (a%5=0) and (a%3>0) then 'fizz'
when (a%5>0) and (a%3=0) then 'buzz'
else a
END
from........
MVDBA
May 24, 2012 at 5:22 am
Fizzbuzz is your evil interview? Really? It's as old as dirt (as are the solutions) 😛
WITH t1 AS (SELECT 1 N UNION ALL SELECT 1 N),
t2 AS (SELECT 1 N FROM t1 x, t1 y),
t3 AS (SELECT 1 N FROM t2 x, t2 y),
tally AS (SELECT ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) AS number
FROM t3 x, t3 y)
SELECT t.number,
CASE WHEN t.number%3 = 0 AND t.number%5 = 0
THEN 'FizzBuzz'
WHEN t.number%3 = 0
THEN 'Fizz'
WHEN t.number%5 = 0
THEN 'Buzz'
ELSE CONVERT(VARCHAR(3),t.number)
END AS result
FROM tally t
WHERE t.number <= 100 AND t.number >= 1;
--edit--
Oh, and as for banning - I say "no". You don't have to answer them, you can ignore anyone you wish. If people start getting banned for asking "basic questions", where does the line get drawn? Who draws the lines?
May 24, 2012 at 5:41 am
Oh god, not another bunfight. My last post started a row between two MVPs.
The reason I haven't dreamt up anything properly evil is because my company isn't paying market rate and the local talent pool is small. And while I would like to get the UK equivalent of Grant Fritchley or Brad McGehee its unlikely. I shouldn't have added the evil laugh. But what I do want to do is weed out the candidates who looked up the job spec on Google and filled their CV full of twaddle.
I'm moving on and my job interview included an on-the-job simulation of a database infrastructure to redesign on the fly and various problems to solve from mass data import to SP tuning. I'm not being remotely as horrible, as its possible I won't even be in on the interview so setting up bastard questions is going to be pointless if no one else can understand the answers.
The idea of Fizzbuzz for me is to assess the candidates problem solving skills.
---
Note to developers:Want to get the best help? Click here https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help (Jeff Moden)
My blog: http://uksqldba.blogspot.com
Visit http://www.DerekColley.co.uk to find out more about me.
May 24, 2012 at 5:41 am
Edit: Duplicate post removed, I blame my phone 🙂
---
Note to developers:Want to get the best help? Click here https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help (Jeff Moden)
My blog: http://uksqldba.blogspot.com
Visit http://www.DerekColley.co.uk to find out more about me.
May 24, 2012 at 5:50 am
I'm with Craig on this one it seems a bit harsh and high maintenance to enforce such a ruling.
People have to start somewhere, but at least do your own research first before asking questions.
The problem with this forumer is that he wants the answers to questions asked in an interview, if you dont know the stuff, dont apply for the job and dont make out you know the stuff as you will just trip yourself up, if not in the interview, then when something goes all Chuck Norris on your rear end and your employer wants you to sort it, especially after you have bragged about it on your CV and the interview.
May 24, 2012 at 6:24 am
What!? You want to ban the biggest comedian of this entire forum?
😀 😎 :hehe:
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 24, 2012 at 8:30 am
Oh, and as for banning - I say "no". You don't have to answer them, you can ignore anyone you wish. If people start getting banned for asking "basic questions", where does the line get drawn? Who draws the lines?
+1
The last thing we want do around SSC is become a bunch of arrogant and snobbish people. There are plenty of other forums out there for that kind of thing.
Think the questions is too basic? Ignore it.
Think the poster is too stupid to remember to breath while walking? Ignore it.
Always keep in mind that the questions you find super easy today are a great chance for some less experienced folks to start answering. This helps to give them some confidence. We need this type of thing to maintain this place over the long haul.
I say "Up the Basic Questions"!!!!
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
May 24, 2012 at 9:15 am
Cadavre (5/24/2012)
Fizzbuzz is your evil interview? Really? It's as old as dirt (as are the solutions) 😛
WITH t1 AS (SELECT 1 N UNION ALL SELECT 1 N),t2 AS (SELECT 1 N FROM t1 x, t1 y),
t3 AS (SELECT 1 N FROM t2 x, t2 y),
tally AS (SELECT ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) AS number
FROM t3 x, t3 y)
SELECT t.number,
CASE WHEN t.number%3 = 0 AND t.number%5 = 0
THEN 'FizzBuzz'
WHEN t.number%3 = 0
THEN 'Fizz'
WHEN t.number%5 = 0
THEN 'Buzz'
ELSE CONVERT(VARCHAR(3),t.number)
END AS result
FROM tally t
WHERE t.number <= 100 AND t.number >= 1;
--edit--
Oh, and as for banning - I say "no". You don't have to answer them, you can ignore anyone you wish. If people start getting banned for asking "basic questions", where does the line get drawn? Who draws the lines?
Here is my FizzBuzz solution:
WITH
E1(N) AS (
SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1 UNION ALL
SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1 UNION ALL
SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1
), --10E+1 or 10 rows
E2(N) AS (SELECT 1 FROM E1 a, E1 b), --10E+2 or 100 rows
E4(N) AS (SELECT 1 FROM E2 a, E2 b), --10E+4 or 10,000 rows max
cteTally(N) AS (
SELECT ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) FROM E4
)
select
isnull(nullif(case when N % 3 = 0 then 'Fizz' else '' end + case when N % 5 = 0 then 'Buzz' else '' end, ''),cast(N as varchar))
from
cteTally
where
N <= 100
May 24, 2012 at 2:40 pm
Sean Lange (5/24/2012)
Always keep in mind that the questions you find super easy today are a great chance for some less experienced folks to start answering. This helps to give them some confidence. We need this type of thing to maintain this place over the long haul.
I say "Up the Basic Questions"!!!!
In my opinion, there's a big difference between basic questions of people who are trying to learn, or interview questions of someone too lazy to do research and who's trying to cheat through the interview.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 24, 2012 at 2:46 pm
Koen Verbeeck (5/24/2012)
Sean Lange (5/24/2012)
Always keep in mind that the questions you find super easy today are a great chance for some less experienced folks to start answering. This helps to give them some confidence. We need this type of thing to maintain this place over the long haul.
I say "Up the Basic Questions"!!!!
In my opinion, there's a big difference between basic questions of people who are trying to learn, or interview questions of someone too lazy to do research and who's trying to cheat through the interview.
This is true. It is also incredibly obvious when these types of questions arise. It is up to the individual to decide not to answer, or dog pile the OP as the thread in question does. 😛
And any interviewer who has conducted more than 1 interview will be able to through a smokescreen, especially one as obvious this person's. Sheesh a simple select statement might prove challenging for that person. That still is no reason to ban them. It just goes against the nature of this site entirely.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
May 24, 2012 at 3:38 pm
Sean Lange (5/24/2012)
Koen Verbeeck (5/24/2012)
Sean Lange (5/24/2012)
Always keep in mind that the questions you find super easy today are a great chance for some less experienced folks to start answering. This helps to give them some confidence. We need this type of thing to maintain this place over the long haul.
I say "Up the Basic Questions"!!!!
In my opinion, there's a big difference between basic questions of people who are trying to learn, or interview questions of someone too lazy to do research and who's trying to cheat through the interview.
This is true. It is also incredibly obvious when these types of questions arise. It is up to the individual to decide not to answer, or dog pile the OP as the thread in question does. 😛
And any interviewer who has conducted more than 1 interview will be able to through a smokescreen, especially one as obvious this person's. Sheesh a simple select statement might prove challenging for that person. That still is no reason to ban them. It just goes against the nature of this site entirely.
Just to be clear, I don't want to ban him.
I do however reserve the right to be annoyed by interview questions 😀
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 24, 2012 at 4:02 pm
Cadavre (5/24/2012)
Oh, and as for banning - I say "no". You don't have to answer them, you can ignore anyone you wish. If people start getting banned for asking "basic questions", where does the line get drawn? Who draws the lines?
+1. I'd rather see people document their lunacy in such posts. Makes me really happy about the people I work with and also tells me a bit more what to look for when someone answers a question in an interview I'm sitting in on.
--Jeff Moden
Viewing 15 posts - 1 through 15 (of 63 total)
You must be logged in to reply to this topic. Login to reply