Post reply

Query architecture

  • November 24, 2009 at 12:40 pm

    #214056

    Hi All,

    If we run a query (it can be select, insert or update), what is the architecture for that query ?

    What happens at background ?

    Thanks And Regards!!

    Thank You.

    Regards,
    Raghavender Chavva

  • November 24, 2009 at 12:44 pm

    #1083629

    First, this question could require an extremely verbous answer. It would help if we could understand better what you are actually looking for from this question.

  • November 24, 2009 at 12:53 pm

    #1083636

    I have faced this question in an interview.

    let me explain it.....

    if we fire a query from QA or any other apllication against a database, first of all where it goes and what it does to give us output..

    internally what it will do ?

    Thank You.

    Regards,
    Raghavender Chavva

  • November 24, 2009 at 1:25 pm

    #1083657

    May I suggest that you try checking out BOL? It may cover this particular topic, I haven't checked myself as I have never been asked this question myself in an interview.

  • November 25, 2009 at 8:24 am

    #1084084

    Something like this it does.

    1.It parses the query...checks for the syntax/semantics...checks for existance of tables/views...permissions of users etc.

    2.Creates the execution plan, if none exists in the buffer, if exists uses the same.(Indexes/stats)

    3.Executes the query.

    4.Fetches the data from the buffer/disk etc

    5.Throws the ouput to the user.

    Hope this helps.

    Pavan.

  • November 25, 2009 at 8:29 am

    #1084090

    http://msdn.microsoft.com/en-us/library/cc280362.aspx

    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 6 posts - 1 through 5 (of 5 total)

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