Viewing 15 posts - 5,446 through 5,460 (of 7,191 total)
Naru
No, do not have tables with different structures processed by the same data flow. Please post your code - I'm finding it very difficult to visualise.
John
April 6, 2011 at 1:57 am
OK, I found a table with only one index, which is non-clustered. The table has 400000 rows and the fragmenation of the index was 57.9%. I rebuilt the...
April 5, 2011 at 9:59 am
Naru
You need to make sure that the collection for each loop only contains the files you want to be processed by the dataflow within that loop. One way to...
April 5, 2011 at 8:24 am
CirquedeSQLeil (4/5/2011)
You can rebuild the NC but fragmentation will persist. A clustered index is required to defrag the NCs.
Jason, I must confess I don't understand. What's the difference...
April 5, 2011 at 8:19 am
As I said before, you shouldn't get too many problems if you only do inserts, although I can't guarantee that. One problem you will have is that your database...
April 5, 2011 at 8:02 am
If you've set up your loops correctly, it will load each text file for the same table one by one. As I said before, I can't tell you what's...
April 5, 2011 at 7:52 am
April 5, 2011 at 7:49 am
CirquedeSQLeil (4/5/2011)
a non-clustered index cannot be defragged without the presence of a clustered index.
Jason, are you sure about this? My understanding is that you can rebuild the non clustered...
April 5, 2011 at 7:45 am
Maybe fragmentation isn't the right word - I don't know. What I'm referring to are the empty spaces left on the data pages after page splits occur. Over...
April 5, 2011 at 7:23 am
Conditional split is not necessary. You just need to make sure your loop is configured so that after it has processed one file, it moves on to the next,...
April 5, 2011 at 7:18 am
natarshia.peck (4/5/2011)
i've done some research in BOL and other websites, but no where can I find an answer to my question. I have a table that i use to archive...
April 5, 2011 at 7:14 am
Narendra-274001 (4/5/2011)
Please suggest. DO i need to go for precendence constraint OR 3 for loops and 3 data tasks for 3 different flat files.
All three of those will...
April 5, 2011 at 6:51 am
John
Those are valid startup options in SQL Server 2008 R2. You should be able to start SQL Server again using those options and then attach msdb. Do you...
April 4, 2011 at 8:27 am
Sounds like you've got two instances on your server. Go on to the server and run SQL Server Configuration Manager. This will list all the instances that are...
April 4, 2011 at 8:16 am
For even row numbers (starting from 0), this adds 0, 10, 20... to @IDFrom, and for odd numbers, it adds 1, 11, 21... So yes, if you wanted to...
April 4, 2011 at 7:36 am
Viewing 15 posts - 5,446 through 5,460 (of 7,191 total)