Post reply

Interview Tips

  • February 28, 2008 at 10:33 am

    #120314

    Hello Peers,

    I would appreciate if you all can contribute to this request which not only helps me in improving but also understand them in detail.

    I'll be having an interview tomorrow and I would like to get some hot tips on the following topics:

    1. Performance Tuning

    2. Advanced database design

    3. RAID

    4. Clustering

    5. Advanced query design

    6. Load balancing supporting a high transaction site with million + hits per day

    I'm having intermediate knowledge on the above and would like to have technical words which can be plus points.

    Thanks in advance.


    Lucky

  • February 28, 2008 at 9:24 pm

    #783589

    Ummmm.... you waited until the night before an interview to cram-for-the-exam?

    Good luck... 😉

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

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • February 28, 2008 at 9:53 pm

    #783596

    You don't want to give false impressions that you "know" all about these things and then annoy your (potentially) new employer when you don't actually know much about them.... But of course you already know that :hehe: I suppose it's typical in the IT industry 🙁

    Anyhow, no one here is going to type a lot of meaningful text to give you all the words you'd want to use, and if you don't understand the technologies, you'll probably not explain it correctly anyway. I would suggest that you go looking for articles on this site using some of the terms you just listed. You could also go look at the Microsoft site for the articles about SQL Server features such as database mirroring, etc

  • February 28, 2008 at 10:36 pm

    #783604

    lucky (2/28/2008)

    I'll be having an interview tomorrow and I would like to get some hot tips

    Sure.

    Be honest about your level of knowledge. Any competant interviewer can tell knowledge from 'keyword dropping for extra points' in 10 sec flat

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 4 posts - 1 through 3 (of 3 total)

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