Viewing 15 posts - 856 through 870 (of 3,061 total)
Ali Tailor (8/16/2011)
I am working as Jr. SQL DBA, I want to know that, the learning Informatica is useful for me:-). means, Is Informatica is useful for SQL DBA?
It depends...
-...
August 17, 2011 at 2:02 pm
amir.mochtar (8/17/2011)
i just need help, i have problem when binding value in an input variable with pl/sql script in SSIS package.
here the...
August 17, 2011 at 1:59 pm
tajinder42-663112 (8/12/2011)
August 14, 2011 at 4:15 pm
tajinder42-663112 (8/12/2011)
CREATE TABLE UCS_USER...Error messages:
• ORA-00955: name is already used by an existing object (Source: MSSQL_REPL_ORACLE, Error number: 955)
From the Oracle point of view the operation is attempting to create...
August 12, 2011 at 12:35 pm
Bill Talada (8/9/2011)
... but DBAs tend to stick to Codd's rules of normalization.
May be this is because Codd put together the basics of the Relational Theory and we are dealing...
August 12, 2011 at 12:14 pm
Greg Snidow (8/8/2011)
The Oracle concept of database is pretty different from the SQL Server concept of it, in simple terms - if you have an Oracle instance up and running...
August 12, 2011 at 7:56 am
Resender (8/10/2011)
For a client we have to transfer an ERP database from an Oracle environment into SQL Server 2008.
We have been using the SQL Server Assistant Manager for Oracle...
August 12, 2011 at 7:48 am
sbelche-760308 (8/8/2011)
Thanks for the info. I'll download it and see if I can connect to our Oracle db. From what I've read, once I set the subquery to return...
August 8, 2011 at 5:51 am
Greg Snidow (8/6/2011)
August 8, 2011 at 5:31 am
Only SQL Server database sizes? That's discrimination! 😀
August 6, 2011 at 12:44 pm
It all depends of how hard you hit ODS tables.
In my particular experience ODS tables are heavily hit during a very short window therefore in such an scenario reserving a...
August 6, 2011 at 12:37 pm
I would say subquery has a problem, forcing the query to update using the first row returned may be just hidding a bigger issue.
Be sure subquery's predicate is good enough...
August 6, 2011 at 12:25 pm
Resender (8/3/2011)
I'm doing an import of quite a large database via a dmp file,...
August 6, 2011 at 12:21 pm
Define Oracle Database as a linked server of SQL Server database.
Write the script needed to update as required by business rules.
Schedule a job that runs the script, be sure you...
August 6, 2011 at 12:15 pm
SSNEW (7/26/2011)
I am good reader for this forum but never posted much on this.I finished my Masters in dec 2007...
August 2, 2011 at 12:41 pm
Viewing 15 posts - 856 through 870 (of 3,061 total)