Viewing 15 posts - 31 through 45 (of 64 total)
I am determined to get fragmentation down, with some tables still over 70 % fragmented I need to do something, as stated previously the company is still fighting for some...
June 1, 2016 at 7:49 am
I got fragmentation stats after the Table rebuild and then after index rebuild. Still had a lot of fragmentation.
Ideally I would love to have Clustered indexes but it was already...
May 26, 2016 at 3:32 am
I did rebuild before this, but still there were tables with over 80% fragmentation
May 24, 2016 at 2:09 am
Douglas
This the script I use, works quite nicely. I did the table rebuilds this weekend at one of our clients and then did index rebuilds. My forwarded records are all...
May 23, 2016 at 1:18 am
Heap tables yes, basically all our indexes except for one is Non Clustered. This is part of the problem. I have inherited it like this
May 23, 2016 at 1:04 am
We found that fixing this brings fragmentation down by anything from 0-60 % after doing table rebuilds, after rebuilds we staill have fragmentation on tables and indexes. We are using...
May 23, 2016 at 1:02 am
The problem is that the Database is originally from an ETL from a Adabas database, so we have hundreds of tables being created, most of the child tables have a...
May 20, 2016 at 12:07 am
Looks like I missed something, is running on same server, the package was running to SQL server destination, which I have started moving away from
December 23, 2014 at 8:34 pm
I also get this error on SQL 2012, I am using OLEDB Destinations. I am trying to run 5 inserts at the same time, is the issue just pointing to...
December 23, 2014 at 3:57 am
I was advised previously that using SSIS for this was not really going to give me a performance boost compared to running a insert into with the case statements defined,...
November 19, 2014 at 4:55 am
Thanks will try that, still is strange that SQL Server destination complains but OLE Destination does not. I just read elsewhere that SQL Server destination may be dropped in future...
November 18, 2014 at 6:45 am
Hi
I have something very similar but there are nulls involved, not sure how this will affect the script.
The field want to use derived column is a field with say 12...
November 4, 2014 at 5:14 am
Thanks, makes sense what you say, I will though then keep the insert into in a SQL Task, as we are adding all the other tables via SSIS, the...
October 29, 2014 at 6:50 am
The issue with this really strange data is that I need to get a way to do a fast load of the data if this is going to be possible,...
October 29, 2014 at 6:21 am
I see you point but this data is weird and we do have substrings for example for 4,6 or 6,20, so some of the values may in fact be nulls
So...
October 29, 2014 at 6:14 am
Viewing 15 posts - 31 through 45 (of 64 total)