SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


How do you spell S-Q-L?


How do you spell S-Q-L?

Author
Message
sushila
sushila
Hall of Fame
Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)

Group: General Forum Members
Points: 3569 Visits: 639
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 !!!**
RichB
RichB
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1583 Visits: 1058

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...





Benjamin S Taylor-194434
Benjamin S Taylor-194434
Forum Newbie
Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)

Group: General Forum Members
Points: 8 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


GavinB
GavinB
SSC-Enthusiastic
SSC-Enthusiastic (113 reputation)SSC-Enthusiastic (113 reputation)SSC-Enthusiastic (113 reputation)SSC-Enthusiastic (113 reputation)SSC-Enthusiastic (113 reputation)SSC-Enthusiastic (113 reputation)SSC-Enthusiastic (113 reputation)SSC-Enthusiastic (113 reputation)

Group: General Forum Members
Points: 113 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.
sqluser@sqluser.com
sqluser@sqluser.com
SSC Rookie
SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)

Group: General Forum Members
Points: 32 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?



Brandt Edwin
Brandt Edwin
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
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
leifah
leifah
SSC-Enthusiastic
SSC-Enthusiastic (186 reputation)SSC-Enthusiastic (186 reputation)SSC-Enthusiastic (186 reputation)SSC-Enthusiastic (186 reputation)SSC-Enthusiastic (186 reputation)SSC-Enthusiastic (186 reputation)SSC-Enthusiastic (186 reputation)SSC-Enthusiastic (186 reputation)

Group: General Forum Members
Points: 186 Visits: 366

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. :-)





swschmid
swschmid
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
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.





Dave Schutz
Dave Schutz
SSCrazy
SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)

Group: General Forum Members
Points: 2060 Visits: 609

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!


RonKyle
RonKyle
SSCrazy
SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)

Group: General Forum Members
Points: 2768 Visits: 3501

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.





Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search