Viewing 15 posts - 2,236 through 2,250 (of 3,060 total)
Just a couple of questions...
- how many rows are stored on DATE_SAMPLE table?
- how many rows is supposed to retrieve a tipical query on SAMPLE_DATE column?
- Are queries range-filtering on...
_____________________________________
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.January 19, 2010 at 6:44 am
baghel_ramdas (1/15/2010)
...now I understand who can evaluate a DBA?My answer is - only experienced DBA can.
:blink: Was this a surprise?
_____________________________________
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.January 15, 2010 at 1:22 pm
Francisco Rosado (1/11/2010)
i want to search a word infor in the entire db
Do you realize this business requirement does not makes any sense?
_____________________________________
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.January 15, 2010 at 5:59 am
nuno.luz (1/15/2010)
Vania...
_____________________________________
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.January 15, 2010 at 5:52 am
It's never a good idea to connect to Oracle using either SYS or SYSTEM account just to select from some tables.
Ask your Oracle DBA to create an account for migration...
_____________________________________
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.December 29, 2009 at 9:53 am
stewartc-708166 (12/28/2009)
However, for large volumes and/or complex transformations (e.g. check for existence,...
_____________________________________
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.December 29, 2009 at 9:46 am
bodhilove (1/13/2009)
... you can do an etl between 2 oracle databases using SSIS SQL 2008.
why would you want to add SS overhead to ETL process?
_____________________________________
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.December 28, 2009 at 2:53 pm
In my experience is always better "to pull" rather than "to push" data in between environments.
Having said that, if the business requirements ask to move data from SQL Server to...
_____________________________________
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.December 11, 2009 at 6:31 am
You can replicate a single table if you want - even a subset of a single table.
_____________________________________
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.December 8, 2009 at 11:40 am
Chris Morris-439714 (12/7/2009)
This is similar to expressing doubt regarding the appropriate use of wheels and wings on an aircraft!
😀 You made my day -- best part is, you are...
_____________________________________
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.December 7, 2009 at 6:56 am
:pinch: that's too confusing, I could understand neither the scenario nor the question.
Could you clarify? pretty please?
_____________________________________
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.December 5, 2009 at 5:31 pm
zaebis 88446 (11/17/2009)
I am concerned about infinite expantion of my DB.
How about a purge strategy?
_____________________________________
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.December 5, 2009 at 5:00 pm
Melissa.Fischer (10/14/2008)
Depending on what datatype you use the exclusion of address ranges can get tricky.
:blink: why? anything is cast(able)
_____________________________________
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.December 5, 2009 at 4:56 pm
I just love questions that include the answer.
As stated uou already have the volume metrics, trust the data 😉
_____________________________________
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.December 5, 2009 at 4:51 pm
SQL_Quest-825434 (12/5/2009)
I know that this can be done by using string functions in SSIS.
... not really.
Why not relly on concatenate? you know: +
_____________________________________
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.December 5, 2009 at 4:47 pm
Viewing 15 posts - 2,236 through 2,250 (of 3,060 total)