j.bradshaw (8/24/2009)

---

This is all a bit scary to me. I was handed Grant's article by one of our DBA's and asked to get this working. :w00t:

Well, I have several beginner's...

I'd suggest the Red Gate Tool Belt for SQL Server. Great stuff, Data compare, SQL compare, SQL Prompt...

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...