Plans

  • Comments posted to this topic are about the item Plans

  • Thanks for the question 🙂

    M&M

  • Thanks for the 2 easy points! 🙂

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Good question,

    Thanks

  • I had to look up what re-entrant meant...

  • Nice easy and clearly defined two point question! :w00t:

    Thanks Steve!

    Guess we won't have hundreds of posts arguing the validity of the answer, the sanity of the behavior, or anything else today. :doze:

    I'm going to miss that and STUFF... 😎

  • thanks for the question.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Another nice straightforward one.

    Two points seems a lot for this one, though.

    Tom

  • Good question..

  • I just googled to see whether this question has any inner (hidden) meaning. As the question was from Steve, I thought it would not be as easy as it is showing?

  • LOL, I don't always try to make the questions hard. I typically write 5-10 at once, so I balance them out as easy and hard.

  • LOL, I should have looked up what re-entrant meant before answering. Oops. 🙂 That'll learn me.

    I wasn't thinking in terms of multiple connections, but the same connection re-entering its own query plan. Oopsies. 😀


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • Thanks for the question!

  • Thanks for the question.

    Now could anyone point to an article explaining what re-entrant means?

    Best regards,

    Best regards,

    Andre Guerreiro Neto

    Database Analyst
    http://www.softplan.com.br
    MCITPx1/MCTSx2/MCSE/MCSA

  • http://en.wikipedia.org/wiki/Reentrant_%28computing%29

    It means the same section of code can be executing from one user (or process) and a second user can then use that same code again and start executing it at that same time. It promotes some scalability, since you need less resources for that section of code.

    If it's not re-entrant, then a second copy of the code must be created and resources assigned for the second user to execute it.

Viewing 15 posts - 1 through 15 (of 16 total)

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