Viewing 15 posts - 39,181 through 39,195 (of 39,466 total)
October 23, 2001 at 2:37 pm
October 22, 2001 at 11:18 pm
Yes, even poorly written apps will benefit from the enhancements to the storage and query engines. If you have a poorly designed app with lots of embedded sql, the server...
October 22, 2001 at 10:55 pm
The probklem is your last line. This is returning a value, not removing the last ,.
Is should read:
select @r = substring( ...
Steve Jones
October 22, 2001 at 3:48 pm
October 22, 2001 at 2:21 pm
You would do well to script the database DDL and then ensure it conforms to Oracle standards. Not sure, but I doubt the DTS tools will generate Oracle compliant statements.
For...
October 22, 2001 at 2:19 pm
October 22, 2001 at 2:17 pm
I concur with Andy. You probably want to avoid this. You are assuming you know more than the program for a particular statement, which may not be true for different...
October 22, 2001 at 2:05 pm
You would need some column in your table that has a datetime field. Or join to a table that has some date time field. There is no marking in SQL...
October 22, 2001 at 11:53 am
Any solution is going to through a load somewhere. I assume this is a one time thing. I wouldn't worry about the source load. Personally, I'd rather move the entire...
October 22, 2001 at 11:50 am
If you set this to true, then every minute or so, a checkpoint occurs. The transaction log is then truncated.
Example:
0800 DB full backup
0805 write transaction 1
0806 Check point, log cleared...
October 22, 2001 at 10:42 am
Also, what is the IO structure and the Index structure. You many have too many indexes. If you rebuild the clustered index, then you will be moving all the data...
October 22, 2001 at 10:41 am
You can have multiple data transform tasks between the connections. You need a separate "query" for each to get different data.
Steve Jones
October 22, 2001 at 10:37 am
Does it work from the local server? If it does, then this doesn't make sense.
Steve Jones
October 22, 2001 at 10:35 am
Yes. With v7., the query engine was substantially enhanced. Some more improvement in 2000. At this point, you should run 2000. You can set a db to run as...
October 22, 2001 at 10:34 am
Viewing 15 posts - 39,181 through 39,195 (of 39,466 total)