Viewing 15 posts - 16 through 30 (of 30 total)
We started investigating the new SQL2005 Snapshot isolation level and so far are encouraged by the results.
From experience on 2000 and 2005 we found:
1 - Indexes need a lot of...
January 4, 2006 at 10:30 pm
An SQL Server linked server will point only to one Oracle Instance, so, you have to create another linked server to access another instance. But, to query another user table...
December 5, 2004 at 10:32 pm
I am not sure w2003 loadbalancing is meant to works with sql servers.
What you can do is :
1 - Make the 2 db servers are identical in schema and...
August 8, 2004 at 12:21 am
Data Tolerance means , if one instance fails, e.g. the active server gets dis-connected from the network or crashes, then the other[passive node] will become active and take the load....
August 3, 2004 at 11:42 pm
Product Name IBMDADB2, and can be anything really.
Data Source normally this is the DB2 DBname
Provider String can be something like
"Provider=IBMDADB2;Database=dbname;hostname=dbserver; port=dbserverport;protocol=TCPIP;uid=dbusername; pwd=db2pass"
June 16, 2004 at 12:56 am
Do you mean you have a Web Server that links to an SQL DB using JDBC and you want to expose the DB2 server from SQL? If so, then, search SQL...
June 16, 2004 at 12:41 am
Triggers are ONLY fried as a result of an SQL DML, i.e. insert, delete or update. In your case it will be fired by an update on the table.
You can...
May 29, 2004 at 11:15 pm
Not all versions of oracle support timestamps/datetime with .999999 fractions of a second . Only Oracle 10G and may be 9i ..The older versions do not even have fractions of...
April 19, 2004 at 1:16 am
WOW
The things vendors do to get money !
1 - I would not allow this unless the vendor agrees to tweak the client to use views, stored procedures to write to...
January 16, 2004 at 11:02 pm
Becuase their development cycle on such expensive platforms!
We have DB2/SQL/Oracle and the SQL DBAs are the fastest to accept change and execute new requests. And having DTS at their disposal,...
December 11, 2003 at 11:49 pm
Calivn,,
Sorry for my many typos...
Just to shed more light on the subject: for those, and we do it also, who need to move a lot of data from an OLTP...
December 6, 2003 at 10:32 pm
Hi Calvin,
You can use MS Host Integration Server2000 for the job. It comes with utilities and drivers for the purpose. If you are going to work with AS400 files rather...
December 4, 2003 at 2:04 am
I have msSQL2000-SP3/Win2003 setup as a gateway (sort of - copying OLTP trx from mainframe to a custome Oracle8i) ... To resolve netwoking issues and Oracle mis-administration, i setup a...
September 4, 2003 at 6:41 am
I may add, for a seriuos production situation, and if you can afford it a SAN box would be the way to go. Dedicate a spindle for logs with RAID...
February 10, 2003 at 1:24 am
We use MS HIS2000 for APPC/LU6.2 connectivity to OS390/DB2 V6 with MS OLEDB for DB2. We developed a DTS package that reads data off DB2 tables using a timestamp to...
September 15, 2002 at 10:48 pm
Viewing 15 posts - 16 through 30 (of 30 total)