Viewing 15 posts - 39,136 through 39,150 (of 39,510 total)
I agree with Paul for inserts.
Personally, for update/insert items, I import using DTS or BCP into a staging table and then update the "live" table by joining to the staging...
November 1, 2001 at 10:14 am
Correct, 2 people to qualify as a MS Solution Provider. They just need to be MCP's, not MCSE or MCDBA.
Steve Jones
November 1, 2001 at 10:12 am
Paul, thanks for the recommendation. BTW, did you like the 2000 book? (I co-authored it).
marmentrout - Desgin exams - I found that the 2000 exam eas easier than the v7...
November 1, 2001 at 10:11 am
Why worry when the databases appear? Maybe just scan for "new" databases and run the backups? Or just schedule the backups for a short period of time after they will...
November 1, 2001 at 10:07 am
I discovered if you uncheck he "7.0 forma" button on the options tab, the source fields are accessable in the transformations tab.
Steve Jones
November 1, 2001 at 10:04 am
yes. the -E will make a trusted connection. If the user installing the program has not been setup in SQL Server, it will fail.
Steve Jones
October 31, 2001 at 5:07 pm
I agree with Andy. I think that this does have a place in meeting business rules or needs. There are times where I would like to allow someone to bulk...
October 31, 2001 at 11:01 am
October 31, 2001 at 10:56 am
If you create the clustered key using the new
filegroup, the data will move. You can then drop the clustered key if you want (not recommended.
Steve Jones
October 31, 2001 at 10:40 am
October 31, 2001 at 10:37 am
This seems like a lot of work. What are these procedures doing? Perhaps we can suggest an easier solution.
Steve Jones
October 31, 2001 at 10:32 am
The other alternative is to import the data into SQL Server into a second table. Then
update the first table from the second table where rows match.
...
October 31, 2001 at 10:31 am
Thanks for the followup and sorry we could not help.
I think in this case you may want to make a permanent table for storing this data. You could prevent collisions...
October 31, 2001 at 10:29 am
Andy and I have a great article coming out on this, but basically, I feel we should view a cerification like a college degree. It is a base level, not...
October 31, 2001 at 10:28 am
I agree. If you are a SQL DBA without Inside SQL Server, you are missing a great resource.
Steve Jones
October 30, 2001 at 8:49 pm
Viewing 15 posts - 39,136 through 39,150 (of 39,510 total)