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 «««45678»»

How do you spell S-Q-L? Expand / Collapse
Author
Message
Posted Friday, August 19, 2005 6:58 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, July 9, 2014 9:37 AM
Points: 2,553, Visits: 567
I just reread the article to start off my morning with a few laughs and I was wondering about this...

Q: What is the model DB?

A: It isn’t used at all. I usually delete it.


...I didn't know this was even doable...?!?!








**ASCII stupid question, get a stupid ANSI !!!**
Post #212046
Posted Friday, August 19, 2005 7:41 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 3:07 AM
Points: 1,060, Visits: 876

I mean, let's face it: These kinds of questions are sensationalist. Most people who get into an interview situation ARE ABSOLUTELY QUALIFIED FOR THE JOB. Period. No one would waste their time interviewing unqualified candidates. By the time they get into the interview room, the only question is whether they have the right personality to mesh well with the team.

 

I cannot disagree enough.  So many people have 6years SQL on their cv... turns out they have written a small sql select * once every couple of years.  Sure maybe they are there just to make the other candidate look good, but...




Post #212078
Posted Monday, September 19, 2005 12:39 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, February 9, 2006 11:54 AM
Points: 2, Visits: 1

I went into books online for SQL Server 2000. Entered a search of the Entire Collection for SEM. No hits. How can this be? So I tried EM which I have seen as a more common acronymn and found that it means "Expectation-Maximization". Ok, the point is this one got too carried away.

However, if you have someone who is a senior DBA they should know at least Clustered Index, Fill Factor, SP_LOCK, etc. Anyone who does not know these items should not be doing more than...oh, I don't know what they can do as a DBA. Backups?

Still, be sure that you are educating people...not calling them idiots (unless your name is Joe Celko). All you are going to do is alienate yourself and your opinion will be lost.

Cheers,

Ben

Post #221272
Posted Sunday, December 4, 2005 2:56 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Sunday, December 14, 2008 4:19 PM
Points: 89, Visits: 4

Firstly, I am a web developer who has inherited the job of also administering the SQL Server instance and (Physical) server.

I know, pretty well SQL, but pretty much next to nill with regards to administering a database.

I can create a database, tables, index, triggers, maintenance plans etc, good ol' point and click Microsoft and the EM are your best friends in this regard... but I certainly don't pretend for a minute to full understand what is going on... I just know to get results X,Y and Z and I need to do these three things in this window (or that one...) of the EM.

So for the purposes of education, my only question is, what are the answers to your questions? I probably only know the answer to about 40% of them. I am more than happy to look for the answers too, but simply keying in what I think are the keywords into the BOM search isn't going to guarantee that I end up reading about what's related to your questions.





Gavin Baumanis

Smith and Wesson. The original point and click device.
Post #241807
Posted Monday, December 5, 2005 2:35 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, August 22, 2006 5:08 AM
Points: 26, Visits: 1
You know, I've come to the conclusion over the past cpl weeks of interviewing candidates, that asking 'how would you rate your SQL Server skills, out of 10?' gives a wonderful, almost INVERSE indicator of the actual skill of the respondant.

Anyone claiming to be a 8 or 9/10 clearly hasn't yet understood all the intricacies and massive body-of-knowledge SQL Server hides from lay-users. Somebody claiming to be a 'maybe a 6 or a 7...there's a lot in there...' is more promising as at least they know there's so much still to learn/lookup.

Below a 5 just shows a supreme lack of confidence again, so they're back with the 8's and 9's in the 'no hire' pile if SQL Proficiency is required for a role.

Next time you're hiring, try asking this question, see if our results are similar?



Post #241845
Posted Friday, August 18, 2006 7:25 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, January 31, 2008 8:36 AM
Points: 1, Visits: 3
good christmas... i have been a SQL DBA for all of three weeks now and knew the answer to most of the questions.

god save the queen
Post #302582
Posted Friday, August 18, 2006 7:56 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, February 19, 2013 8:33 AM
Points: 162, Visits: 362

Hilarious/Scary! But what a boost for my self confidence!

As a Norwegian, I was thrown a bit off by the references to lotion, Kleenex and Spotlight, though.  




Post #302588
Posted Friday, August 18, 2006 9:23 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, September 8, 2008 9:01 PM
Points: 3, Visits: 4

You are right the hiring managers can be idiots.  This story reminded me of an interview I took just after graduating from college.  I was asked a question by 1 member of the group interviewing me, I answered it and then the "manager" asked me the same damn question only worded different.  I paused for a moment and looked around at the group and didn't see any reaction in anybodys faces so I proceeded to answer the question again.  I got the job but after 3 1/2 years I couldn't stand working for a manager who knew all the buzz words, but nothing else.

I've been on the other end too though, and have been asked a question about something I knew but it just wouldn't come out at that moment.

 




Post #302640
Posted Friday, August 18, 2006 1:25 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, July 17, 2014 2:15 PM
Points: 1,791, Visits: 594

I've only been working with SQL for a little over a year and I knew half of the answers. I'm also my company's network admin and help desk for about 200 users so I don't get to spend much time doing DBA work.

Sometimes when you hire you just don't get what you pay for.

And remember...it's all about the data!

 

Post #302709
Posted Monday, August 21, 2006 7:29 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 3:40 PM
Points: 804, Visits: 1,990

This is a very interesting thread, but I don't see the relevance of some of the questions, like:

How much memory does SQL use on startup?

I've never had to share an SQL Server with something else, and I rarely start them up.  On the other hand, I'm very interested to know what someone thinks of NULLS, referential integrity, where should business rules be stored, mud tables, when to use cursors, when to use views, and so on.  These questions may not always have a right answer (though some I think do) but they will go a long way to determine fit in the organization.

I did once, however, had a interviewee who told me he had a lot of experience with SQL triggers.  When I asked him to describe one of his triggers and what it did, he said that he wrote a program that, when the button was pressed, "triggered" the database to do something. 




Post #302859
« Prev Topic | Next Topic »

Add to briefcase «««45678»»

Permissions Expand / Collapse