Viewing 15 posts - 2,536 through 2,550 (of 3,060 total)
Diamond Mouse (5/20/2009)Can you please explain which table can be a suitable candidate for partitioning?
As already posted you may want to consider table partitioning in one of both of 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.May 21, 2009 at 11:25 am
Tara (5/20/2009)How would i test all my scripts to check every rule in the script is working perfect.
Carefully? 🙂
Welcome to the ancient art of building a testing environment.
You have 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.May 20, 2009 at 3:23 pm
pradyothana (5/19/2009)
Need a Defragment Script with out using Cursors.
:w00t: Is perhaps Microsoft licensing "cursors" as a non-standard option now?
Don't put ideas like that one in their heads! 😀
_____________________________________
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.May 19, 2009 at 12:42 pm
Most likely either a networking or application issue; check error log.
_____________________________________
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.May 19, 2009 at 12:38 pm
By including functions in a query add overhead.
Picture the scenario below for a 10M rows myTable table...
select column-a
from MyTable
Query does a full table scan on 10M rows MyTable,...
_____________________________________
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.May 19, 2009 at 12:33 pm
Rem (5/19/2009)What are the best practice when you have huge databases? Like Walmart for example?
Real world DWH environments do not include a "staging" database that somehow would be later...
_____________________________________
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.May 19, 2009 at 8:05 am
koosubscriptions (5/18/2009)...so that I can get the exact form data at any given time.
This is what Oracle calls flashback query -a feature packed with Ora10g
Hard to accomplish such a thing...
_____________________________________
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.May 19, 2009 at 7:59 am
Described scenario looks more like a reporting database than a data warehouse.
Here is where you can start.
1- Read and understand Kimball's approach.
2- Read and understand Inmon's approach.
3- Choose
4- Assuming 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.May 19, 2009 at 7:53 am
A 2M rows table can be considered a small one.
Question would be: what's the reason why you may want to partition such a table? is it performance?
Working with such 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.May 19, 2009 at 7:47 am
Switch the server -actually, switch the access path to the server.
Do not call them production and staging, call them Reporting-1 and Reporting-2.
Today Reporting-1 is exposed as production while Reporting-2 is...
_____________________________________
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.May 18, 2009 at 1:26 pm
We do have a home grown monitoring application to do that -unfortunately (for you) this is propietary code so I can't share it.
On the other hand I can tell 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.May 18, 2009 at 1:20 pm
My suggestion would be to look at Data Warehouse design before looking at the ETL tools.
There are two different approaches for Data Warehouse design; the original authors are Ralph Kimball...
_____________________________________
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.May 18, 2009 at 11:08 am
well... original post said nothing about a tnsnames based connection then everybody started talking about ODBC then you asked where to set some option and at that time I answered...
_____________________________________
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.May 15, 2009 at 3:09 pm
I do not have my old SQL Server 7.0 scripts at hand but check what Pop Rivett has to say http://www.simple-talk.com/sql/backup-and-recovery/pop-rivetts-sql-server-faq-no.4-pop-does-log-shipping/ 😉
_____________________________________
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.May 15, 2009 at 2:46 pm
This is not an Oracle issue, this is a Windows issue.
Open ODBC Data Source Administrator
Select the offending Data Source
Click Configure
Check "Force Retrieval of Long Options" option.
Click OK
Click OK
_____________________________________
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.May 15, 2009 at 12:15 pm
Viewing 15 posts - 2,536 through 2,550 (of 3,060 total)