Viewing 15 posts - 901 through 915 (of 3,232 total)
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...
November 9, 2009 at 11:12 am
MTY-1082557 (11/6/2009)
November 6, 2009 at 3:43 pm
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...
November 6, 2009 at 1:57 pm
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....
November 6, 2009 at 1:47 pm
Yea, you're right Phil. Thanks for helping me save grace.
Sorry Tim, I guess I misunderstood 'bin' the script component.
November 6, 2009 at 1:12 pm
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...
November 6, 2009 at 10:51 am
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....
November 6, 2009 at 10:45 am
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...
November 6, 2009 at 9:59 am
UPDATE dbo.tblUsers
SET GroupId = CASE GroupID WHEN '7' THEN '98' ELSE '99' END
WHERE UsrSName = 'shortname'
November 5, 2009 at 2:27 pm
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...
November 5, 2009 at 12:17 pm
daniell-1020276 (11/5/2009)
However, once the "IP" field is mentioned in the query I can not get an execution plan for the...
November 5, 2009 at 10:31 am
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...
November 5, 2009 at 10:29 am
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.
November 5, 2009 at 10:13 am
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...
November 5, 2009 at 9:52 am
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...
November 4, 2009 at 4:32 pm
Viewing 15 posts - 901 through 915 (of 3,232 total)