Viewing 15 posts - 31 through 45 (of 45 total)
Have you tested the Oracle ODBC connection with something like MS Access? What version of the Oracle ODBC driver are you using?
June 25, 2003 at 12:06 pm
FYI, in SQL Server the trigger fires once, reguarless of the number of rows effected. So you may want to walk the inserted table with a cursor.
June 25, 2003 at 12:05 pm
It will decrease the size of your errorlog since there will be fewer messages and it should improve performance a bit. As for the transaction log, I have no idea.
Henry
...
June 25, 2003 at 11:57 am
Embarcadero ERStudio, you can download a x day demo that at least used to have the documentor enabled. It gives you a lot of information and it can save...
June 25, 2003 at 9:29 am
No problem. 5.5 GB of temp spaced used? How big is the Oracle DB just out of curiosity.
June 24, 2003 at 9:03 am
expand the Temporary tablespace....
ie
create temporary tablespace temp
tempfile '/whatever/temp03.dbf' size 300M
extent management local;
June 24, 2003 at 7:36 am
Ok I guess all the links are covered. So here is my $.02.
Oracle features I wish SQL Server had
-- Function based indexes
-- Read locking model
-- Java stored procedures
Let the debate...
June 24, 2003 at 7:31 am
If the table is going to take up more than a couple of pages, use a clustered index. Otherwise you can get a 'heap' where the query hops all over...
June 23, 2003 at 1:57 pm
Version of SQL Server? What version is the ODBC driver? So really old (3+ years) versions of the driver used to toss these errors all the time.
June 23, 2003 at 1:55 pm
Ok, some thoughts about why you shouldn't put them in the DB. I will grant you this is a bit old school in thinking but it is something to...
June 23, 2003 at 1:52 pm
I guess the question would be, why store it in the database at all. Unless you are going to query the field, why not just store it in a...
June 22, 2003 at 6:04 pm
Just make sure it does not take a snapshot in time and comapre it to another snapshot in time otherwise you may take out users you don't mean to.
For...
June 20, 2003 at 10:43 am
Depending on the hardware the machines are running on, version of Oracle, version of the ODBC driver that rate seems reasonable. You are bringing back 875,000 rows. That is...
June 20, 2003 at 10:24 am
Do you get the error right away or during the CURSOR_TBLDEF loop? If is is during CURSOR_TBLDEF loop perhaps SQL is grabing a big chunck of the syscomments...
June 19, 2003 at 9:33 am
FYI: You can get a problem like this is the colation is different on tempdb that your db if you are joining on a temp table.
June 19, 2003 at 9:27 am
Viewing 15 posts - 31 through 45 (of 45 total)