Viewing 15 posts - 856 through 870 (of 3,060 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...
-...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.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...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.August 17, 2011 at 1:59 pm
tajinder42-663112 (8/12/2011)
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.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...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.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...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.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...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.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...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.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...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.August 8, 2011 at 5:51 am
Greg Snidow (8/6/2011)
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.August 8, 2011 at 5:31 am
Only SQL Server database sizes? That's discrimination! 😀
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.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...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.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...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.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,...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.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...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.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...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.August 2, 2011 at 12:41 pm
Viewing 15 posts - 856 through 870 (of 3,060 total)