Post reply

SQL

  • March 21, 2016 at 8:47 pm

    #325998

    Not for sure where this should be posted please let me know where to post it at here on SQL ServerCentral but can anyone give some test question and sql query questions that they would ask someone that has come in for an interview.

  • March 21, 2016 at 9:56 pm

    #1866656

    Interviewing for what position?... DBA? SQL Developer? Data Architect? BI Consultant?

    What kind of interview?... Purely technical, e.g. "what's an index?" Strategic, e.g. "why would you create an index"?

    More details would help.

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

  • March 21, 2016 at 10:55 pm

    #1866660

    DBA or developer.

  • March 22, 2016 at 5:07 am

    #1866706

    This blog post [/url]has the one question I always ask and a link to the phone screening questions that weed out most people.

    I hate trivia questions: "Which traceflag do I set to enable the "Run Lightning Fast" switch in SQL Server 2008R2 SP3?" Wow. Stumped me. It's a darned shame when I start working for Company X I'll be removed from all access to the internet and therefor must rely on my memory for every obscure setting within the product.

    I want to know that people understand concepts. That they can walk me through RPO & RTO. That they've gotten the phone call in the blog post above and have a story to tell about it.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • March 22, 2016 at 9:37 am

    #1866841

    edward_hall76 (3/21/2016)

    DBA or developer.

    Hmm, overall vastly different qs, but if they are supposed to have experience, here's one q I love to ask ... but give them some time to do it, it's not as easy as it sounds!

    This table contains from 1 to 3 test results for each student:

    test_scores ( Student_Id int, Date_Taken datetime, Score decimal(4, 1) )

    Write a single query -- no subqueries, joins, etc. -- that lists a single row for each student with:

    student_id

    max test score

    mid test score

    min test score

    --If there's only one score, list it as max.

    --If there are only two scores, list them as max and min [or max and mid, whichever you prefer].

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

  • June 7, 2016 at 4:03 pm

    #1883749

    you can check interview questions on forums of winmilestone.com / http://www.winmilestone.com/Topic?Interview

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply