BI is the hardest because of the all-around knowledge to be useful in the work place. So dev.

In real life experience counts for a hell of a lot more than certs.

Show you can help someone and they'll hire you.

This is not sql server syntax.

If you're on 2K5, I think you have to do it in 2 steps (3)

Save results to temp table (optional)

Update based on inner join,

then insert...

@peter-2.

If you go the "send full db" way. Please make sure that the datafiles of the restored db are under 10GB. I'm on express so I can't restore...

JonFox (11/13/2011)

---

Hah, turns out I had seen the other post, but didn't make the mental connection to this one. Yep, that's a lot more complex than I initially realized from...

JonFox (11/13/2011)

---

Ninja's_RGR'us (11/13/2011)

---

P.S. 100K + prospect, millions of prospect campains.

That code never finished in a cursor and it probably won't this time either. (Yes I know you didn't...

P.S. 100K + prospect, millions of prospect campains.

That code never finished in a cursor and it probably won't this time either. (Yes I know you didn't know :hehe:).

JonFox (11/13/2011)

---

...which is why I'm interested in understanding more about why performance is...

What's I'd do here is make a coy of prod.

Drop all non-needed tables, even the asp.net ones. I<d drop all functions & sps as well.

Sanitize the sensitive information.

Then take...

I'm willing to give this a shot. But there's way too little data to get anything meaningfull performance wise.

I understand you need to sanitize the data (P.S. you might...

Thanks for the info I can't be guessing around here.

Please post the table create script including keys & indexes.

Bugs are usually super edge cases with a lot a special requirement...

traceon activate the trace flag.

1222 is the flag number

-1 means global to all connections. So when you do that EVERYBODY on the server is affected.

This is what...

Good, that leaves only a few 100 options on the table. How...

This might be a bug, I'll have to spend some time on it tomorrow.

What's that code supposed to do anyways? The query looks weird to me.

Can you post the view definition?