Easiest way I know to do this is a dirty trick using FOR XML.

IF OBJECT_ID ( 'tempdb..#orders') is not null

drop table #orders

create table #orders(

oid int,

itemid int

)

insert into #orders (oid, itemid)

values...

It's a common method to workaround dealing with bad design methods when inherited. I would recommend you do it in smaller chunks, however, working with the design teams towards...

I've used temporary indexes both on temporary and permanent objects for a variety of reasons, but usually do to one off (like quarterly) processing that I don't want those 20-30...

A bit of narcissism drove this, but I hit a whaaaaa type of site.

This site takes another site and completely frames it in its own advertising and stuff.

http://news.comrite.com/en/newsposts/39235

That points to...

While not a bad idea, the primary...

Harry, go into the dataflow task and check what metadata type the column in question is. That will help us figure out where your issue might be hiding.

Not sure if it would speed you up, but an inline script component checking the field as it passes by and using two output streams depending on results found would...

Steve Jones - SSC Editor (4/28/2011)

---

Since I have the collective braintrust here, and you're posting technical stuff.

I posted a note about understanding your access patterns for data, meaning hitting tables...

Stefan Krzywicki (4/28/2011)

---

hillock666 (4/28/2011)

---

Hi.

I'm wondering about marking a computed column as persisted is useful when I'm using a query fully covered with an index.

I think that this haven't...

Thanks Igor, that'll help tremendously. There are a few ways to completely avoid aggregation methodology and using top 1 cross apply techniques as well... but they're uncommon, at best....

Vedran Kesegic (4/27/2011)

---

Third, never substract a second, milisecond, nanosecond, 2 ms or anything for such purposes. Substracting anything is innacurate and a very nasty BUG! For example, later you decide...

"You know Google? Okay, where you type in information, that's the front end. They make it pretty and give you a thousand options in a way you can...

I can take a swing at this if Tom is feeling time pressured, I've pretty much avoided the entire debate out of self defense. Did you want these spackle-style...

Igor check out the first link in my signature to show how to make your test data consumable.

Heh, whoops, sorry, I didn't address one of your issues. Most likely the reason going to dirty reads got you out of this problem is that certain ID's probably...