• subramaniam.chandrasekar - Thursday, December 14, 2017 5:12 AM

    Hi,
    that's right.
    While working with In memory tables in SQL Server 2014 or later, We can get this queries raised, But what I'd mentioned is the basic difference between row store and column store indexes in SQL. If some one has better answers, I'd like to note down.

    Besides, Can you please help me with flow chart of SSIS loading CSV file data to a fact table by coping dim table data.
    Your response will be helpful.

    To be brutally honest, these questions were asked by people that expect YOU to know the job they're trying to hire someone for.  They're not expecting US to know the answers for you because we're not the ones that are going to be interviewed for the position you're applying for nor are we the ones they're going to have to put up with if you somehow get the job but can't do it.  You need to hucker down and demonstrate that you know at least the first and most basic skill for any job in IT and that's how to search the web for information, find it, and then study it.  None of these questions are so difficult that you can't do that.

    The problem is that when you get to the interview, you won't be allowed to use the internet to answer the questions.  You need to look at the description of the job and anticipate the questions they will ask and then prepare to be able to talk at length about any of the subjects listed on the job description.

    If you can't do that, then your interview will be unsuccessful, or at least is should be if the interviewers are worth their salt.

    And asking people to answer your interview questions for you is a despicable act.

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