I just ran into the same thing, trying to create a lookup in a legacy dts package running on sql2005.

Anyone have any luck with this?

Nice post.

While we haven't called it "the Scud" test, our business requires the scary 99.999% uptime. As a result we're clustered in one datacenter, log shipping to a second cluster at...

LOL... too late! That's ok, rebuild time was just 19 minutes. I told Customer Service to go to lunch

And... pages are down to...

I'll give that a try. Thanks.

Holy cow! Right twice in the same thread!

/breaks out the celebratory Sobe.

The "Go" does the same thing for me. It executes the line ahead, releases resources, and then runs again. As mentioned, I did not see any significant lag as a...

True. When you're dealing with something that size, you need to spend quite a bit more time researching than a quick post to a messageboard.

Pre-production planning is crucial for something...

Eek! I was right?

Someone write this down!

(for the record, I prefer EXISTS or NOT EXISTS to IN or NOT IN when referring to a table simply because it seems to...

Clustering does not improve data performance, though, I thought. I was under the impression it's a logical choice for high-availabilty, not necessarily performance tuning.

If you've got 400 Gig, then you're...

Then Steve Ballmer will come to your house and spank you!

(Microsoft likes Identity columns. I don't know why

In my experience, if a query in QA runs slow on one box, but not the other, it's a RAM issue. The box with the most RAM wins, hands down...

Try this:

SELECT t1.InvoiceID, t1.VendorNumber, t1.VendorSiteCode,

FROM tblInvoices as t1

INNER JOIN tblSuppliers as t2

ON t1.VendorNumber = t2.[Vendor Number]

AND t1.VendorSiteCode = t2.[Vendor Site Code]

WHERE t2.[Supplier Inactive Date] IS NULL AND

NOT EXISTS

(select...

Doh!

With Ties.

/wonders why I forgot that.

Good catch D.