Viewing 15 posts - 1,276 through 1,290 (of 3,232 total)
Is this import the only way data is getting inserted into your DB? How long does it take to import your 400,000 rows?
July 28, 2009 at 1:28 pm
A couple questions for you:
1. Does your table have a clustered index on it? If so, what column/datatype?
2. Why load the data twice, once into a staging table, once...
July 28, 2009 at 1:04 pm
How do you know the loop is looping w/o doing anything? How can you be sure it is not just stuck in one spot waiting on something? Have...
July 28, 2009 at 10:06 am
Query 1 is using an equality comparison which does not allow for the wildcard characater %. Query 2 is eliminating those rows because of the LIKE comparison operator. ...
July 24, 2009 at 10:27 am
Just so you know, it looks like your post got cut off mid-sentence.
July 24, 2009 at 9:33 am
Jeff Moden (7/22/2009)
Heh... and now we know why I don't even bother with SSIS (or DTS). THAT's supposed to be easier and faster than a nice little ol' BULK...
July 23, 2009 at 9:34 am
I agree with the others in that it may be difficult in a shop that small. I also agree with George in that the DBA to developer roles/responsibilities must...
July 22, 2009 at 4:58 pm
I've not used the FTP task, but you may consider setting up your FTPs to be run by an Exectue Process task. The Execute Process Task allows you to...
July 22, 2009 at 4:50 pm
Ah, so you only do the comparison if the row already exists? Is this the correct logical flow:
1. Check for Existance of row
2. If not exist, insert.
3. If exist,...
July 22, 2009 at 2:33 pm
I'm not sure if it would be displayed anywhere when used via a maintenance plan. Maybe if your plan is set up to log the results to a file,...
July 22, 2009 at 2:21 pm
Keep in mind that the data and log file physical path/names are stored in the backup header so you need to make sure your restore is moving the files to...
July 22, 2009 at 2:08 pm
Like Gail said, look up ALTER TABLE in BOL. You don't need to use the Script as Alter feature if you know how to write an ALTER TABLE statement.
July 22, 2009 at 2:04 pm
Where is the backup from, another server? How are you doing the restore, SSMS or script? What are you trying to do, restore a Production DB, create a...
July 22, 2009 at 1:43 pm
FredS (7/22/2009)
I have only a...
July 22, 2009 at 1:39 pm
Viewing 15 posts - 1,276 through 1,290 (of 3,232 total)