Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Just Enough know-how Expand / Collapse
Author
Message
Posted Monday, May 12, 2014 8:51 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Today @ 9:10 AM
Points: 80, Visits: 296
Last week, the developer asked me if it would be OK to add indexes to columns A,B,C,D,E,F,G,H, and I on TableA? I was a bit confused and asked him why? He said it would speed up the query so I asked to see the query. He said he didn't have it because EF created it, but indexes speed up queries right?

Seriously, I couldn't make that up. And this is the lead developer for the project.
Post #1569896
Posted Monday, May 12, 2014 12:01 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 7:48 AM
Points: 36,759, Visits: 31,214
BWFC (5/12/2014)
Jeff Moden (5/12/2014)
I've started a real pushback on all of this. It's amazing how many of the candidates (something like 22 out of 24) can't answer the first question, which is "using T-SQL, how do you select the current date and time"? If they can't answer that, the interview is over. It's a total waste of time if they can't get beyond that.


I've only been using T-SQL for just over twelve months and I'm largely self-taught as are the other members of the team. A question like 'how do you select the current date and time?' would actually make me a little nervous. I know how I'd do it:
Select GETDATE()
but I'd be worried about the sharp intake of breath and termination of the interview that may follow. I know I don't know the in depth stuff, and I'm constantly learning, but I wouldn't be at all surprised that the basics I thought I knew were wrong.



If you only had a year's worth of experience, I wouldn't be trying to hire you for a Senior position. The other thing is that I start the interview off by explaining to the candidate that I ask no trick questions and that the obvious answer is good enough. Although I'd love for a candidate to be able to actually explain he (s)he'd use Itzik's cascading CTE method to produce a table containing a single column of whole numbers from 1 to a million, I won't fault someone for correctly describing the way to do it with a While loop... that's just a matter of training that I can take care of after we hire someone. Just like the "GETDATE()" or "CURRENTTIMESTAMP" question, though, very few candidates have a clue as to how to do such a thing even with a While loop. It's terribly difficult for me to believe that someone claiming 5 to more than 10 years of experience can't do either.


--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1570010
Posted Tuesday, May 13, 2014 1:51 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Today @ 6:57 AM
Points: 611, Visits: 2,115
Gary Varga (5/12/2014)

Having seen the (terrible) level of knowledge that developers who think that they are experts in SQL Server have as well, I am little surprised at Jeff's frustration. It appears that the level to satisfy "just enough know-how" is far lower than it should be across the board. This must not be deemed acceptable so that we can raise the bar(s).
.


Having experienced it myself, I will say one of the things with SQL Server and database work in general is that you actual have to increase your knowledge past a certain point before you even grasp how much you don't know.

As a result, a lot of those "just enough" people don't even realize how limited their knowledge is.

As an example, my abilities in SQL server are light years ahead of where I was a few years ago. But despite all that progress, I also have way more on my "to learn" list now than then. Because on many topics, I knew so little that I wasn't even aware of what the holes in my knowledge were, much less how deep those holes were.
Post #1570530
Posted Tuesday, May 13, 2014 1:54 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:54 AM
Points: 5,189, Visits: 2,808
Nevyn (5/13/2014)
Gary Varga (5/12/2014)

Having seen the (terrible) level of knowledge that developers who think that they are experts in SQL Server have as well, I am little surprised at Jeff's frustration. It appears that the level to satisfy "just enough know-how" is far lower than it should be across the board. This must not be deemed acceptable so that we can raise the bar(s).
.


Having experienced it myself, I will say one of the things with SQL Server and database work in general is that you actual have to increase your knowledge past a certain point before you even grasp how much you don't know.

As a result, a lot of those "just enough" people don't even realize how limited their knowledge is.

As an example, my abilities in SQL server are light years ahead of where I was a few years ago. But despite all that progress, I also have way more on my "to learn" list now than then. Because on many topics, I knew so little that I wasn't even aware of what the holes in my knowledge were, much less how deep those holes were.


Me too.


Gaz

-- Stop your grinnin' and drop your linen...they're everywhere!!!
Post #1570533
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse