Viewing 15 posts - 9,316 through 9,330 (of 9,725 total)
I don't know. I think the best way to secure the Server against everyone is to unplug the darn thing and lock it in a closet.
Of course...
November 13, 2007 at 4:05 am
I'm a little confused. Why are you upgrading DTS to SSIS if you're still using SQL Server 2000 and not upgrading your database to 2005? If you're not...
November 13, 2007 at 4:01 am
I disagree. Certification helped me get my current job.
Of course, my college degree had nothing to do with computers. Neither did my paid work experience, so...
November 13, 2007 at 3:52 am
What tool are you using? The DTS Import / Export Wizard or SSIS? From which Server are you initiating the move, 2000 or 2005?
November 12, 2007 at 12:14 pm
Jason,
I'm so glad you figured it out. I was at a loss myself.
Was this particular DB an upgraded one or a fresh install? If upgraded, probably...
November 9, 2007 at 11:06 am
Joel,
I honestly didn't check. I just ran a normal tuning Profiler trace against our production DB during business hours and then ran the DTA against that. I wasn't...
November 9, 2007 at 11:05 am
Mark,
I suggest you try it both ways and run Profiler on both runs. That will tell you right there which is the faster and better one for your specific...
November 9, 2007 at 8:34 am
Has anyone ever encountered the problem I've described in the post above? Any information on DTA would be greatly appreciated.
I don't even know why it didn't install properly in...
November 9, 2007 at 8:23 am
I agree that the variable is better and faster, but I wanted to put an alternate suggestion out there just in case.
November 9, 2007 at 7:57 am
Or, if you have to sum the entirity of Col1 first, then create a second Temp table with a column that is the sum of the entirity of Col1 and...
November 9, 2007 at 6:23 am
Have you tried adding a calculated column to your temp table?
Alter Table #MyTemp
Add MyCalcCol AS (Col1 * Col2)
Or something like that. Where the "datatype" isn't actually a...
November 9, 2007 at 6:22 am
I don't know if there is such a thing as a SQL Only person anymore. Especially with MS putting out SQL Server editions that require VB .Net and C#...
November 9, 2007 at 6:19 am
I'm still not making much progress myself. What's the Schema_ID and principal_ID of the proc in sys.objects? Also, have you tried scripting out the server & database configs...
November 9, 2007 at 3:54 am
Jason,
This is going to sound odd, but ... Have you checked your permissions (and inherited permissions, like group memberships) on this server? Verify schema defaults and see if there...
November 8, 2007 at 8:39 am
I don't know, but it doesn't hurt to check and see if there is a difference. @=)
I'm going to do some playing around and see if I can replicate what's...
November 8, 2007 at 8:02 am
Viewing 15 posts - 9,316 through 9,330 (of 9,725 total)