Viewing 15 posts - 39,601 through 39,615 (of 39,754 total)
My 2 cents:
Avoid Access.
It is intended as a low end, personal desktop database. While I have built lots of dBase/FoxPro/Access applications, they don't scale well and coruption is a...
September 15, 2001 at 10:34 am
I wouldn't call this ludicrous either. I, in general, hate cursors and temp tables, but they have value. While I wouldn't use this approach, it appears to work.
Personally, I'd burden...
September 15, 2001 at 10:20 am
I know it costs $$, but you can run SQL 2000 with a db in 6.5 compatability. Might provide some reasons to upgrade. The query performance will only increase.
Steve Jones
September 14, 2001 at 4:18 pm
September 13, 2001 at 9:26 am
I'd be wary to removing any "system" like tables. HAve you noticed any issues? Do they get recreated with a new diagram?
Steve Jones
September 13, 2001 at 9:24 am
I had, but I use the same job on multiple servers and use the Dynamic Variable Settings to get some information for the package. This way I can also do...
September 13, 2001 at 9:22 am
September 13, 2001 at 9:17 am
Try saving the package with a password. This alleviates many problems.
Be sure you have not used any SQL 2K specific tasks. A number of new tasks are only supported on...
September 13, 2001 at 9:15 am
I am working on an article, but here is my ActiveX script that I use:
http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=74
Steve Jones
September 12, 2001 at 10:45 am
September 12, 2001 at 10:36 am
Haven't worked with multiple instances. I'd test on the 2nd instance and move to the first for production. The naming is more complex for 2nd instances, so if it works...
September 12, 2001 at 10:34 am
Try this:http://www.sqlservercentral.com/columnists/rsharma/copydatabase.asp
Steve Jones
September 12, 2001 at 10:30 am
The v7 Design test was harder than the v2000 test, IMHO. I took both within a few weeks of each other. Of course, I work in 2000 most of the...
September 12, 2001 at 10:25 am
I have a few refs:
BOL:Placing Tables on Filegroups
BOL:Using Files and Filegroups
Inside SQL Server - Doesn't really discuss, but recommends not too unless advanced DBA, knowedg of DB, etc. Does note...
September 11, 2001 at 9:16 am
I'd apply the KISS principle. Setup two tasks and let one grab records for TableA, ignoring other records. Let the 2nd grab records for TableB and ignore the others. Might...
September 10, 2001 at 10:30 am
Viewing 15 posts - 39,601 through 39,615 (of 39,754 total)