GSquared (9/27/2011)

---

Looks like The Thread may have killed the rest of the forums.

The Active Threads link is only showing 5 other discussions.

(Probably my fault for going political in here. ...

I see you are new around here. Welcome. We usually like to see some ddl and sample data in a consumable format. Something to make things easy for us to...

There just is not enough information in your post to begin to be able to help with optimizing this. I assume you want to optimize it because it is running...

calvo (9/27/2011)

---

hehe

quick, change the subject!

...

.....

Using singular table names is a Microsoft...

Stefan Krzywicki (9/27/2011)

---

Sean Lange (9/27/2011)

---

Stefan Krzywicki (9/27/2011)

---

Sean Lange (9/27/2011)

---

Stefan Krzywicki (9/27/2011)

---

Sean Lange (9/27/2011)

---

Stefan Krzywicki (9/27/2011)

---

Sean Lange (9/27/2011)

---

Stefan Krzywicki (9/27/2011)

---

Sean Lange (9/27/2011)

---

GSquared (9/27/2011)

---

It's a pretty fair bet...

Stefan Krzywicki (9/27/2011)

---

Sean Lange (9/27/2011)

---

Stefan Krzywicki (9/27/2011)

---

Sean Lange (9/27/2011)

---

Stefan Krzywicki (9/27/2011)

---

Sean Lange (9/27/2011)

---

Stefan Krzywicki (9/27/2011)

---

Sean Lange (9/27/2011)

---

GSquared (9/27/2011)

---

It's a pretty fair bet that some people would...

Ronald H (9/27/2011)

---

First I wouldn't use the old join type, but proper inner joins.

Second, I think it's rather strange that in the query itself as well in the group by,...

madhuu1905 (9/27/2011)

---

i want to find a personid in the customer table in experts Database

then using that personid find his subscriptions by joining to the following tables

customer, accounts, subscriptions, devices, devsublink?

Can...

You probably would not see any benefit from that, with the exception of the first user to access the system. Have you ever noticed that a web app takes a...

Stefan Krzywicki (9/27/2011)

---

Sean Lange (9/27/2011)

---

Stefan Krzywicki (9/27/2011)

---

Sean Lange (9/27/2011)

---

Stefan Krzywicki (9/27/2011)

---

Sean Lange (9/27/2011)

---

GSquared (9/27/2011)

---

It's a pretty fair bet that some people would assume I'm a pretty...

Stefan Krzywicki (9/27/2011)

---

GSquared (9/27/2011)

---

Stefan Krzywicki (9/27/2011)

---

Sean Lange (9/27/2011)

---

GSquared (9/27/2011)

---

It's a pretty fair bet that some people would assume I'm a pretty rabid conservative. On the...

gregory.anderson (9/27/2011)

---

I'm curious about how connection pooling actually works because I'm not sure if my application is using it to our benefit [or at all].

My web application is running on...

Stefan Krzywicki (9/27/2011)

---

Sean Lange (9/27/2011)

---

Stefan Krzywicki (9/27/2011)

---

Sean Lange (9/27/2011)

---

GSquared (9/27/2011)

---

It's a pretty fair bet that some people would assume I'm a pretty rabid conservative. On...

drew.allen (9/27/2011)

---

The only thing that I would suggest is that since AccumID is already character data, it doesn't make sense to (implicitly) convert it to an integer and then (explicitly)...

Stefan Krzywicki (9/27/2011)

---

Sean Lange (9/27/2011)

---

GSquared (9/27/2011)

---

It's a pretty fair bet that some people would assume I'm a pretty rabid conservative. On the other hand, there...