Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Plans Expand / Collapse
Author
Message
Posted Friday, May 20, 2011 1:52 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, March 20, 2014 7:32 AM
Points: 5,191, Visits: 1,368
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?


Post #1112203
Posted Friday, May 20, 2011 8:58 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 11:24 AM
Points: 32,781, Visits: 14,942
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.






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1112471
Posted Friday, May 20, 2011 11:19 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, April 17, 2014 3:16 PM
Points: 5,986, Visits: 6,931
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 | Forum Netiquette
For index/tuning help, follow these directions. |Tally Tables

Twitter: @AnyWayDBA
Post #1112587
Posted Monday, May 23, 2011 5:23 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, March 27, 2014 8:50 AM
Points: 2,163, Visits: 2,184
Thanks for the question!
Post #1113704
Posted Tuesday, May 24, 2011 8:43 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 10:36 AM
Points: 896, Visits: 1,479
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
Post #1114087
Posted Tuesday, May 24, 2011 8:54 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 11:24 AM
Points: 32,781, Visits: 14,942
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.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1114100
Posted Sunday, June 26, 2011 12:57 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:04 PM
Points: 11,168, Visits: 10,933
Hesitated over this one. Compiled plans are re-entrant, but the execution contexts derived from them are not. By 'query plan' I guessed the author of the question was referring to the former, and was rewarded with a point.



Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #1131738
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse