Two more bits of empirical evidence in favor of having a degree, regardless of what area of study:

1) I've been told more than once that the fact that my masters...

I'm a developer/architect rather than a DBA but my bachelors and masters are both in geology & geochemistry. (I had been working toward a CS minor in college, but...

Yes, clearly - but I think you're still missing the significance of the issue.

Since the context is different, you would think it would *create its own connection pool*. ...

I actually figured out what was happening by the scientific method, it has nothing to do with Silverlight but does have to do with the service layer and the difference...

Interesting. That first link is actually not about SQL connections in WCF but basically creating a pool of connections TO the WCF service, more like a "proxy pool" than...

I'm sorry, but I really don't understand what you are trying to say. What do stored procedures have to do with it?

Since the connection pool is maintained on the...

Nope, no transactions in these queries - they are all reads only

I don't think there would be time yet for objects not to be disposed -this happens as soon as...

Two things -

Regarding staying current, I agree 100%. I have worked with many "dinosaurs" who call themselves technical but are wholly resistant to change and they are nothing...

Lynn, I started with yours but found I actually had to add the "group by" that Mark had in his since the Table1.ID wasn't part of any aggregate. I...

Thanks again, this idea worked perfectly and gave me ideas for sprucing up some other processes as well. I had used CTEs for paging but not for bulk updates,...

Visually it looks exactly like what I am trying to do, I will try it now.

Thanks!

Just posting a followup since I've resolved this - it turns out the problem was related to connection pool settings.

I'm not sure why bad connection pool settings from one app...

Well, this morning I did some more testing and this is what I found.

During the process the CPU on the server is stable at about 15% and drops to almost...

Hmm, I actually use machine name when running against our QA server and IP address on staging, but see the problem occurring in both cases.

Guys & gals, I think it's time to stop feeding the troll.

Clearly he is arguing himself into a corner because he can't admit that his original premise was based on...