http://blogs.technet.com/wardpond/archive/2008/09/24/database-programming-sharing-a-temp-table-among-processes.aspxOne of the great things about my involvement with the SQL Ranger community is that I occasionally hear from past Candidates asking for help with issues in the field. So it was earlier this week when Binh Cao, an MCS Senior Consultant II based in San Diego,en-USCommunityServer 2.1 SP1 (Build: 61025.2)http://blogs.technet.com/wardpond/archive/2008/09/24/database-programming-sharing-a-temp-table-among-processes.aspx#3128310Thu, 25 Sep 2008 20:08:25 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3128310Gerard Tan-Torres<p>Hello Ward,</p> <p> &nbsp;Yes, Binh was a great help to us and thank you for supporting him when I posed him this question. &nbsp;My research confirms that global temp table does allow the plan to be shared among processes. &nbsp;However now we are forced to deal with the problem of ownership of data within the global temp table. &nbsp;I really don't know if it's worth the effort to add some sort of session id field. &nbsp;We'll need to do more testing and subject it to our load test scenarios.</p> <p>Thanks again for your help &quot;professor&quot;.</p> <p>-gt</p>http://blogs.technet.com/wardpond/archive/2008/09/24/database-programming-sharing-a-temp-table-among-processes.aspx#3128494Fri, 26 Sep 2008 01:03:10 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3128494Ward Pond's SQL Server blog<p>Binh Cao's customer left a comment on yesterday's post on global temp tables. Here's the money quote:</p>