Viewing 15 posts - 5,446 through 5,460 (of 7,187 total)
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
This appears to be the special case where your interval is a multiple of 10. You can resolve this by changing your outer join into an inner join and...
April 4, 2011 at 4:44 am
OK, what you're looking for is a function to split a comma-separated list into its individual components. You should be able to find one by searching this site for...
April 4, 2011 at 2:02 am
I've got absolutely no idea what you mean. Please will you supply table DDL in the form of CREATE TABLE statements, sample data in the form of INSERT statements,...
April 1, 2011 at 7:53 am
You seem to have mangled my original code a little by changing number to NUM and removing the [font="Courier New"]AND name IS NULL[/font] line! I assume you used your...
April 1, 2011 at 7:21 am
Viewing 15 posts - 5,446 through 5,460 (of 7,187 total)