How about posting your cursor? That would be a big help. Also, the DDL for the tables involved and some sample data would be great. Follow the...

MTY-1082557 (11/6/2009)

---

Im attaching a file where you can see the partitionId of the Join. It uses the Clustered Index. I actually tried using another index that is partitioned as well...

Maybe we can ask why you want to know? Has someone asked to you 'de-normaize for performance'? As previousouly stated by other posters, the idea that working within...

First off, sorry for the delayed response. I've had a real busy couple of days. It looks like you've got it all set up though! Good job....

Yea, you're right Phil. Thanks for helping me save grace.

Sorry Tim, I guess I misunderstood 'bin' the script component.

Good to hear that you're up and running Tim. I agree, it's simple when you know how, but I'm not sure I'd call using a script task for this...

The only index on the table is the clustered index. I would not drop the clustered index on a table w/ 4 billion records just to see what happens....

Wow, that's a bit more serious than I thought. I initially assumed this was a general security question. Gus has some great advice, cover your butt. In...

UPDATE dbo.tblUsers

SET GroupId = CASE GroupID WHEN '7' THEN '98' ELSE '99' END

WHERE UsrSName = 'shortname'

Why would someone at a Director level need to see database properties for? What are they hoping to get from it?

Personally, I'd say no. You can maybe create...

daniell-1020276 (11/5/2009)

---

I tried to get an execution plan for the problematic query.

However, once the "IP" field is mentioned in the query I can not get an execution plan for the...

Is there a reason you used a script component for this? Why not just use an OLE DB Source that calls your SP?

Yes, you can pass XML...

I'll agree with Al-279884 and add that a compare of the execution plans between the 2 queries may shed some light on the subject.

If you have a development environment that you could play around in, this may be worth setting up a Profiler trace to see what the app is doing. If...

OK, I'll walk through what I'd do and I'll try to answer your questions as I go.

1. Create partitioning scheme/function for your production table. Weekly partitions may be a...