It really depends on too many factors for me to comment. What service pack do you have installed? I had a lot of problems with the Tuning Advisor until I...

Jack Corbett (8/24/2009)

---

Ah, that's a good one. I think the issue with that one is due to language. I think...

That's no moon. It's a space station.

So, to get the number of rows you'd just modify the query to do a count

SELECT COUNT(*)

FROM table

WHERE col = '2'

It's just a straight aggregate function. If you...

The data I initially tested with was distributed about the same as yours. I was using AdventureWorks.SalesOrderDetail & the ProductID. 870 has 4,688 rows & 897 has 2 rows. But...

TheSQLGuru (8/21/2009)

---

Just to make clear, it isn't JUST about the number of rows you put into a table variable/temp table that matters. I can also be the actual VALUE(s)...

TheSQLGuru (8/21/2009)

---

Just to make clear, it isn't JUST about the number of rows you put into a table variable/temp table that matters. I can also be the actual VALUE(s)...

Any time you see radical differences in performance, you need to identify the differences. Are you passing different parameters? Are you testing it on a different server or with different...

jcrawf02 (8/21/2009)

---

Grant Fritchey (8/21/2009)

---

Alvin Ramard (8/21/2009)

---

GilaMonster (8/21/2009)

---

Alvin Ramard (8/21/2009)

---

I just registered for the 24 Hours of SQL Server. That's going to be a long 2 day period. Looks...

Alvin Ramard (8/21/2009)

---

GilaMonster (8/21/2009)

---

Alvin Ramard (8/21/2009)

---

I just registered for the 24 Hours of SQL Server. That's going to be a long 2 day period. Looks like it should...

RBarryYoung (8/21/2009)

---

Lynn Pettis (8/19/2009)

---

Don't you just love these? Of course when it starts, they don't bother to provide data that is represetative of the problem they are trying to...

Oh, sure. Shoving bamboo shoots under my finger nails is starting to get...

What you have are what are referred to as correlated sub-queries. As a general concept, they're not bad or dangerous, but when over-applied, and I think you're there, they become...

Alvin Ramard (8/20/2009)

---

Time for an Off Topic item:

Can anyone suggest a user group website that would be a great example of what a great user group website should look like?...

Are both systems structurally identical? Do both systems have exactly the same data in them? Do both systems have the indexes defragged and the statistics updated in exactly the same...