What is SQL Server architecture ?

  • Hi All,

    I have 1 Year of experience in sql server.

    Suppose when i go for interview, Many interviewer asking one question regarding the SQL Server architecture.

    "What is SQL Server architecture ? "

    I have search on google but i didn't get any good link, pdf, ppt (exact).

    Actually i am not able to find.

    So please, Can any one help regarding this subject.

    Regards,

    Sachin.:-)

  • That's a huge question and it begs clarification. At a very high level SQL Server architecture can refer to knowing the differences between the relational storage engine, reporting services, integration services and analysis services. After that, it's getting into SQL Server internals. I'd want a clarification for what they're looking for before I opened my mouth.

    "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

  • I recently spent many months interviewing and never ran across that question. partially because it's pretty vague!

    You are better off acquainting yourself with what SQL does and if such a question pops up, show them what you know by first asking a question right back to clarify what they are asking!

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

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