Viewing 15 posts - 39,076 through 39,090 (of 39,456 total)
Ab-so-lute-leeee agree. NO WAY should developers be working with product, except as read-only to look for data.
Steve Jones
November 1, 2001 at 12:11 pm
The design book is definitely me. I go by Steve Jones, but actually I am J(ohn) Steven, so some of the distributors got it wrong.
Steve Jones
November 1, 2001 at 12:09 pm
I ahven't tried this, but perhaps using the new table datatype in SQL 2000 would work?
Steve Jones
November 1, 2001 at 12:08 pm
Maybe its even a little "job security". Don't make too many notes, Paul! 🙂
Steve Jones
November 1, 2001 at 10:29 am
Raj: your welcome. Nicely written.
(and everyone): please do send suggestions to Andy (awarren@sqlservercentral.com) or myself (sjones@sqlservercentral.com). We are always looking for new topics. Let us know specifically if what you...
November 1, 2001 at 10:18 am
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
Viewing 15 posts - 39,076 through 39,090 (of 39,456 total)